You can write a vbs macro in the macro edititor and call the the function to get what you need. You just can not referance the QV API in the load script.
Creating a QVD file is as has been suggested as simple as calling the STORE function.
When you say you wish to do it each time there is a new Excel file - can you please explain what you mean. Is it that you have a drop folder an each time an Excel file appears in it you wish to incorporate it into your dataset?
I am sure there will be a solution to what you are after - I'm not sure I understand the problem at the moment though.
If all the Excel files follow a consistent filename and have identical columns in them then it is a simple matter of using a wildcard (*) in the file name when you do the load script. I have posted a video to YouTube at http://bit.ly/bs9BSh showing basic multiple file functionality.
If the file names or the formats are irregular then you will need to loop around each Excel file in the folder to process each one. The code for this is a bit like:
For each File in filelist('c:\folderpath\*.xls*') TableName: LOAD * FROM [$(File)] (ooxml, embedded labels, table is Sheet1); Next
But you will need to make sure that you at least have the same format for all of your Excel files and the sheet name you wish to load from is consistent.
If you can not rely on this then you may be able to achieve what you are after by using an ODBC connection to each Excel file - as this will be a bit more tolerant of format changes.
Thanks for the post. I have similar requirement but should be done in incremental load way. I have multiple excel file source with date suffix. I want to load all the excel files but incremental, it should load the files which is already processed or loaded in QVD. Need help.
