View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Book 1 auto opening

Mark

Go to StartSettingsFolderOptionsFile 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"OpenEdit.

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

On Tue, 15 Jun 2004 08:44:31 -0700, "Mark Goulty"
wrote:

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