Simplified:
File named A saved
Macros changes some data in it and name is changed to B and saved
Want to open A while closing B
Can not get A to open
This macro saves a file full of data
#ThisWorkbook.SaveAs ThisWorkbook.Path & Application.PathSeparator & Sheet1.Range("C41") & (" - ") & Sheet1.Range("C39") & ("- Release of Draw # ") & Sheet1.Range(" C50") & ".xlsm"#
Data is then summarized as to $ paid to date, new balance.
C50 is increased by 1.
This macro then saves the updated file.
#ThisWorkbook.SaveAs ThisWorkbook.Path & Application.PathSeparator & Sheet1.Range("C41") & ("-") & Sheet1.Range("C39") & ("- Ready to insert Draw # ") & Sheet1.Range("C50") & (" data") & ".xlsm"#
I want to open the file created by the first SaveAs above and at the same time close the second
My macro to open what was save in macro 1 above that I can not get to work to open is:
#Workbook.Open filename:=Sheet1.Range("C41") & (" - ") & Sheet1.Range("C39") & ("- Release of Draw # ") & Sheet1.Range(" C50") - 1 & ".xls""#
Is there an obvious problem in my Workbook.open statement??
Bookmarks