Tweak VBA to Move SharePoint Files to a Folder in Same Location

[n_lindsey]

Hello all.

I know this may be a long shot but I will take my chance and hope that I won't get reamed too bad.

I have been given the job to read someone's vba who is a serious expert. I usually record and tweak the code for small to medium automation but I only want to use small parts of the existing VBA with the main function being to move an Excel file on SharePoint to the "Archive" folder in the same location.

I have included partial code below (let me know if more is needed to understand).

When I tweak the code, I get "Compile error: Sub or Function not defined."

Can anyone helpless novice?


Thank you in advance.

Please Login or Register  to view this content.

[mrice]

Is any part of the code highlighted when you get the error message?