using spaces instead of underscores

[Jason]

Hello folks,

Has anyone encountered problems when using spaces in
worksheet names, file names, folder names in excel
programming? I find spaces look neater and improves
readability and I would prefer spaces but thought I would
get some advice prior to beginning to create my folder and
filename structures.

Please note there will be numerous links to external files.

Thanks,

Jason

 

[Bob Phillips]

No.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Paulw2k]

Hi Jason

Just remember that XL encloses the SheetName/[WorkbookName]SheetName element
in single quotes when there are white spaces.

=[Book3.xls]Sheet1!$A$1
='Sheet 2'!$A$1
='[Book3.xls]Sheet 2'!$A$1
='C:\Documents and Settings\Paul Wilson\My Documents\[Book3.xls]Sheet
2'!$A$1

If you create such formulas by code it is always wise to enclose this part
with single quotes

SomeCell.formulaR1C1= "='" & SheetName & "'!R100C100"
SomeCell.formulaR1C1= "='[" & WorkBookName & "]" & SheetName & "'!R100C100"
SomeCell.formulaR1C1= "='Path[" & WorkBookName & "]" & SheetName &
"'!R100C100"

XL will drop them if they are not needed.

Regards

Paul

 

[Dan T]

Searching names with spaces can be a pain, can find each
space separated element of the name (but depends on the
find method).

Regards,
Dan