Copy excel file to default user temp folder.

[pedie]

Hi, can vba make out user's temp path and copy file from E:\Personal_Files\myvba.xlsm to window's temp folder and then open the file?

Thanks and regards
Pedie

 

[Ruddles]

The user's TEMP folder is Environ("TEMP"), so this would copy the file to the TEMP folder:-

[FONT=Courier New]FileCopy "E:\Personal_Files\myvba.xlsm", Environ("temp") & "\myvba.xlsm"[/FONT]

Then I suppose you'd just do:-

[FONT=Courier New]Workbooks.Open Environ("temp") & "\myvba.xlsm"[/FONT]

Before doing the FileCopy I would probably delete the file from TEMP if it's already there:-

[FONT=Courier New]If Dir(Environ("temp") & "\myvba.xlsm") <> "" Then [/FONT][FONT=Courier New]Kill [/FONT][FONT=Courier New]Environ("temp") & "\myvba.xlsm"[/FONT]

And I'd probably Kill it once I'd finished using it.

But then I'm a Virgo.

 

[pedie]

Ruddles, exactly what I wanted..
Thank you for sharing the code.

Regards
Pedie

 

[Ruddles]

 

[pedie]

I was just watching "The Simpsons" just before i show your reply