VBA Code To Copy A File in the shared drive to a user desktop

**FLani** · 02-08-2013, 12:38 AM

Hi,

I need some sort of code that will copy a file. The location of the file is in say CELL C90 and save it in a user's desktop/my documents. But there is no specific user running the process. It changes and depends on the availability of teammates. Is there some sort of way to do this? We are using excel 2003/2007

**alansidman** · 02-08-2013, 01:29 AM

Please Login or Register  to view this content.

This is untested and off the top of my head. You may need to tweak, but it should give you a starting point.

Look at this link for more information on this subject

http://www.rondebruin.nl/folder.htm

VBA Code To Copy A File in the shared drive to a user desktop

LinkBack

Thread Tools

Rate This Thread

Display

VBA Code To Copy A File in the shared drive to a user desktop

Re: VBA Code To Copy A File in the shared drive to a user desktop

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions