Get data from files in a folder

[VishalGupta]

Hi all,

I have some reports to upload in a software. These reports are excel files saved in a folder. They have unique names and set format. Since these reports have to be in a different format to be uploaded I wanted to write a piece of code to get my work done in two stages:
Stage 1: Go to all the files in the folder and copy the first worksheet onto a new sheet.
Stage 2: Once all the sheets are in one master file, Copy paste certain columns from all reports in a new worksheet to prepare the format.

I can manage Stage 2, how do i approach Stage 1? Thanks for your help.

With regards,
Vishal Gupta

[snb]

Please, have a look at this post.

[farrukh]

Hi VishalGupta,

Try the below code. Set the path you wished too ( MyPath = "D:\great" ' change to suit)

Please Login or Register  to view this content.

Thanks
farrukh

[VishalGupta]

Thanks guys..I won't be able to implement the coding you have given this week but I am sure it will work fine. Thanks for your help again. Will mark the thread as solved when I have implemented your code.

[farrukh]

If you like any of my suggestions please click the reputation icon in the right upper corner.

Mark a thread as 'solved' instructions

Thanks
farrukh