I am a novice at this stuff and have been on this for a big part of the day and it is driving me
I have a master workbook with 8 worksheets that are exported, as required, in pairs. I have tried to create
a macro that will export these (to a new workbook) and autosave them to a directory, with a file name incorporating cell
value "A2" of one of the worksheets.
so the example below shows what i have been using, with the two
worksheets i'm exporting being "SW Field Sheet" and "EDMS_SW". "SW Field Sheet" contains the
cell reference i want included in the output file name.
This worked at one stage, but has not since. Whats wrong?
Is the reference to "SW Field Sheet""A2" unclear?
' SWevent Macro
' Keyboard Shortcut: Ctrl+s
Sheets(Array("SW Field Sheet", "EDMS_SW")).Select
Sheets(Array("SW Field Sheet", "EDMS_SW")).Copy
ActiveWorkbook.SaveAs Filename:= _
"Z:CLER_50ReportsR_" & ActiveSheet.Range("A2").Value & "_050_SW Field
, FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
Windows("FS_100204_50_Field Monitoring Sheet MASTER v5.xlsm").Activate