I am writing VBA macro in Excel 2003 that includes opening an IQY file. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
></o
>
When I open an IQY file manually, I get a Import Data dialog box that asks<o
></o
>
<o
></o
>
"Where do you want to put the data?"<o
></o
>
- Existing Worksheet<o
></o
>
- New Worksheet<o
></o
>
- New Workbook<o
></o
>
<o
></o
>
and a an OK and Cancel button.<o
></o
>
<o
></o
>
How do I answer New Worksheet and OK using VBA code?<o
></o
>
<o
></o
>
The VBA to open the file works fine.<o
></o
>
Workbooks.Open Filename:="c:\temp\convert\owssvr.iqy"<o
></o
>
<o
></o
>
I tried adding NewWorksheet =TRUE with no luck.<o
></o
>
<o
></o
>
Any help would be greatly appreciated. <o
></o
>
Sorry. I am sure this is super basic.




<o


When I open an IQY file manually, I get a Import Data dialog box that asks<o


<o


"Where do you want to put the data?"<o


- Existing Worksheet<o


- New Worksheet<o


- New Workbook<o


<o


and a an OK and Cancel button.<o


<o


How do I answer New Worksheet and OK using VBA code?<o


<o


The VBA to open the file works fine.<o


Workbooks.Open Filename:="c:\temp\convert\owssvr.iqy"<o


<o


I tried adding NewWorksheet =TRUE with no luck.<o


<o


Any help would be greatly appreciated. <o


Sorry. I am sure this is super basic.
Last edited: