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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

D
  • Question Question
web scraping help
Replies
0
Views
440
dwatters
D
E
  • Question Question
From two dates, dividing the years into different columns, create hyperlinks organized by quantity and not by dates
Replies
0
Views
313
ExcelenteNovel
E
JeffGrant
  • Solved
When is a workbook too big?
2
Replies
11
Views
2K
Michael M
Michael M
K
  • Question 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
709
Micron
M
M
  • Question Question
Find and Replace Reference Worksheet Name
Replies
3
Views
1K
multifidus
M

Forum statistics

Threads
1,223,231
Messages
6,170,885
Members
452,364
Latest member
springate

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