excel vba saveas not working - excel 2003 to sharepoint 2010 lib
Posted on 2011-05-03
Experts, I have a excel vba script that needs to saveas to a sharepoint 2010 library. When the vba is executed from within excel 2007 or 2010, the saveas works correctly. When using excel 2003, the users get a 1004 runtime error on the saveas. here is the vba line:
ActiveWorkbook.SaveAs "https://dept.sp.xxx.com/sites/PPM/preproduction/vbom/VBOM%20Audit%20Files/" & Trim(filename), FileFormat:=56
where filename = 'filename.xls'
All users have read/write access to the lib.
I am guessing that there is a switch or something that needs to be set on the excel 2003 machines. Any idea on what that might be, or any idea on why this won't work if it is not a switch?