Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ksn
 
Posts: n/a
Default Opening excel creates an error message or opens Book 1

I want excel to open without Book 1. Following the thread below solves only
part the problem.



This works for opening only excel, but does not appear to work when one
double clicks on an existing excel file to open. I still get the Book 1 when
this is done. The /automation modifier does not seem to help either.

Our IT people put in a shortcut in the C:\Program Files\Microsoft
Office\OFFICE11 directory with the /e /automation switch. The Control
Panel/Folder Options/File Types was modified to open excel using this
shortcut. Now, unless Excel is already open, a double click of an existing
file gives a series of files not found errors. It seems to stumble over the
spaces in the file structure such as between the word DOCUMENTS and the word
AND when looking for a file in C:\Documents and Settings\Excel........ It
says it cannot find the file Documents.xls.

The /e used to work in older versions either with excel only or by double
clicking on a exisitng file. Either way, no Book 1 ever appeared. I am
after this same functionality.


ksn


"Dave Peterson" wrote:

Modify the shortcut (or create an new shortcut) that points at excel.exe, but
add " /e" (w/o the quotes) to the end of the target.

For me (xl2003), my target would look like:

"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e



Jwhite wrote:

How do I set Excel to not load/create a "New" Book1, Book2, etc... whenever I
open Excel?


--

Dave Peterson


--
ksn
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again.

If this doesn't work try to re-register Excel

Close Excel first and
On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.

One more thing to try if any of the above brings no joy.........

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 Fri, 24 Jun 2005 15:25:02 -0700, ksn wrote:

I want excel to open without Book 1. Following the thread below solves only
part the problem.



This works for opening only excel, but does not appear to work when one
double clicks on an existing excel file to open. I still get the Book 1 when
this is done. The /automation modifier does not seem to help either.

Our IT people put in a shortcut in the C:\Program Files\Microsoft
Office\OFFICE11 directory with the /e /automation switch. The Control
Panel/Folder Options/File Types was modified to open excel using this
shortcut. Now, unless Excel is already open, a double click of an existing
file gives a series of files not found errors. It seems to stumble over the
spaces in the file structure such as between the word DOCUMENTS and the word
AND when looking for a file in C:\Documents and Settings\Excel........ It
says it cannot find the file Documents.xls.

The /e used to work in older versions either with excel only or by double
clicking on a exisitng file. Either way, no Book 1 ever appeared. I am
after this same functionality.


ksn


"Dave Peterson" wrote:

Modify the shortcut (or create an new shortcut) that points at excel.exe, but
add " /e" (w/o the quotes) to the end of the target.

For me (xl2003), my target would look like:

"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e



Jwhite wrote:

How do I set Excel to not load/create a "New" Book1, Book2, etc... whenever I
open Excel?


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening an Excel template from a 3rd party app TonyL Excel Discussion (Misc queries) 2 June 15th 05 02:05 AM
existing excel file when clicked opens blank excel document snows_24 Excel Discussion (Misc queries) 1 May 21st 05 07:15 PM
When opening an existing workbook, Excel opens but not the workbo. llhughes Excel Discussion (Misc queries) 1 February 12th 05 08:41 PM
Excel opens all files in My Documents on launch Stilson New Users to Excel 2 December 24th 04 01:52 AM
Mexport transfer from another program to excel opens at excel lau. DanetteS Excel Discussion (Misc queries) 1 December 1st 04 12:27 AM


All times are GMT +1. The time now is 01:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"