Copying sheet from file round 2!!!

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

01-21-2021, 07:45 PM

SoMany

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

Office 2016

Advanced Beginner

Join Date: Oct 2016

Posts: 51

Quote:

Originally Posted by Purfleet

Hi SoMany

Try uzer = Environ("Username")

before the filename assign

Or ,ideally, use a network drive location it will probably be more reliable

That did the trick. Thank you.

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 01:42 AM.