I sent this before but received an error so I am not sure it went through.
I hope I am not asking a simple question thats been responded to numerous times but a quick search did not show anything like I needed to know for my problem.
Example:
I have workbook "ABC" in a folder "123". I need a macro in workbook "ABC" to "save as" the open workbook into folder "456" with the same file name as the open workbook. I also need a notation made in a cell of each of the workbooks showing the workbook has been copied after the save as command has completed. I have gotten most of this to work with the excemption of being able to save the new workbook in a different folder with the same file name as the open workbook. Workbook "ABC" will have various saved file names with the same macro copied into them, so the save as macro will need to be able to refer to the file name or a cell within the file to use as the name for the new file in the second folder.
Anybody have any suggestions or need clarification of what I am talking about?
Thanks
This message was edited by Saa62 on 2002-03-21 16:48
I hope I am not asking a simple question thats been responded to numerous times but a quick search did not show anything like I needed to know for my problem.
Example:
I have workbook "ABC" in a folder "123". I need a macro in workbook "ABC" to "save as" the open workbook into folder "456" with the same file name as the open workbook. I also need a notation made in a cell of each of the workbooks showing the workbook has been copied after the save as command has completed. I have gotten most of this to work with the excemption of being able to save the new workbook in a different folder with the same file name as the open workbook. Workbook "ABC" will have various saved file names with the same macro copied into them, so the save as macro will need to be able to refer to the file name or a cell within the file to use as the name for the new file in the second folder.
Anybody have any suggestions or need clarification of what I am talking about?
Thanks
This message was edited by Saa62 on 2002-03-21 16:48