B
benonibriggs1978
Hi,
I Need some help and was wondering if someone can assist me. I have
this code below set up to transfer ny form data to excel
spreadsheet .This is the code.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "GB20
Supplier Export Data", "C:\Supplier Spend Results\NPP.xls", True
This works perfectly .But my problem is when I use this on a different
computer ( as this is saved on the server) it does not export it
because it doesn't recognise the path name.
What do I need to do to insert a path that will be recognised no
matter which PC I use. Thanks
I Need some help and was wondering if someone can assist me. I have
this code below set up to transfer ny form data to excel
spreadsheet .This is the code.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "GB20
Supplier Export Data", "C:\Supplier Spend Results\NPP.xls", True
This works perfectly .But my problem is when I use this on a different
computer ( as this is saved on the server) it does not export it
because it doesn't recognise the path name.
What do I need to do to insert a path that will be recognised no
matter which PC I use. Thanks