ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problem opening a file (https://www.excelbanter.com/excel-discussion-misc-queries/160040-problem-opening-file.html)

Dave

Problem opening a file
 
If I choose a file from Windows Explorer, Excel loads OK but then says cant
find the file, but that's because the full path to the
file gets broken down into silly parts like C:\Documents and\myfile.xls and
when you clear that, it say can't find C:\Settings\myfile.xls. and continues
on until finally giving up.

Any ideas please

--
Dave P

Gord Dibben

Problem opening a file
 
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.


Gord Dibben MS Excel MVP

On Fri, 28 Sep 2007 05:08:01 -0700, Dave
wrote:

If I choose a file from Windows Explorer, Excel loads OK but then says cant
find the file, but that's because the full path to the
file gets broken down into silly parts like C:\Documents and\myfile.xls and
when you clear that, it say can't find C:\Settings\myfile.xls. and continues
on until finally giving up.

Any ideas please



Dave

Problem opening a file
 
Thanks, why couldn't it be the same method as WORD?

Any idea why this happens please?
--
Dave P


"Gord Dibben" wrote:

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.


Gord Dibben MS Excel MVP

On Fri, 28 Sep 2007 05:08:01 -0700, Dave
wrote:

If I choose a file from Windows Explorer, Excel loads OK but then says cant
find the file, but that's because the full path to the
file gets broken down into silly parts like C:\Documents and\myfile.xls and
when you clear that, it say can't find C:\Settings\myfile.xls. and continues
on until finally giving up.

Any ideas please




Bob I

Problem opening a file
 
Because the /r switch is already used for opening workbook read-only

Dave wrote:

Thanks, why couldn't it be the same method as WORD?

Any idea why this happens please?




All times are GMT +1. The time now is 12:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com