how to ignore # when export hyperlink from access to excel?

[Uriya Levy]

Hi all,
Im trying to export (to excel 2007) a table conatining hyperlinks and stuff... but hyperlinks conatins '#' in pre/post-link
for example:
original link: bytes.com
after export: #bytes.com# or bytes.com#bytes.com#
Im using Access 2007.

appreciate any kind of help
Uriya.

[patjones]

So you're saying that the original table contains just bytes.com, but after the export you open up the Excel file and it shows as #bytes.com#?

Are you using VBA code to accomplish this export?

Pat

[Uriya Levy]

yep for both,zepphead80.
Im using VBA code to export, and I get #bytes.com#
what I need is to remove it :)

[patjones]

I just tried to reproduce your problem but cannot. When I make a list of websites in a table and export it using

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel, "tblWebSites", "C:\Documents and Settings\Desktop\tblWebSites.xlsx"

...I get exactly what I expect in the output Excel file. It seems like there's something else going on here that I cannot discern from the information you're giving.

[NeoPa]

So, we have a question essentially :
Why is my code introducing hash (#) characters into the Excel output?

But no code included :-S

Perhaps it would be a good idea at this point to include the code that you're using which exhibits this behaviour.