MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel opens blank workbook


Posted by cg on December 19, 2000 10:22 AM

When opening an existing Excel file, a blank book1 opens, then the selected file opens on top of it.
There is nothing in the alternate startup location.
I have also tried adding " /e" at the end of the target("C:\Program Files\Microsoft Office\Office\EXCEL.EXE" /e).
Any other suggestions on getting rid of this nuisance?


Posted by David on December 19, 2000 11:44 PM

i do this by putting this in the "thisworkbook" section

If (wrkbook.Name = "Book1") Or _ (wrkbook.Name "Book2") Then
wrkbook.Saved = True
wrkbook.Close
end if