Innovation through Creation - Flash | PHP | HTML | XML | CSS | SQL - By Eliott Robson

Posts tagged Microsoft

Excel macro to save a sheet as a CSV file

Jan13
2011 Leave a Comment Written by Eliott

Just in case you ever wanted to save a sheet as a CSV file.

The setup is as follows:

A B C D
1 Name Address Phone Email
2 Test User Test House, Test Lane, Test City, Test County, TE01 2ST 01234567890 Test@email.com

And the macro:

Sub ConvertToCsv()
	'
	' ConvertToCsv Macro
	' Macro by Eliott Robson (http://www.stormation.info)
	'

	Sheets.Add Type:=xlWorksheet
	ActiveSheet.Name = "CSV File"

	Sheets("Invoice").Select
	Range("A1:D2").Select
	Selection.Copy
	Sheets("CSV File").Select
	Range("A1:D2").Select
	Selection.PasteSpecial Paste:=xlValues
	Sheets("Invoice").Select

	ThisWorkbook.Save

	Sheets("CSV File").Select
	CSVPath = "C:\CSV\Files"

	CSVUniqueName = Cells(2, "A").Value
	CSVName = Format(Now(), "ddmmyyyy") & " - " & CSVUniqueName
	ActiveSheet.SaveAs CSVPath & CSVName, xlCSV

End Sub
Posted in Microsoft Junk, Tutorials - Tagged , ,

Excel macro to retrieve contacts from outlook

Jan11
2011 Leave a Comment Written by Eliott

Continuing from before

So, we managed to save details from new customers to the outlook contacts now what we want is that on a button press the user will enter the name of the saved user and the table fields will be populated:

The same table setup:

A B
1 Name Test User
2 Address Test House, Test Lane, Test City, Test County, TE01 2ST
3 Phone 01234567890
4 Email Test@email.com

and the awesome macro:
READ MORE »

Posted in Microsoft Junk, Tutorials - Tagged , ,

Excel macro to create contacts in outlook

Jan09
2011 Leave a Comment Written by Eliott

Macros? Your supposed to be cool right.

Chill – I didn’t want to learn this but while doing some work for a friend I coded this to speed up their invoice process.

Ok, so what are we doing again?

The problem they had was that collecting details from customers took too long and so he wanted a way to store details of customers and if they ordered more products he could get their data without asking again.

The following code was written for Excel 2003 and I have had issues with it on 2011.

Basically the code has been modified for the following template and I have stored the email in the job title field because outlook requests permission for the email field which halted the entire process.

Anything in bold represents data which will change and to be entered by the user.
READ MORE »

Posted in Microsoft Junk, Tutorials - Tagged , ,
1

Donate

Support the blog and help it survive.

Categories

Facebook