Book 1 auto opening

[Mark Goulty]

Using VB on a NT platform, I open an Excel file from an
Access Database. The problem is that not only the
requested file opens, but also Book1.xls as well. How do
I stop Excel opening 2 fles, the requested one and a
Book1.xls?
Any help would really be appreciated.
Many thanks

 

[Gord Dibben]

Mark

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 (delete the <sp>/e if
you want Book1 to open).

You must have the double quotes.

Below have "use DDE" checked and this in the DDE message box....[open("%1")]

Application should read "Excel"(no quotes)

Gord Dibben Excel MVP

 

[Mark Goulty]

Gord,
Many thanks for the response.
I'm working on Windows NT. I've looked for a similar path and
properties etc, but can't find that which you refer to. Any ideas.
Thanks again for your help so far, I really appreciate it.
Mark



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!