Hello everyone,
I have an issue with a file that i have created.in this file i have a macro that will copy/past value from the form, save it on the dekstop and send it to an email address. When I try it, it works prefectly, however, if a colleague of mine uses it, he has error message (see screenshot attached)
could someone help finding out why this happens ?
If i check my dekstop, it is on C:\Users\20032068\OneDrive - xxx Limited\Desktop but when they try, it seems that it gives the incorrect link to dekstop (c:\\Doccuments and Settings....)
strThisFile = Range("FileNameInput").Value
ActiveSheet.Protect Password:="123", DrawingObjects:=True, Contents:=True, Scenarios:=True _
, AllowFormattingCells:=True, AllowInsertingColumns:=False, AllowInsertingRows:=False, AllowInsertingHyperlinks:=False
strSaveToFolder = "\OneDrive - xxx Limited\Desktop\"
strSaveTo = strSaveToFolder & strThisFile
CheckFolder (strSaveToFolder)
ActiveWorkbook.SaveAs Filename:=strSaveTo
Thanks a lot for the support
Guismo30
Bookmarks