I have workbookA on a network folder which when opened shows a splash screen form & does a bunch of stuff, and then opens workbookB (a larger file) on the users local folder.
When workbookB opens I need it to close workbookA. I've tried so many ways to close it but keep getting 'subscript out of range'.
Please help! I am using Excel 2010
WORKBOOKA code:
Private Sub Workbook_Open() formSplash.Show vbModeless Call mybigmacro formSplash.Hide Workbooks.Open "S:\WORKBOOKB.xlsm" 'ThisWorkbook.Close False End Sub
WORKBOOKB code:
Private Sub Workbook_Open() Workbooks("C:\rmtcheck1.xlsm").Close False 'this is where I get the error end sub
Bookmarks