Copying sheet from file round 2!!!

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

#12

01-15-2021, 01:48 AM

Purfleet

Windows 10 Copying sheet from file round 2!!!

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

Hi SoMany

Try uzer = Environ("Username")

before the filename assign

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

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 03:28 AM.