speedy dave
04-02-2010, 09:23 PM
Hi guys, could someone please enlighten me on the code to save the workbook to the current workbooks location.
I have a workbook that has a macro button that saves the current workbook as "filename & Date & time.xlsm"
I need it to be able to save the updated workbook to the same location that the original workbook is in, regardless of the folders name that it is saved in.
What i mean is that if the workbook is saved to "c:\terry\files , the code will save the updated workbook to c:\terry\files,
BUT
if Anne saves the workbook onto her computer in, say, c:\anne\files, then the code will save the updated workbook on Annes computer to c:\anne\files
This way, it does not matter where anybody saves the original workbook on their computer, the macro does not need to be changed to suit that computer.
You could just have a folder on the desktop with the original workbook in it. All subsequent "macro" saves will put the updated workbooks into that same folder on the desktop.
Thanks in advance
Speedy Dave
I have a workbook that has a macro button that saves the current workbook as "filename & Date & time.xlsm"
I need it to be able to save the updated workbook to the same location that the original workbook is in, regardless of the folders name that it is saved in.
What i mean is that if the workbook is saved to "c:\terry\files , the code will save the updated workbook to c:\terry\files,
BUT
if Anne saves the workbook onto her computer in, say, c:\anne\files, then the code will save the updated workbook on Annes computer to c:\anne\files
This way, it does not matter where anybody saves the original workbook on their computer, the macro does not need to be changed to suit that computer.
You could just have a folder on the desktop with the original workbook in it. All subsequent "macro" saves will put the updated workbooks into that same folder on the desktop.
Thanks in advance
Speedy Dave