Copying sheet from file round 2!!!

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Copying sheet from file round 2!!!

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-12-2021, 06:11 AM

SoMany

Windows 7 64bit Copying sheet from file round 2!!!

Office 2016

Advanced Beginner

Join Date: Oct 2016

Posts: 51

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"....

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:04 PM.