TransferSpreadsheet

[aziz rasul]

When I use the following code:

DoCmd.TransferSpreadsheet acExport, 8, "qryAllTrustsSummarisedReportSpend", strFilename, True, ""

it works. But if I extend the query name to more than 34 characters it brings up a fault regarding named range. I can't find any info on online help on this? Does anyone have any info on this and other similar restrictions?

 

[sfreeman@co.mer]

There is no such restriction. Your code runs fine on my PC even after giving the query a name 35 chars long.

I think there is another issue.