Importing multiple .txt files having the current date in the filename using VBA

shubhamsinghrathore

New Member
Joined
Aug 14, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hi there,

with respect to one of my process automation, can anyone help me with the VBA code to use multiple latest .txt files imported in a single sheet in a workbook.
Following are the requirements that are needed to get this automated:-

1. Every Monday 5 different files with the name "Client+Delivery+Schedule+1+(primary)YYYYMMDD.txt" are generated, they all have the same name except the number after schedule changes in every one of them, from 1 to 5.
which would look like this:
Client+Delivery+Schedule+1+(primary)20220808
Client+Delivery+Schedule+2+(primary)20220808
Client+Delivery+Schedule+3+(primary)20220808
Client+Delivery+Schedule+4+(primary)20220808
Client+Delivery+Schedule+5+(primary)20220808

2. all of them have data starting with a header of name, ids, etc in the first row, so I need to copy the data from files 2 to 5 starting from the 2nd line and has to be posted on the same worksheet from where the previous file data ends.

3. the data, in the end, has to be exported in the .txt file only with the name "Client Delivery Schedule (primary)YYYYMMDD.txt"

since this is repetitive every Monday, hoping to get this automated.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,213,549
Messages
6,114,261
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top