Classic Search

Excel with multiple sheets · ‎2011-01-05

Hi, How to load the data from the multiple sheets of an excelsheet. I have an excel which has 5 sheets all the data is from single table. Do i need to write a seperate load statement for each sheet...

Load multiple sheets and excel files · ‎2014-01-23

Hi all Posted this question before but couldnt find a complete solution. I have multiple excel sheets and workbooks. How do I loop them? Please see attached. Could do if it was one excel file b...

Loading multiple sheets from excel · ‎2016-02-29

Hi, I'm trying to load multiple sheets from an excel document. I know there are already many tutorials available. I checked out a lot, but still I don't managed to get it fixed. I tried to r...

3 Likes · ‎2012-05-29

Hi, I need to load data from multiple Excel files which each contain multiple sheets. I need to filter files by name (eg. *_sys.xlsm) and sheets by names (eg. 'start with number and atleast 4 c...

keithlawrence · ‎2019-06-04

Hi Community, We're struggling with something that should, in theory, be quite simple. We have multiple Excel files with multiple sheets. All the sheets have the same data structure but t...

JohnSamuel123 · ‎2021-05-20

hi experts, hopefully an easy one. i need to pull in just the filetimes of multiple excel sheets in different folder locations. what would be the most efficient way to do this in the script? i d...

tamilarasu · ‎2015-06-09

Community, I have requirement to consolidate all excel sheets from multiple workbooks. I searched in forum and got some ideas but I have some problem in getting the desired result. * My data i...

1 Like · ‎2014-06-09

Hi everyone, I use this macro below to export multiple object to excel. What I need is to add some code to export more object to other sheet in excel. I would appreciate your help sub t...

4 Likes · ‎2012-09-12

...iles may have no of worksheets and are not limited in number and may vary from book to book -Name of every sheet in the every excel file is different -In every source excel file only the 1st sheet w...

josielaidlaw · ‎2019-03-05

Hi! I have a folder on my computer, "Liefermenge," and in it, a folder "Quote." In the quote folder is a number of different files, but I would like to create a loop to load only the one...

Classic Search

Search

Search the Community

Excel with multiple sheets

Load multiple sheets and excel files

Loading multiple sheets from excel

Loading from multiple Excel files and multiple she...

Load multiple Excel files with multiple sheets

Getting Filetime from multiple excel sheets

Consolidate multiple sheets from multiple excel fi...

Export multiple object to multiple sheets - Excel

Load multiple excel files from Multiple excel shee...

loop to load multiple excel sheets