Where is the "new internet query" option on the Get external data ?

[shunulu]

My friend has a couple excel files include internet query data. She
asked my help. Yes we can refresh them but can not create them on her
Mac. Where is our mistake ? Mac Office is different in this ?

 

[Jim Gordon MVP]

Hi,

Unfortunately in this case Mac Office is different. The fancy query browser
didn't make it into Mac Office yet.

-Jim Gordon
Mac MVP

My friend has a couple excel files include internet query data. She
asked my help. Yes we can refresh them but can not create them on her
Mac. Where is our mistake ? Mac Office is different in this ?

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[shunulu]

Hi,

Unfortunately in this case Mac Office is different. The fancy query browser
didn't make it into Mac Office yet.

-Jim Gordon
Mac MVP

Thanks for your help Jim. Does Microsoft have any reason for this ?
Technical problems ? Or famous PC-Mac wars Someone must say this to
Steve

 

[JE McGimpsey]

Does Microsoft have any reason for this ?

I don't speak for MS's Mac Business Unit (MacBU), but it's usually a
matter of resources and customer demand.

Technical problems ?

Expect it's more that the available resources were applied to other
features.

Or famous PC-Mac wars

Nope. I've never seen any evidence that there's been any limitation on
MacBU because of Operating System competition. Since MacOffice is
profitable, it wouldn't make any business sense to deliberately cripple
it.

Someone must say this to Steve

This is one way. You're probably better off using Help/Feedback in any
Office 2004 app.

 

[Jim Gordon MVP]

Hi Steve,

This feature was introduced at about the same time Microsoft decided to get
out of the web browser business. The fancy query browser is actually a web
browser that's been rigged pick out tables and make them into Excel web
queries.

I think if Microsoft had decided to stay in the Web browser business then
the feature would have been implemented on the Mac.

That being said, the next version of Office for Mac has a default file
format of XML. So like it or not, one way to to think of all the Office
applications is that they are specialized web browsers and web editors. That
at least gives hope that some day (maybe not the next version) that this
feature could eventually find its way into Mac Excel.

-Jim Gordon
Mac MVP

Thanks for your help Jim. Does Microsoft have any reason for this ?
Technical problems ? Or famous PC-Mac wars Someone must say this to
Steve

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Hilena Hailu [MSFT]]

Hi Steve,

It is possible to create custom Web Queries in Mac Excel. To do this
manually, please follow these steps:
1. Create a query file (see KB article at
http://support.microsoft.com/kb/274787/en-us) and place it in the Microsoft
Office 2004:Office:Queries folder.
2. Go to Data/Get External Data/Run Saved Query
3. Select the query file you created in Step 1 and the rest is self
explanatory.

If you prefer to do it programmatically using VB, please see the following
KB article: http://support.microsoft.com/kb/187364/en-us.

Let me know if you have further questions.

Regards,
Hilena Hailu
Macintosh Business Unit
Microsoft Corp.

 

[shunulu]

Hi Steve,

It is possible to create custom Web Queries in Mac Excel. To do this
manually, please follow these steps:
1. Create a query file (see KB article at
http://support.microsoft.com/kb/274787/en-us) and place it in the Microsoft
Office 2004:Office:Queries folder.
2. Go to Data/Get External Data/Run Saved Query
3. Select the query file you created in Step 1 and the rest is self
explanatory.

If you prefer to do it programmatically using VB, please see the following
KB article: http://support.microsoft.com/kb/187364/en-us.

Let me know if you have further questions.

Regards,
Hilena Hailu
Macintosh Business Unit
Microsoft Corp.

--------------------------------------------------------------

Hi Hilena,

First of all i am not Steve That Steve is Steve Jobs and we tries to
reach him for to hear us ! Thanks your helps and i will try your
suggestion as soon as possible. I'm really glad to see Mac BU in
action. I hope someday, we can use web query just one click Thanks
again your interest.

 

[Jim Gordon MVP]

Hi

I wrote a little add-in that you can type or paste a URL into for quick web
queries:
http://www.acsu.buffalo.edu/~gordonj/XL/DownloadPage.htm

It could be modified to accept additional parameters. Would that be of
interest to you?

-Jim Gordon
Mac MVP

Hi Hilena,

First of all i am not Steve That Steve is Steve Jobs and we tries to
reach him for to hear us ! Thanks your helps and i will try your
suggestion as soon as possible. I'm really glad to see Mac BU in
action. I hope someday, we can use web query just one click Thanks
again your interest.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[shunulu]

Hi

I wrote a little add-in that you can type or paste a URL into for quick web
queries:
http://www.acsu.buffalo.edu/~gordonj/XL/DownloadPage.htm

It could be modified to accept additional parameters. Would that be of
interest to you?

-Jim Gordon
Mac MVP

Jim, it works perfectly ! Thanks a lot !!! I have no words to say, just
thank you

 

[rantcliff]

Jim,

I downloaded the file and tried it out. It brings in the web page OK,
except that it always brings the full page in and not just the table.
When I click on the Tabels only, I still get full pages, not just
tables. Any ideas?

Rich

 

[Jim Gordon MVP]

Hi Rich,

I'm hoping the next version of Excel has more robust web query behavior.

-Jim Gordon
Mac MVP

Jim,

I downloaded the file and tried it out. It brings in the web page OK,
except that it always brings the full page in and not just the table.
When I click on the Tabels only, I still get full pages, not just
tables. Any ideas?

Rich

Hi

I wrote a little add-in that you can type or paste a URL into for quick web
queries:
http://www.acsu.buffalo.edu/~gordonj/XL/DownloadPage.htm

It could be modified to accept additional parameters. Would that be of
interest to you?

-Jim Gordon
Mac MVP

Hilena Hailu [MSFT] wrote:
Hi Steve,

It is possible to create custom Web Queries in Mac Excel. To do this
manually, please follow these steps:
1. Create a query file (see KB article at
http://support.microsoft.com/kb/274787/en-us) and place it in the Microsoft
Office 2004:Office:Queries folder.
2. Go to Data/Get External Data/Run Saved Query
3. Select the query file you created in Step 1 and the rest is self
explanatory.

If you prefer to do it programmatically using VB, please see the following
KB article: http://support.microsoft.com/kb/187364/en-us.

Let me know if you have further questions.

Regards,
Hilena Hailu
Macintosh Business Unit
Microsoft Corp.

--------------------------------------------------------------

Hi Hilena,

First of all i am not Steve That Steve is Steve Jobs and we tries to
reach him for to hear us ! Thanks your helps and i will try your
suggestion as soon as possible. I'm really glad to see Mac BU in
action. I hope someday, we can use web query just one click Thanks
again your interest.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info