Gord Dibben
2/4/2010 11:45:00 PM
On Thu, 4 Feb 2010 11:40:45 -0700, "Robert Crandal" <nobody@gmail.com>
wrote:
>I was able to find an option called "Ignore other applications
>that use Dynamic Data Exchange (DDE)". Was this the same
>thing you mention below??
Yes
>
>Also, I went ahead and set the above option, but when I
>double on ANY macro enabled file I get an error message
>that said something like "Excel cannot find the file".
That's most likely because you have no double quotes around your command
line to start Excel.
"C:\yourpath\excel.exe"
I would suggest you re-register Excel 2007
Close Excel first and On the Windows Taskbar
Start>Run "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 Start>Run "C:\yourpath\excel.exe" /regserver(quotes
required)>OK
After re-reg open Excel, go in and make sure the "ignore other etc." is
still checked.
I'm not sure why you want to open a bunch of read-only files in the first
place.
Gord
>
>BTW, I'm using Excel 2007
>
>
>"Gord Dibben" <gorddibbATshawDOTca> wrote in message
>news:a10mm5548onjsj9khhulu1la6bm1mfot17@4ax.com...
>>
>> Set options in Excel for "ignore other applications.
>>
>> Have your workbook open in an instance of Excel.
>>
>> Then open your same named workbook from its folder by double-click......do
>> not go through File>Open.
>>
>> You will start a new instance of Excel and open the same file in the new
>> instance but you will get the "locked for editing" message and can open in
>> "read only" mode.
>>
>>