new book opens whit every existing file

G

Guest

Hi. I'm using excel with qi macros, but every time i open
an exsiting file from windows explorer, a new book opens
also. How can i stop the new book from staring?
Thank u
 
G

Gord Dibben

paulo

To prevent the Book1.xls opening append a <space>/e to your path.

Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.

If using WinXP OS you would scroll down to .XLS then "Advanced">Open>Edit.

In Command line the path should be similar to this....

"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e

Also make sure there is no blank book1.xls in your XLSTART folder.

Also, in Tools>Options>General delete any path in "alternate startup files
location" or "at start up, open files in"

Gord Dibben Excel MVP
 

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

Top