Open New Workbook / Save and Close Current Workbook

J

Joe K.

I would like to created a script to open the new workbook that I created.
Also in the script to save and close the active workbook.

Listed below are the parameters that I used to create the new workbook.

Thanks so much for the help.

With ActiveSheet 'New PRINT ORDERS Sheet in New Workbook
.Parent.SaveAs Filename:=ActWkbk.Path & "\" & "SEND_MAJORS_" & _
".xls"
'' Format(Now, "yyyyddmmhhmmss") & ".xls"
'
.Parent.Close savechanges:=False
End With
 
J

JLGWhiz

You would have to run your code from a personal workbook. If you try to run
it from the active workbook, it will stop when you close the active workbook.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic Open Created Spreadsheet 4
problems getting this macro to work 23
Close a workbook 4
.Parent.SaveAs Filename: Without Prompting To Replace File 1
Save As and new workbook new name used in existing code 8
Open and Save Files in Directory 1
Close current workbook 1
Check if workbook open (Not working) 3

Top