S
scott04
Hi All,
I am having trouble with the transfer spreadsheet function. It was working
fine when i had it pointing to my C:/ drive but when i tried to switch it to
my shared M drive i have issues with a 3051 run time error. I know this
error is usually due to someone being in the spreadsheet but no one is in
it....Here is my code for the module....
Public Function TransferSpreadsheet_click()
DoCmd.TransferSpreadsheet acExport, , "Ask PMQS Summary Query",
"M:\Training\Ask PMQS"
MsgBox "The selected report have been exported to your computer " &
"M:/Training\Ask PMQS\Ask PMQS Summary Query.xls"
End Function
Like i said before when i had it just "C:\Ask PMQS" it worked fine
I am having trouble with the transfer spreadsheet function. It was working
fine when i had it pointing to my C:/ drive but when i tried to switch it to
my shared M drive i have issues with a 3051 run time error. I know this
error is usually due to someone being in the spreadsheet but no one is in
it....Here is my code for the module....
Public Function TransferSpreadsheet_click()
DoCmd.TransferSpreadsheet acExport, , "Ask PMQS Summary Query",
"M:\Training\Ask PMQS"
MsgBox "The selected report have been exported to your computer " &
"M:/Training\Ask PMQS\Ask PMQS Summary Query.xls"
End Function
Like i said before when i had it just "C:\Ask PMQS" it worked fine