[NPMUG] [uva-mess] Excel 2004 for Mac and web pages

[Robert Peirce]

On Sep 10, 2009, at 8:08 AM, Will Martin wrote:

> Sorry to bother you with requests for more details, but in working  
> with spreadsheets since 1986, I've never worked with anybody who  
> has asked about this feature in Excel before. It's new to me.
>
> I pull up my virtual machine running Vista, open IE and go to the  
> link you gave me and pull up Excel 2007 and I can't figure out how  
> you do what you say you do in Windows Excel. Once I understand what  
> you are doing, I can begin to research alternatives on the Mac.  
> Until then, I'm useless to you.


Oops!! I wasn't completely clear what I was doing.  I am actually  
imbedding the query in a spreadsheet.  This is a brief note I wrote  
to myself when I first started to play with this stuff.

		On a Mac, the query must initially be stored in Office/Queries.   
Once there you can activate the query and imbed it in the spreadsheet  
via Data->Get External Data->Run Saved Query.
		You can remove it by finding, or knowing, the root of the query,  
selecting it and clicking on Data->Get External Data->Data Range  
Properties.  You then unclick the "Save query definition"
		box and it will go away.

Here is a query I prepared and imbedded in my spreadsheet.  This one  
gets a list of the most active stocks.  Stick it in Office/Queries  
and you will be able to imbed it in a spreadsheet.



Most of the queries in the spreadsheet I am using from the Windows  
machine were installed there, so I don't know all the details about  
them except that they get specific information from a web page.  The  
Mac gets the entire web page and the query cannot be edited as it can  
on Windows.   As applied to this particular query, your goal might be  
to extract the third most active stock, or something like that.  You  
can do this in Windows, at least I hope you can for this particular  
query; I really don't know for sure since I wrote it on a Mac!.  You  
can't do it on a Mac, at least not in 2004, if the web page changes  
at all from day-to-day because the third stock will move up or down  
by a line or two and the Mac has to access a specific cell.  It might  
be possible in a later release of Excel, in which case I should  
upgrade, or it might be possible in OpenOffice Calc or some other  
program, in which case I need to find out what to do.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://davesevick.com/pipermail/npmug/attachments/20090910/b5e9f02c/attachment.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Query for Most Actives
Type: application/octet-stream
Size: 228 bytes
Desc: not available
Url : http://davesevick.com/pipermail/npmug/attachments/20090910/b5e9f02c/attachment.obj 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://davesevick.com/pipermail/npmug/attachments/20090910/b5e9f02c/attachment-0001.htm