D
doug
Thanks. Tried this but this simply closes the active
worksheet without saving it. I do need to overwrite the
existing csv file each time the macro is run.
The macro I had is as follows:
Range("A1").Select
Workbooks.Open Filename:= _ "Worksheet 2.csv"
Windows("API model Worksheet 1.xls").Activate
Range("A17").Select
Selection.Copy
Windows("Worksheet 2.csv").Activate
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
Range("A2").Select
Application.CutCopyMode = False
Workbooks("E9B.csv").Save
ActiveWindow.Close
Range("A1").Select
Answering Yes to the resulting pop up message(detailed
below) results in the SAVE AS box being displayed.
worksheet without saving it. I do need to overwrite the
existing csv file each time the macro is run.
The macro I had is as follows:
Range("A1").Select
Workbooks.Open Filename:= _ "Worksheet 2.csv"
Windows("API model Worksheet 1.xls").Activate
Range("A17").Select
Selection.Copy
Windows("Worksheet 2.csv").Activate
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
Range("A2").Select
Application.CutCopyMode = False
Workbooks("E9B.csv").Save
ActiveWindow.Close
Range("A1").Select
Answering Yes to the resulting pop up message(detailed
below) results in the SAVE AS box being displayed.