View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
colofnature[_5_] colofnature[_5_] is offline
external usenet poster
 
Posts: 1
Default Macro to copy workbooks from one location to another.


Couple of things - first, add "\" to the end of values i
"sourcepathname" and "destpathname", and second, if you're copyin
anything other than spreadsheets you'll need to change the value o
"filemask" to whatever the extension is for that type of file (e.g
"*.mp3", "*.jpg" etc)

Co

--
colofnatur
-----------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...fo&userid=3435
View this thread: http://www.excelforum.com/showthread.php?threadid=54308