Open an Excel file without getting extra dialog box
amtravco
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.
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