Loading multiple excel sheets without ussing a connection

[#1]

Hi,

I need help to load multiple excel sheets to QlikView without using any connection because it is not allowed in the enterprise. Is there any way to do this only by programming in the script?

Thanks a lot!

[Jason_Michaelides]

What do you mean "without any connection"?  To load an Excel doc you only have to point the script to the file location.

[#3]

Please elaborate your question.

[#4]

I'll try to explain myself better, what I'm trying to do is load all the sheets from an excel workbook without doing it one by one.

The only examples I found to do this was by connecting to the ODBC excel files or through OLE DB jet 4 or something like that, but I can't do either way because it ask me for a User and Password which I don't have.

I would like to know if there is a way to code this like an Excel  macro that loops through all the sheets.

Thanks.

[Jason_Michaelides]

There're loads of threads on here on that - have a search and you'll find some!

[Jason_Michaelides]

Here's one...

http://community.qlik.com/message/308287#308287

[Gysbert_Wassenaar]

Afaik the only time you need a password for an odbc connection to an excel file is if the excel file is password protected. And if that's the case then an odbc connection is also the only way to load data from an excel file.