Alt shift f11

[JAbraha1]

I used alt shift F11 to change out the source queries in my workbook. But when I try and save, it gives me an error message about HTML. Why is it being saved as html? any ideas? I tried changing the database query source in the SQL, but the alt shift f11 mode reverts back to the old source.

 

[Andrew Poulsom]

Alt+Shift+F11 launches Microsoft Script Editor. What has that to do with a QueryTable?

 

[JAbraha1]

The only way in the past that I've been able to change access database souces in excel, was to edit within the MSE mode.

 

[Andrew Poulsom]

Maybe this will help you:

http://www.dicks-clicks.com/excel/ExternalData3.htm