autostart macro???

[VHFlores]

how do i make an autostart macro, so that every time excel opens, the macro runs before anything else happens?
My real problem is that i dont like the default formatting for the columns. i just want to make all columns text!
row 1 '006' (excel thinks its a 6...BAD)
row 2 '201' (excel thinks its a 201...good)
row 3 '0GZ' (excel thinks its 0GZ...good)

if i then format the column as text, i can never turn the 006 in row 1 into a 006
This may be because i'm reading a file. A CSV file. The csv file has "006" , yet i cant
get it to show 006.

if excel opened/set all columns (well, a reasonable number) to text.../then show the data on the spreadsheet...everything would be cool

 

[Al Chara]

Do a search on this site for auto start macros. You can put the code in the Workbook_Open event of the specific workbook, or save it to your personal.xls in the Workbook_Open or some other event and have it triggered everytime another workbook is opened, or you can save it as an add-in so it is loaded everytime excel is opened. You have many options here.

 

[klb]

Make all the changes you want in a blank workbook. Then save the file twice.

First as "sheet.xls" - this sheet will open every time you start Excel.

Save it a second time in your xlstart directory as a template named "Book.xlt". This will then open whenever you want to open a new worksheet.

Good luck.