PDA

View Full Version : Help : Error on saving workbook to dektop synced with OneDrive



anish.ms
11-03-2022, 05:43 AM
Hi Experts,

I'm getting an error with the following code for saving the workbook after my desktop is synced with OneDrive. Could anyone please help me to solve this issue?



.SaveAs Filename:=Environ("USERPROFILE") & "\Desktop\" & NewWB_Name, _
FileFormat:=xlOpenXMLWorkbook


30304

Thanks in advance!

June7
11-03-2022, 10:44 AM
Review https://social.msdn.microsoft.com/Forums/office/en-US/7fb726e2-7103-4c6b-8c45-d64cb5ca3aa2/vba-save-to-excelwordpdf-in-users-onedrive-online-folder?forum=accessdev