| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot double-click to open file
I've written some code to pull data from Access and sort
it into something presentable. The problem is that once the spreadsheet has been created, I cannot open it by double-clicking on it. All that appears is the excel header, toolbar, and border, but where the spreadsheet should be, I just see my desktop. I can open it if I open excel first then go to File - Open. This problem is duplicatable on other people's machines too. Any suggestions on hwo to fix this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cannot double-click to open file
Check tools/options/General -- see if you have "Ignore other applications"
checked. If so, uncheck it, exit excel & try again. Bob Umlas Excel MVP "Chris M." wrote in message ... I've written some code to pull data from Access and sort it into something presentable. The problem is that once the spreadsheet has been created, I cannot open it by double-clicking on it. All that appears is the excel header, toolbar, and border, but where the spreadsheet should be, I just see my desktop. I can open it if I open excel first then go to File - Open. This problem is duplicatable on other people's machines too. Any suggestions on hwo to fix this? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cannot double-click to open file
I'm afraid that that does not fix the issue. I had
checked it initially in an attempt to fix the issue, unchecked it and the issue continues. -----Original Message----- Check tools/options/General -- see if you have "Ignore other applications" checked. If so, uncheck it, exit excel & try again. Bob Umlas Excel MVP "Chris M." wrote in message ... I've written some code to pull data from Access and sort it into something presentable. The problem is that once the spreadsheet has been created, I cannot open it by double-clicking on it. All that appears is the excel header, toolbar, and border, but where the spreadsheet should be, I just see my desktop. I can open it if I open excel first then go to File - Open. This problem is duplicatable on other people's machines too. Any suggestions on hwo to fix this? . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cannot double-click to open file
Try this
On the Windows Taskbar Close Excel 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. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Chris M." wrote in message ... I'm afraid that that does not fix the issue. I had checked it initially in an attempt to fix the issue, unchecked it and the issue continues. -----Original Message----- Check tools/options/General -- see if you have "Ignore other applications" checked. If so, uncheck it, exit excel & try again. Bob Umlas Excel MVP "Chris M." wrote in message ... I've written some code to pull data from Access and sort it into something presentable. The problem is that once the spreadsheet has been created, I cannot open it by double-clicking on it. All that appears is the excel header, toolbar, and border, but where the spreadsheet should be, I just see my desktop. I can open it if I open excel first then go to File - Open. This problem is duplicatable on other people's machines too. Any suggestions on hwo to fix this? . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cannot double-click to open file
I'm afraid that didn't work either. I've used that to fix
problems previously, but hadn't tried it on this one. I can't find a thing about this on Microsoft's knowledge base. I've tried it now on over 10 systems here at work and they all do it. If I recreate the spreadsheet from scratch, import the code and run it, the problem recurrs. Any other suggestions? Thanks for the previous help. -----Original Message----- Try this On the Windows Taskbar Close Excel 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. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Chris M." wrote in message ... I'm afraid that that does not fix the issue. I had checked it initially in an attempt to fix the issue, unchecked it and the issue continues. -----Original Message----- Check tools/options/General -- see if you have "Ignore other applications" checked. If so, uncheck it, exit excel & try again. Bob Umlas Excel MVP "Chris M." wrote in message ... I've written some code to pull data from Access and sort it into something presentable. The problem is that once the spreadsheet has been created, I cannot open it by double-clicking on it. All that appears is the excel header, toolbar, and border, but where the spreadsheet should be, I just see my desktop. I can open it if I open excel first then go to File - Open. This problem is duplicatable on other people's machines too. Any suggestions on hwo to fix this? . . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cannot double-click to open file
Also, strangely, if I log off of the network, and then log
back in, I can open the file without a problem. If I execute the code again, I cannot open that spreadsheet, or any other without this problem until I log out and back into the network. -----Original Message----- Try this On the Windows Taskbar Close Excel 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. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Chris M." wrote in message ... I'm afraid that that does not fix the issue. I had checked it initially in an attempt to fix the issue, unchecked it and the issue continues. -----Original Message----- Check tools/options/General -- see if you have "Ignore other applications" checked. If so, uncheck it, exit excel & try again. Bob Umlas Excel MVP "Chris M." wrote in message ... I've written some code to pull data from Access and sort it into something presentable. The problem is that once the spreadsheet has been created, I cannot open it by double-clicking on it. All that appears is the excel header, toolbar, and border, but where the spreadsheet should be, I just see my desktop. I can open it if I open excel first then go to File - Open. This problem is duplicatable on other people's machines too. Any suggestions on hwo to fix this? . . |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cannot double-click to open file
Hi
I had a similar problem and tried all the fixes suggested above. None worked. Ron's solution usually works, but occasionally it fails for some reason. Un-registering excel and then re-registering it fixed my problem. On the Windows Taskbar Close Excel StartRun "excel.exe /unregserver"(no quotes)OK. See the space between exe and /regserver then On the Windows Taskbar Close Excel StartRun "excel.exe /regserver"(no quotes)OK. See the space between exe and /regserver HTH Ken "Chris M." wrote in message ... Also, strangely, if I log off of the network, and then log back in, I can open the file without a problem. If I execute the code again, I cannot open that spreadsheet, or any other without this problem until I log out and back into the network. -----Original Message----- Try this On the Windows Taskbar Close Excel 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. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Chris M." wrote in message ... I'm afraid that that does not fix the issue. I had checked it initially in an attempt to fix the issue, unchecked it and the issue continues. -----Original Message----- Check tools/options/General -- see if you have "Ignore other applications" checked. If so, uncheck it, exit excel & try again. Bob Umlas Excel MVP "Chris M." wrote in message ... I've written some code to pull data from Access and sort it into something presentable. The problem is that once the spreadsheet has been created, I cannot open it by double-clicking on it. All that appears is the excel header, toolbar, and border, but where the spreadsheet should be, I just see my desktop. I can open it if I open excel first then go to File - Open. This problem is duplicatable on other people's machines too. Any suggestions on hwo to fix this? . . --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 09/10/2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What have I done wrong? Cannot double click on file to open | Excel Discussion (Misc queries) | |||
| Double-click and open .csv file | Setting up and Configuration of Excel | |||
| Why can't I double click on a file to open it? | Excel Discussion (Misc queries) | |||
| double click excel file doesn't open it | Excel Discussion (Misc queries) | |||
| can't open file by double click | Excel Discussion (Misc queries) | |||
![Chris M.[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
