M
Milhouse Van Houten
I'm using Access 2007 SP2 and have a form which I need to export via macro
as an Excel file to a SharePoint location. This works fine with all the XP
Pro SP3 machines at my office, but I recently added a few Vista Business SP2
machines, and it will not let me export to SharePoint (v2 or v3). I can
export it to another location on the network, and then copy and paste it
into the SharePoint location, but it won't let me export it directly to the
SharePoint location. I've tried both mapped drives and straight UNC paths
(e.g. \\companyweb). The message I get says:
"Microsoft Office Access can't save the output data to the file you've
selected.
*The file may be open. If so, close it, then save the output data to the
file again.
*If you are using a template, check to make sure the template exists.
*If the file isn't open, check to make sure that you have enough free disk
space.
*Make sure that the file exists on the path specified.
*Check to make sure you have permission to write to the specified folder."
Per this article, I have the site in Trusted Locations with Access and have
also set everything else that can be set in Trust Center.
http://support.microsoft.com/kb/931407
Here's how the macro looks when I use Save As Module:
Option Compare Database
'------------------------------------------------------------
' ExportPayrollConfirmation
'
'------------------------------------------------------------
Function ExportPayrollConfirmation()
On Error GoTo ExportPayrollConfirmation_Err
DoCmd.OutputTo acOutputQuery, "Payroll_Confirmation",
"Excel97-Excel2003Workbook(*.xls)", "", False, "", 0, acExportQualityPrint
DoCmd.OutputTo acOutputQuery, "QRYPrlIncompleteFiles",
"Excel97-Excel2003Workbook(*.xls)", "", False, "", 0, acExportQualityPrint
ExportPayrollConfirmation_Exit:
Exit Function
ExportPayrollConfirmation_Err:
MsgBox Error$
Resume ExportPayrollConfirmation_Exit
End Function
as an Excel file to a SharePoint location. This works fine with all the XP
Pro SP3 machines at my office, but I recently added a few Vista Business SP2
machines, and it will not let me export to SharePoint (v2 or v3). I can
export it to another location on the network, and then copy and paste it
into the SharePoint location, but it won't let me export it directly to the
SharePoint location. I've tried both mapped drives and straight UNC paths
(e.g. \\companyweb). The message I get says:
"Microsoft Office Access can't save the output data to the file you've
selected.
*The file may be open. If so, close it, then save the output data to the
file again.
*If you are using a template, check to make sure the template exists.
*If the file isn't open, check to make sure that you have enough free disk
space.
*Make sure that the file exists on the path specified.
*Check to make sure you have permission to write to the specified folder."
Per this article, I have the site in Trusted Locations with Access and have
also set everything else that can be set in Trust Center.
http://support.microsoft.com/kb/931407
Here's how the macro looks when I use Save As Module:
Option Compare Database
'------------------------------------------------------------
' ExportPayrollConfirmation
'
'------------------------------------------------------------
Function ExportPayrollConfirmation()
On Error GoTo ExportPayrollConfirmation_Err
DoCmd.OutputTo acOutputQuery, "Payroll_Confirmation",
"Excel97-Excel2003Workbook(*.xls)", "", False, "", 0, acExportQualityPrint
DoCmd.OutputTo acOutputQuery, "QRYPrlIncompleteFiles",
"Excel97-Excel2003Workbook(*.xls)", "", False, "", 0, acExportQualityPrint
ExportPayrollConfirmation_Exit:
Exit Function
ExportPayrollConfirmation_Err:
MsgBox Error$
Resume ExportPayrollConfirmation_Exit
End Function