Move File When The ...

  • Thread starter Thread starter sal21
  • Start date Start date
S

sal21

MOVE FILE WHEN THE WBook it is opened.

i have this file in:

E:\EPF\PORTAF_132.EPF

my prob is to move this in the another dir named E:\EPFBK\ when th
WBook it is opened and rename the file in PORTAF_132_(date).EPF

Final result:

E:\EPFBK\PORTAF_132_18022004.EPF


after initial dir E:\EPF\ is blank..
 
Sal

Name "C:\Dick\Book2.xls" As "C:\Dick\Tester\Book2" & Format(Now, "ddmmyyy")
& ".xls"

The Name statement renames the file and puts into a different directory if
neccessary. Use the Format function on a date to get the date format you
want in the file name.
 
Back
Top