Copying sheet from file round 2!!!

p45cal · #1 01-11-2021, 11:42 AM

filename = "C:\Users\" & uzer & "\Desktop\Test import file\DifferentFolderf\TestImportFile2.xlsx"

SoMany · #2 01-12-2021, 06:11 AM

Quote:

Originally Posted by p45cal

filename = "C:\Users\" & uzer & "\Desktop\Test import file\DifferentFolderf\TestImportFile2.xlsx"

Even with the change it's not finding the folder. The new macro is below.

Edit; and for some reason I added an extra "f" in the original post in "DifferentFolderf"....

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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