HELP! Fill out web forms then run web query

Status
Not open for further replies.
S

sfranks105

New Member
Joined
Jun 30, 2008
Messages
10
I am trying to pull information from a website using a web query in Excel 2003. This part is easy. Now for the difficult part, in order to pull the information I need, I have to manipulate a drop down menu within the page and run my choice. The problem is the site returns the desired information but the URL remains the same, so the easy way out is not available. This is at PWCmoneytree.com > historical trend data. I tried recording macro to get coding for this but it doesn't seem to fully address the problem (incomplete instructions because the query window outside of workbook? Not really clear on this). I also tried saving the html and using the code but I can't figure it out. Any help or direction would be greatly appreciated.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

D
  • Question
web scraping help
Replies
0
Views
233
dwatters
D
E
  • Question
From two dates, dividing the years into different columns, create hyperlinks organized by quantity and not by dates
Replies
0
Views
155
ExcelenteNovel
E
JeffGrant
  • Solved
When is a workbook too big?
2
Replies
11
Views
1K
Michael M
Michael M
K
  • Question
Need to create/source a macro/vba/program that auto populates info based on matching word criteria for community support agency
Replies
3
Views
464
Micron
M
M
  • Question
Find and Replace Reference Worksheet Name
Replies
3
Views
821
multifidus
M

Forum statistics

Threads
1,215,227
Messages
6,123,743
Members
449,116
Latest member
alexlomt

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top