Update Excel File name using a Access Module

MaDoyle

Registered User.
Local time
Today, 00:43
Joined
May 2, 2008
Messages
11
I hope some can help

I was wondering if it is possible to rename a file in excel using a module in access.

I have a report populated on a daily basis and i want to rename the report and then move the report to a new location
 
Simple Software Solutions

Bit confusing

I was wondering if it is possible to rename a file in excel using a module in access.

I have a report populated on a daily basis

Are we now talking about reports or Excel workbooks?

i want to rename the report and then move the report to a new location

What are you renaming and moving?
 
you can rename any diskfile by the access command

name oldname newname

this will copy to a different drive, (I think!) or move on the same drive
oldname/newname include folders

see help for more details
 

Users who are viewing this thread

Back
Top Bottom