Macro to Save to Sharepoint

G

Guest

I have macro that processes several files and saves them with the date. i
want to save these files to Sharepoint and let Sharepoint notify the end
recipients that the file is available. I can save the file to Sharepoint,
but Shrepoint is not recognizing that the file is there and it does not send
the notification. If I do Save As through the File menu, SharePoint
recognizes the file and sends notification. Any ideas?

If current_file_name = "Weekly Muni Bond A vs. A WFIA3" Then
new_file_name =
"http://dashboard.xxxx.com/FundAdmin/Lipper/Weekly_Municipal_Files" _
& "/" & current_file_name & " " & as_of_date & ".xls"
ActiveWorkbook.SaveAs new_file_name, xlNormal
End If

using Excel 2003 and Sharepoint 2.0

Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to save a WorkBook to SharePoint? 1
Saving files to Sharepoint site: error 1004 (can't save file) 2
Macro to open all files in SharePoint Library 1
Having problems saving pdf's from excel to a sharepoint site. 2
Error 2950 from macro when exporting to Sharepoint 0
replace special character for filename save 11
Problem saving backup file with VBA 1
Simplify save code 11

Top