Copy ALL files from one folder to another folder

**misterno** · 10-30-2022, 11:06 AM

I need a VBA code that can do this

I want this vba code to copy all files from one specific folder to another specific folder

Thanks in advance

**Logit** · 10-30-2022, 01:05 PM

This is one method. The following will copy the folders and the files between folders.

Please Login or Register  to view this content.

**HSV** · 10-30-2022, 01:06 PM

No spaces in the foldernames.

Please Login or Register  to view this content.

**misterno** · 10-30-2022, 01:09 PM

I dont want to delete the files from the source folder

Also can we delete the part about date, I have no problem with the dates.

Can we adjust the coding as such please?

Thanks

**Logit** · 10-30-2022, 01:14 PM

At the very bottom of the FUNCTION code, eliminate these lines of code :

Please Login or Register  to view this content.

**misterno** · 10-30-2022, 01:17 PM

Originally Posted by Logit

At the very bottom of the FUNCTION code, eliminate these lines of code :

Please Login or Register  to view this content.

Thanks

it works

**Logit** · 10-30-2022, 01:39 PM

You are welcome.

**misterno** · 10-30-2022, 01:48 PM

never mind

**Logit** · 10-30-2022, 01:57 PM

Well ... according to your last posted example of code, you've implement the SUBS and the FUNCTION twice. Its like you pasted the code twice.

Did you mean to do that ?

**misterno** · 10-30-2022, 02:13 PM

Originally Posted by Logit

Well ... according to your last posted example of code, you've implement the SUBS and the FUNCTION twice. Its like you pasted the code twice.

Did you mean to do that ?

I have pinpointed the problem

It only copies excel files but it does not copy csv files

BTW, I doubled the code sorry about that. Code works perfectly for excel but not csv files

Can you please fix that?

Thanks

**Logit** · 10-30-2022, 02:21 PM

I tested the code here and cannot duplicate the error (.txt files) that you are seeing there.

The code is designed to copy all files without regard of the type.

???

**misterno** · 10-30-2022, 02:27 PM

Originally Posted by Logit

I tested the code here and cannot duplicate the error (.txt files) that you are seeing there.

The code is designed to copy all files without regard of the type.

???

I tried 2 files one excel one csv and it is copying the excel file but not the csv file

I can copy it manually with no problem but your code is not copying it for some reason

**misterno** · 10-30-2022, 02:33 PM

I just tried again with a different CSV file size 126kb and it worked

But the CSV file I am trying to copy is 9K kb, is that the reason why it is not copying?

This big file has 43K lines-rows of data

**misterno** · 10-30-2022, 02:53 PM

Logit

Would you please try your code with a large CSV file please?

And let me know

Thanks

**Logit** · 10-30-2022, 02:59 PM

Post the .CSV file you have that refuses to be copied. I'll use it and try to understand what is occurring.

**misterno** · 10-30-2022, 03:03 PM

Originally Posted by Logit

Post the .CSV file you have that refuses to be copied. I'll use it and try to understand what is occurring.

I tried to attach it but it failed

The max csv file size allowed as attachment is 1000kb

Is there another way to send it to you?

**Logit** · 10-30-2022, 03:07 PM

Try again but this time delete a good portion of the data in the file. Just need maybe 200 rows of sample data.

I forget what the max limit size is for files here.

**sintek** · 10-30-2022, 03:22 PM

Why not just copy the folder and rename?

**Logit** · 10-30-2022, 03:24 PM

He is having issues with only the single file. I suspect there is some type corruption affecting the copy process.

???

**misterno** · 10-30-2022, 09:59 PM

Nmbbnnnnn

Jhgbbbb

**misterno** · 10-30-2022, 10:02 PM

Originally Posted by Logit

Try again but this time delete a good portion of the data in the file. Just need maybe 200 rows of sample data.

I forget what the max limit size is for files here.

I will pm you

**Logit** · 10-30-2022, 10:39 PM

By chance, is the file format CSV for MacIntosh and not Windows ?

**misterno** · 10-30-2022, 11:17 PM

Originally Posted by Logit

By chance, is the file format CSV for MacIntosh and not Windows ?

windows 10 I am using

**sintek** · 10-31-2022, 01:24 AM

Ideally...Copy Folder contents at once to other Folder...
Change red snippets to your paths

Please Login or Register  to view this content.

Or if you want to copy one at a time then...

Please Login or Register  to view this content.

**Logit** · 10-31-2022, 01:11 PM

Sintek ... thanks for providing misterno a solution.

**misterno** · 10-31-2022, 01:55 PM

Originally Posted by sintek

Ideally...Copy Folder contents at once to other Folder...
Change red snippets to your paths

Please Login or Register  to view this content.

Or if you want to copy one at a time then...

Please Login or Register  to view this content.

Thanks it works even for the large file

**sintek** · 10-31-2022, 01:59 PM

misterno...No need to quote entire post...just clutters the thread...
Glad to have helped...Tx for rep +
Please remember to mark thread as SOLVED...

Logit...Just giving back...What I was taught...Tx

Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Re: Copy ALL files from one folder to another folder

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to copy .xlsm files in folder and sub-folder to foldr C:\old pull files

[SOLVED] Copy Folder then rename files in new folder from list in Excel

[SOLVED] How to copy Jpeg files from one folder to another folder with file name reference in excel

[SOLVED] VBA Code open files in folder, copy text to workbook-Next time folder opened copy only new

Bookmarks

Bookmarks

Posting Permissions