Applescript and Webquery or IQY file

R

rkaneknight

Version: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel

I have been scouring the web for an answer to what I believe to be a simple question, and everything I find is VBA this and VBA that. I'm on an Apple, don't give me a VBA answer. Office 2008 doesn't use VBA.
I currently have an excel file that I open with applescript, and right now it automatically refreshes the data from my webqueries. I need to have it wait to refresh until Applescript can get a start and end date from the user and set these to cells in the document that the query uses for it's parameters.
Put simply, "How do I tell excel 2008 to refresh a webquery with Applescript?"
So I can have all the work done in the correct order.
 
R

rkaneknight

well I just added this after I opened up the workbook containing the webquery.

refresh all active workbook

That was too simple. I love Applescript.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using formulas inside AppleScript 2
Get Save As Filename Dialogue Box using Applescript 4
How do I define a range by using cells as coordinates? 6
Visual Basic conversion to Applescript 3
AppleScript Save to desktop instead of original file location 1
Applescript chart creation in Excel 1
AppleScript Page Setup and Paper Size 1
Clearing Excel format with Applescript 4

Top