How to move an Excel file to another folder

  • Thread starter Thread starter Akilah
  • Start date Start date
A

Akilah

Hi, I have a function that reads in an excel file and does a process in the
Access database. I want to know is there a way to move that file to another
folder when the process is done. Thanks in advance.
 
Hi, I have a function that reads in an excel file and does a process in the
Access database. I want to know is there a way to move that file to another
folder when the process is done. Thanks in advance.
Click to expand...

You could use the Name property to either change the file name or move
it.

Sub RenameDb()
' Rename and/or move a database or a spreadsheet
Dim OldName As String
Dim NewName As String
OldName = "C:\CurrentPath\SpreadsheetName.xls"
NewName = "C:\NewPath\SpreadsheetName.xls"
Name OldName As NewName

End Sub
 
Thanks, I will try that.

fredg said:
You could use the Name property to either change the file name or move
it.

Sub RenameDb()
' Rename and/or move a database or a spreadsheet
Dim OldName As String
Dim NewName As String
OldName = "C:\CurrentPath\SpreadsheetName.xls"
NewName = "C:\NewPath\SpreadsheetName.xls"
Name OldName As NewName

End Sub
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 7 Task Scheduler to Move(Cut) files from one drive to another within Same PC 1
Excel How to Fix Damaged Excel File That Won't Open? 3
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Moving Router 2
Excel Protection 2
Downgrading from Windows 11 1
Excel Spreadsheets keep moving 0
Change paths to linked external data 3

Back
Top