I have a list of 400 folder paths in a spreadsheet and I have to paste a worksheet into each one of those folders. I can find all kinds of help to paste to one folder at a time or to search a directory and paste into all folders and sub-folders, but nothing that works from a list. Not sure if matters but it's all in Excel 2003 too. Thanks in advance.
Use FileCopy function.
Ex:
Note that Source and Destination must be full path.
Please Login or Register to view this content.
If Source is static, you'd just need to loop over the range holding Destination values.
https://docs.microsoft.com/en-us/dot...tframework-4.8
This assumes by worksheet. You mean a workbook. If it's worksheet, you'd first need to use routine to export sheet and save it to a location.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
You mean a file ??I have to paste a worksheet into each one of those folders
If yes where is this file ?
- Battle without fear gives no glory - Just try
Yes, I want to paste a file into a bunch of different folders. The file or workbook to copy is housed in the same folder as the Excel workbook containing the macro.
See next code
Please Login or Register to view this content.
Thank you so much, you guys blow my mind with your level of expertise. That is awesome!
You're welcome, glad to help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks