Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Book 1 auto opening
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Book 1 auto opening
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace Book 1 When Opening File in Excel | Excel Discussion (Misc queries) | |||
excel crash when opening work book | Excel Discussion (Misc queries) | |||
How I stopped a Book 1 opening with existing files | Excel Discussion (Misc queries) | |||
How do I stop Book 1 opening with existing files? | Excel Discussion (Misc queries) | |||
Re opening Excel 2000 lost work book | Excel Programming |