J
jcsowder
Hi,
I am using a macro to access the OutputTo action that exports the results of
a query as an Excel file. The Output Format is Microsoft Excel 97-2003
(*.xls). After exporting the file I want to upload it to SharePoint, howerver
I receive a validation error when I try to do so. I found that if I open the
Excel file, save it, and close it, it works. Is there a way of exporting this
file without having to do the additional step? Can I export the file directly
to the SharePoint document library I want to add it to?
I am often frustrated because the way I think something should work does not
equate with the way it actually works...
Thanks in advance for you assistance.
I am using a macro to access the OutputTo action that exports the results of
a query as an Excel file. The Output Format is Microsoft Excel 97-2003
(*.xls). After exporting the file I want to upload it to SharePoint, howerver
I receive a validation error when I try to do so. I found that if I open the
Excel file, save it, and close it, it works. Is there a way of exporting this
file without having to do the additional step? Can I export the file directly
to the SharePoint document library I want to add it to?
I am often frustrated because the way I think something should work does not
equate with the way it actually works...
Thanks in advance for you assistance.