Macro to Save to Sharepoint
 

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,