Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 1st 05, 07:58 PM
sinistersims
 
Posts: n/a
Default Excel Shortcut Opens Visual Basic

Hello-

When I double click any of my ms excel icons/shortcuts, visual basic opens
instead of excel. I'm currently using MS Office 2000 Professional, and I'm
not sure what the problem is...I've even tried going through the excel.exe
icon. Please help me fix this issue. Thank you in advance for your
assistance.



  #2   Report Post  
Old June 1st 05, 11:18 PM
Gord Dibben
 
Posts: n/a
Default

Click on excel.exe and VBE opens.....right?

What happens if you then hit ALT + Q? Do you go to Excel window?

Couple of things to try..........

Your Excel file association may be lost.

StartRun "excel.exe /regserver"(no quotes and note the space before the /
mark).

You may have to enter your full path to excel.exe....in that case surround
with quotes as in..... "C:\mypath\to Excel\somewhere\excel.exe" /regserver

If this doesn't do the trick.............

Try to un-register first then go back to /regserver as above.

StartRun "excel.exe /unregserver"(no quotes and note the space before the /
mark).

If the above steps bring 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 Wed, 1 Jun 2005 11:58:06 -0700, sinistersims
wrote:

Hello-

When I double click any of my ms excel icons/shortcuts, visual basic opens
instead of excel. I'm currently using MS Office 2000 Professional, and I'm
not sure what the problem is...I've even tried going through the excel.exe
icon. Please help me fix this issue. Thank you in advance for your
assistance.




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
Excel formula similar to a loop in Basic? Cashtime Excel Worksheet Functions 2 February 6th 05 07:53 PM
Cancelling shortcut ctrl-click which opens "Research" in Excel 200 thebear Excel Discussion (Misc queries) 1 December 1st 04 08:55 PM
Mexport transfer from another program to excel opens at excel lau. DanetteS Excel Discussion (Misc queries) 1 November 30th 04 11:27 PM
Is there a keyboard shortcut for centering data in Excel? Antartica Excel Discussion (Misc queries) 2 November 30th 04 05:30 PM
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. Cindy Winegarden Excel Discussion (Misc queries) 0 November 28th 04 12:07 AM


All times are GMT +1. The time now is 06:22 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017