Browse, search and copy files from one location to another based on the list given in excel sheet us

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Browse, search and copy files from one location to another based on the list given in excel sheet us

FAQ

Thread Tools

Display Modes

09-07-2020, 10:07 AM

Purfleet

Windows 10 Browse, search and copy files from one location to another based on the list given in excel sheet us

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

It will only do rtf files as you are changing the varible from pdf, to docx to rtf with out doing anything with it.

so the code will execute with .rtf all the time

sFileType = ".pdf"

sFileType = ".docx"
sFileType = ".rtf"

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy files from one location to another	nmkhan3010	Excel Programming	2	04-24-2020 12:14 AM
How to copy excel sheet withe HEADER and Paste into new sheet?	cloudforgiven	Excel Programming	6	01-05-2017 07:30 PM
Copy data from one sheet to another based on a certain criteria	shina67	Excel Programming	2	12-28-2016 07:32 AM
VBA Word - Search Within Files Containing A String - Copy Files to New Folder	jc491	Word VBA	0	01-09-2016 12:00 PM
Browse to a specific sheet in an excel workbook	Sinister	Excel	4	04-08-2014 05:53 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:49 AM.