Do I need a FULL pathname

[ChrisTheAncient]

I want to export some data from an Access (both 97 and XP) db to an Excel spreadshhet.

The routine I've been given is...

DoCmd.TransferSpreadshee acExport,acSpreadsheetTypeExcel19, _
"qryWhatever", "C:\ with a highly detailed full pathname.xls"

As the set database and spreadsheet might be in different places on different machines (but supposedly in the same folder), can I abbreviate the path name?

Chris

*************************************
OK, I'm stoopid. But I'm good at it!
*************************************

 

[mkov]

You will need the full path name.

 

[ChrisTheAncient]

mkov

Thanks. I was scared that was the case.

Oh well, time to think laterally!

Chris

*************************************
OK, I'm stoopid. But I'm good at it!
*************************************