Long file names in excel won't load through explorer.

[Anne Johnson]

My user has long file names for some of his workbooks but if these have a space
in them excel fails to open them taking the name to be only up to the space.
We have tried MS solution of unticking the Ignore other applications under the
general tab on options but this does not solve the problem.
Can anyone help on this please?

[David McRitchie]

Hi Anne,
You've not said how or where these names are specified.
The obvious would be enclose in double quotes.

This is a worksheet formula
="d:\myfolder\excel\various files\" & A14 & "["& A15 & "]!"&"b600"

HTH,
David McRitchie, Microsoft MVP - Excel (site changed 2000-04-15)
My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm
Search Page: http://www.geocities.com/davemcritchie/excel/search.htm

"Anne Johnson" <anne.j...@et.suffolkcc.gov.uk> wrote in message
news:183001c0ab9c$56c2aaa0$9ee62ecf@tkmsftngxa05...

[Dave Peterson]

I think David missed your question (that was in the header, not body).

But try re-registering excel.

Close Excel

Start|run

then run something like this (your path may vary):

"c:\program files\microsoft office\office\excel.exe" /regserver

Notice quotes if the path contains spaces and space before /regserver.

--

Dave Peterson
ea3...@msn.com

[Anne Johnson]

Thank you it worked when I re-registered excel.

But try re-registering excel.

Close Excel

Start|run

--

Dave Peterson
ea3...@msn.com
.

[Shannon Monte]

Hi Anne and David,

I have the same problem as Anne, I also have some files with spaces in the
filename and Excel tries to open the part of the name before each space when I
double click the file from explorer. If I start excel and choose open and clicks
on the file it will open without an error. I checked out the answer of David but
I don't know what he means with the excel formula. I still have my problem. Can
somebody Help.

Shannon

.

[David McRitchie]

Hi Shannon,
Guess I was distracted, here are some solutions for places where
spaces can cause problems.

In a desktop shortcut, which I think is what you are asking:
c:\temp\"my spreadsheet.xls"
"c:\temp\my spreadsheet.xls"
file:///c:/temp/david%20McRitchie/a.txt -- using %20 for space

in a macro
see http://www.geocities.com/davemcritchie/excel/sheets.htm
.
ActiveWorkbook.saveas """" & fname & """"

in a hyperlink
see http://www.geocities.com/davemcritchie/excel/buildtoc.htm
=HYPERLINK("file:\\\c:\temp\David McRitchie\a.txt","thisone is good")

I don't know what DDE is but there is something in the System Help files
about DDE not in Excel help, so your answer may lie a reply by ...

Myrna Larsen, in misc 2000-12-14 13:22:15 PST

http://groups.google.com/groups?hl=en&lr=&safe=off&ic=1&th=69a0361ee38d4409&seek
d=951912609#951912609

You're on the right track, Gord, but it isn't the command line that's the
problem. You need to be sure that "Use DDE" is checked, and in the "DDE
message" box, you must have quotes around the FILE NAME, i.e. it should look
like this.

[open("%1")]

HTH,
David McRitchie, Microsoft MVP - Excel (site changed 2000-04-15)
My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm
Search Page: http://www.geocities.com/davemcritchie/excel/search.htm

"Shannon Monte" <monte....@kpmg.nl> wrote in message
news:92f901c0be79$9f1fde40$9ee62ecf@tkmsftngxa05...

[Shannon Monte]

Hi David,

I don't understand your solution.

My problem is when I make a standard excel worksheet and save it with spaces in
the filename(e.g. Test Sheet.xls) and I try to reopen it from within explorer by
clicking on the file it self, not a shortcut, it won't open directly it first try
to open Test.xls which result in an error message file not found and then it
tries Sheet.xls which also returns in an error message and afterall it will open
the complete file.This is on my PC, on the PC of friend of mine which origanlly
had the problem the file doen't open at all.

I tried Re-registering excel already like Anne did, but it didn't help

Greetings

Shannon Monte

http://groups.google.com/groups?hl=en&lr=&safe=off&ic=1&th=69a0361ee38d4409&seek
d=951912609#951912609

[open("%1")]

Shannon

..

.

[David McRitchie]

--

HTH,
David McRitchie, Microsoft MVP - Excel (site changed 2000-04-15)
My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm
Search Page: http://www.geocities.com/davemcritchie/excel/search.htm

"Shannon Monte" <monte....@kpmg.nl> wrote in message

news:481c01c0c0d1$dd9ac720$9ae62ecf@tkmsftngxa02...

[David McRitchie]

Hi Shannon, (posted in excel.setup)

Opening long Excel filenames with spaces with Explorer

Sorry, I think the solution may be in a Registry change,
unless there is a better place to change it. Looks like something
Rob Bovey may have mentioned. I do remember making such
a change somewhere.

--posting by Myrna Larsen--

You're on the right track, Gord, but it isn't the command line that's the
problem. You need to be sure that "Use DDE" is checked, and in the "DDE
message" box, you must have quotes around the FILE NAME, i.e. it should look
like this.

[open("%1")]
--------------------------------------

HTH,
David McRitchie, Microsoft MVP - Excel (site changed 2000-04-15)
My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm
Search Page: http://www.geocities.com/davemcritchie/excel/search.htm

"Shannon Monte" <monte....@kpmg.nl> wrote in message

news:481c01c0c0d1$dd9ac720$9ae62ecf@tkmsftngxa02...

[Rob Bovey]

Hi All,

This is one of those problems I see every now and then and I can't quite
remember the solution. I think it was running Excel.exe /regserver to force
Excel to rewrite all of its registry entries that cured it, but I can't be
positive.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

"David McRitchie" <DMcRi...@msn.com> wrote in message
news:eAvOesPwAHA.1300@tkmsftngp05...

[Shannon Monte]

Dear Rob,

I tried running excel /regserver, I tried the option Detect and Repair in excel
(Help) but they didn't work. I restored a new pc and it worked fine. I checked in
the File Associations and the path name is excel" /e so I removed the /e to
check if that's the problem, and indeed it stop working so I put the /e back on
it's place but it still didn't work.

After putting it back Í ran excel /regserver , restarted my pc but it still
didn't fix the problem

Shannon

-----Original Message-----
Hi All,

.

[Shannon Monte]

I found the solution, it's that when you remove the /e from the pathname in
file associations excel updates its registry and it puts an %1 after the path
name in the registry, and if you put the /e back it won't remove the %1 in the
pathname in the registry so I won't open the file, if you run the followin reg
update it fixes the problem

Shannon Monte

-----Original Message-----
Dear Rob,

Shannon

-----Original Message-----
Hi All,

..

.

[Rob Bovey]

Hi Shannon,

I'm not sure why the /e switch would make a difference. That just tells
Excel not to display its splash screen and load and empty workbook when
you're opening a workbook be double-clicking from explorer. I hate to say
this, as it's kind of a last resort, but try uninstalling and then
reinstalling Office, preferably to a short path name (e.g. C:\MSOffice
rather than its default location deep under Program Files). I've found the
Office tends to be more stable over the long term when it's installed to a
short path.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *

"Shannon Monte" <monte....@kpmg.nl> wrote in message

news:a95f01c0c193$347d6400$19ef2ecf@tkmsftngxa01...

[David McRitchie]

Hi Shannon,
Back to Myrna's archived posting which was to terse for me to understand,
here is her message again and then where to find what it applies to:

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
--posting by Myrna Larsen, in misc 2000-12-14 13:22:15 PST
http://groups.google.com/groups?hl=en&lr=&safe=off&ic=1&th=69a0361ee38d4409&
seek d=951912609#951912609

You're on the right track, Gord, but it isn't the command line that's the
problem. You need to be sure that "Use DDE" is checked, and in the "DDE
message" box, you must have quotes around the FILE NAME, i.e. it should look
like this.

[open("%1")]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

My Computer
View Menu, Options, File Types
Microsoft Excel Worksheet
Open (is bold as default), click to select then use Edit button

---------------------------------------------------------------
Action: Open
Application used to perform action:
"H:\Program Files\Microsoft Office2000\Office\EXCEL.EXE" /e
[x] Use DDE
DDE Message: [open("%1")]
Application: Excel
DDE Application Not Running: (blank)
Topic: system
------------------------------------------------------------------

More information on what I see for other Actions for .xls extension
http://www.geocities.com/davemcritchie/excel/view_xls.txt

HTH,
David McRitchie, Microsoft MVP - Excel (site changed 2000-04-15)
My Excel Macros: http://www.geocities.com/davemcritchie/excel/excel.htm
Search Page: http://www.geocities.com/davemcritchie/excel/search.htm

"Rob Bovey" <Rob_...@msm.com> wrote in
message news:uPWo$NawAHA.2292@tkmsftngp02...
(^^^^^^^^^^ CLIPPED ^^^^^^^^^^^^^^^^^^^^^^^^)

> "Shannon Monte" <monte....@kpmg.nl> wrote in message
> news:a95f01c0c193$347d6400$19ef2ecf@tkmsftngxa01...

> I tried running excel /regserver, I tried the option Detect and
> Repair in excel (Help) but they didn't work. I restored a new pc
> and it worked fine. I > checked in > the File Associations and the
> path name is excel" /e so I removed the /e to check if that's
> the problem, and indeed it stop working so I put the /e back
> on it's place but it still didn't work.
>
> After putting it back Í ran excel /regserver , restarted my pc
> but it still didn't fix the problem

(^^^^^^^^^^ CLIPPED ^^^^^^^^^^^^^^^^^^^^^^^^)