I tried the sample macro above and it worked great until I attempted to move a file to a network folder on a sharepoint site. I've been able to save excel files to these folders using VBA and would love to be able to move other files into them as well. Does anyone have any suggestions or can I just not save files to a sharepoint site this way?
Not sure about sharepoint but you could try changing the .movefile to .copyfile and see if this works. If it does you can then just delete the original file as the following line in the code.
What error does it come up with?
click on the * Add Reputation if this was useful or entertaining.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks