TransferSpreadSheet

[border20]

I have the folowing code that works fine

Docmd.TransferSpreadsheet acExport, 8, "Queryname", "x:\database\export.xls", False

the problem is that X is a network drive, and the database is runed form different computer with different drive names...

The target excel document is in the same folder as th DB... so I need to refer to the reletive path... so i tried this :

Docmd.TransferSpreadsheet acExport, 8, "Queryname", "export.xls", False

and

Docmd.TransferSpreadsheet acExport, 8, "Queryname", "\export.xls", False

but none worked
can anyone help ?

 

[KevinM]

Use the unc path rather than the mapped network drive.

This (as in your case) can differ from machine to machine.

 

[border20]

thanks, very helpfull