Excel to sharepoint wheres the folder ?

[stevebrodie]

Hi All,

I have searched the site but cannot find an answer so;

I am trying to save a file to sharepoint, which i have managed to do using the code below, however my problem is that the files seem to be stored in 'seperate web folder?s' that is when you save the file manually sharepoint asks for the month and date the file was created - i have used the explorer view in sharepoint and all the files are in one giant repository. but using the method below i do not seem to be able to add this 'path' to the file so it just gets saved in whatever folder was their before. Clear as mud ?

[FONT=Arial]Sub savesheet()<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>[/FONT]
[FONT=Arial]<o:p></o:p>[/FONT]
[FONT=Arial] ActiveWorkbook.SaveAs Filename:= _<o:p></o:p>[/FONT]
[FONT=Arial]     "[URL]http://amp.dmzad01.site/sites/AMP002/ss030/t3 Reports/Full_t3_Report_[/URL]" & Format(Date, "ddmmm") & ".xls" _<o:p></o:p>[/FONT]
[FONT=Arial]     , FileFormat:=xlNormal, Password:="", WriteResPassword:="", _<o:p></o:p>[/FONT]
[FONT=Arial]     ReadOnlyRecommended:=False, CreateBackup:=False<o:p></o:p>[/FONT]
[FONT=Arial]End Sub<o:p></o:p>[/FONT]

Any Help would be great