How to downloaded multiple excel file copy in new only one excel but different sheet name

Help Studio
,
1

Hello,

I’m downloading multiple excel files after that I have to put all data from those excel files but only in one excel file.

And I have to change sheet names also as a downloaded files name
Like
(continue screening, Watchlist added and watchlist updated)

2

@suraj_gaikwad

do you need all the excel files into a single sheet

or you want all excel files into a single file with different sheets

3

@suraj_gaikwad

  1. Use for each file in folder activity which contains all your excel files
  2. Inside loop use read rnage with currentfile.Fullname
  3. Inside that use write range workook with filename and sheetname can be currentFile.Name and data would the output from step2

cheers

4

After downloading multiple excel files get that data and paste where I’m creating a new excel file with name

@Shiva_Nikhil @Anil_G

Thanks

1 Like