Recognizing the Active Directory

[keith0528]

Greetings,

I have an excel file that is copied into directory Y from directory X. When I run this code


sFile = ActiveWorkbook.Path & "\" & sFile

It still references directory X. How can i get it to recognize that it now resides in directory Y?


thanks

 

[JLGWhiz]

You need to use the FileCopy method. For moving between directories, the full name (includes path) needs to be used for source and destination;
Eample:

FileCopy("C:\Temp\Data.xlsx", "C:\xlFiles\Data.xlsx")
Kill "C:\Temp\Data.xlsx"