Well I need a little help being a VBA novice.
I am attempting to save a sheet named Summary from a workbook named RPSDATAFILE.xlsm to a closed workbook named TestDataSheetASX1.xlsx before sheet 1.
I have used this vba code in Module 4 which appears to work –
The issue I have is that I am running a code in the open workbook RPSDATAFILE.xlsm that runs an application on time for other modules as below
When the open workbook code runs it performs the first 4 application on times however when it runs the module to copy the sheet I get the following error message.
Cannot run the macro ‘sb_Copy_Save_Worksheet_As_Workbook() The macro may not be available in this workbook or all macros may be disabled.
I think that the macro loses focus to the open workbook code when it runs the copy.
Any suggestions would be appreciated.
Bookmarks