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..

--
Message posted from http://www.ExcelForum.com

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.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"sal21 " wrote in message
...
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 the
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...


---
Message posted from http://www.ExcelForum.com/