|
|
#1
01-10-2021, 07:38 AM
|
|||
|
|||
Copying sheet from file round 2!!!
So I've made enough progress in VBA to post this again. I'm trying to copy a sheet from another file in another folder. I can now make macros that copy data from another file within a file, but don't know how to copy the sheet when it's in another file.
Would someone modify this or say what code I should use? The path for the other folder would be "C:\Users\John Smith\Desktop\Test import file\DifferentFolderf\TestImportFile2" 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Copying a Sheet in a Workbook to Another with Destination-Need Values Instead of Formulas
|
rsrasc | Excel Programming | 4 | 08-19-2018 04:00 PM |
|
Copying a part of a docx file as a separate file
|
officeboy09 | Word | 6 | 09-26-2014 05:15 PM |
|
Copying excel charts into word - huge file size.
|
Matt.M | Word | 2 | 04-02-2014 07:38 PM |
|
Copying data from sheet with deleted columns creates blanks
|
ZGreyArea | Excel | 1 | 11-20-2013 10:12 AM |
| Error Copying file or folder - Drag-N-Drop--> Network Shared | Kris.Fulgham | Outlook | 1 | 10-17-2005 09:02 AM |
Windows 7 64bit 
Office 2016
Threaded Mode