From Access, "save as" an open Excel workbook with a new file path and name.
Posted on 2014-03-27
I have used VBA in Access to open an Excel 2010 workbook, "FileName", and I worked with the Excel workbook.
Then I switch to my Access 2010 window and want to click on a button which will then save the Excel file with a new uniquely coded name "NewFilePath", which Access has calculated automatically.
As mentioned above, in my case the present name of the Excel file is known as a variable "FileName" in the Access code.
1) What is the code to save this file "FileName" as "NewFilePath"?