cheesymango
New Member
- Joined
- Oct 24, 2016
- Messages
- 4
Hi everyone,
Newbie question here so any help I get I'll be grateful! I tried using the following script to save a spreadsheet onto sharepoint which i've opened with vba on another spreadsheet.
Path = "http://sharepoint.com/"
filename1 = " Test File"
dtt = Format(CStr(Now), "hhmm")
ActiveWorkbook.SaveAs Filename:=Path & Format(Now(), "yyyy-mm-dd") & filename1 & dtt & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled
Is something wrong? It sometimes works but it sometimes doesn't...Thanks!
Newbie question here so any help I get I'll be grateful! I tried using the following script to save a spreadsheet onto sharepoint which i've opened with vba on another spreadsheet.
Path = "http://sharepoint.com/"
filename1 = " Test File"
dtt = Format(CStr(Now), "hhmm")
ActiveWorkbook.SaveAs Filename:=Path & Format(Now(), "yyyy-mm-dd") & filename1 & dtt & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled
Is something wrong? It sometimes works but it sometimes doesn't...Thanks!