web query section search

[mike]

Hello,
I have created a web query on my PC that I would like to get to work on a
Mac. I converted the iqy to a txt on the Mac (so it is the same query). The
query asks for sections which the PC recognizes but the Mac version pulls
back the entire webpage. Is there any way for this same function to work on
the Mac?
Thanks in advance for any suggestions!

 

[Jim Gordon MVP]

Hi Mike,

I'm not sure this will make any difference, but try this:

Keep the .iqy file extension
From Excel's Data menu choose Get External Data then Run Saved Query.

Does the query behave any differently?

-Jim

 

[mike]

Hi Jim,
Thanks for the response.
It will not let me run the iqy. When I use help on web queries it says they
need to be created as a txt file. Any creative ways around this?!!!
Thanks again!

 

[mike]

Maybe some additional background would help... I am trying to import
financial data from MSN Money Central (10 yr summary of a stock). It provides
two tables that I want with a max of 10yrs of data each. The first data set
starts on the same row (c17 is the heading for the first set of data), but
the second data set can start on a different row depending on the avaialable
years worth of information (it also has its own heading). I do calculations
on the data from the web query so I reference the cells. Maybe there is a
different way to reference the start and end of each table's data set?
thanks

 

[Jim Gordon MVP]

What is the text of your web query?

 

[mike]

Hi Jim,
Sorry it took so long for me to respond. This is what one of the queries
looks like. There is one that is exactly the same except "Selection=9".
Thanks again for your help!

WEB
1
http://moneycentral.msn.com/investor/invsub/results/compare.asp?Page=TenYearSummary&Symbol=["Ticker","Enter ticker"]

Selection=8
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False

 

[Jim Gordon]

Hi Mike,

I see what you mean. It's not possible to predict exactly where on the
worksheet your data will be.

Mac web queries don't have the ability to grab just portions of the reply.

What you could do is write a macro that searches for a specific piece of
information, say Avg P/E. If you know that your date is always going to
be located within a specific range of cells around that tag then you
could copy and paste special>values of that range to a different area of
the worksheet or to a different worksheet and then perform the desired
calculations.

-Jim Gordon
Mac MVP