Export Worksheet Labels

[BR549]

Hello Margaret, it's me again. (Sorry lame reference to "The Streak", by Ray Stevens.



When exporting a worksheet the worksheet name has a _ (underline), rather than a space and any special characters are also replaced by an _ (underline). Is it possible to show the worksheet with the space and the special characters using access?

DoCmd.TransferSpreadsheet acExport, 10, "tbl A Path", strPath, True, "A Path"

A Path is what I would like it named.

Underlines bug me man...
Thank you

[June7]

Common advice is to not use spaces and special characters/punctuation (underscore is exception) in Access naming convention.

If TransferSpreadsheet makes those changes, can't do anything about it other than to rename the file once it's created.

Characters that cannot be used in Windows file names: < > : " / \ | ? *

[BR549]

Right, but this would be the worksheet label in the workbook. It allows the _ and some other special characters.

If it doesn't, then I will have to create macros to rename the worksheets in the workbook.

[June7]

That would require VBA code that opens the Excel file as an object and manipulates the object.

[BR549]

Thank you for the help, I will write Macro's in excel after the file has been exported to make the needed changes.

I think we can stick a fork in this one.