macor in excel 2007

[radom]

Hi all what i need is every time i open this file it imports a text file i got it useing a key but i need to know how to do it upon opeing the file .

[kadghar]

Hi all what i need is every time i open this file it imports a text file i got it useing a key but i need to know how to do it upon opeing the file .

inside some sheet's VB code, you can manage the sheet's events. Try with the Calculate one, something like this will do:

[CODE=vb]private sub worksheet_calcu late()
'your code
end sub[/CODE]

press Alt+F11 to enter the VBA editor, and double click in any worksheet in the project explorer (it should be in the upper left corner)