Open an Excel file without getting extra dialog box

Share icon

Tue, 10/26/2021 - 11:35 am

Hi. I would like to load an Excel file programmatically using XLLoadWave. No matter what flags I try, I keep getting the dialog box shown. Is there a way to avoid this dialog? I want to load my file without any user interaction.

 

 Load Excel File dialog

OK, solved. The dialog appears if I type the command into the command window, as I did to try it out. But it doesn't appear if the same command is called from a function.

October 26, 2021 at 12:05 pm - Permalink

If the dialog comes up, then either you have used the XLLoadWave /I flag, or XLLoadWave does not know what worksheet or cells you want to load.

Specify the worksheet using the /S flag and the cells using the /R flag.

If you need further advice, please post the XLLoadWave command that you are executing.

 

October 26, 2021 at 03:18 pm - Permalink