Manipulating data from a portal (web)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi! I'm trying to query data from a portal of our company and then save it to
a workbook. could somebody help me please. Is it possible to connect in a
portal from excel using VBA? because every seconds data from the portal
changes. I mean is it possible to have a dynamic connection like when the
data from a portal changes the data which I got from the portal also changes;
Thanks!
 
Look into Data>Import External Data>New Web Query, recording a macro to get
to code.
The results will depend on the nature of you web server and the structure of
the HTML.

NickHK
 
You must log in or register to reply here.

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

Capture Date from External Sharepoint Portal 3
VBA copy and paste data 2
Macro to navigate through a Java Web-Page 1
Can I use a macro to create a macro in a new workbook? 3
Copy and paste same cell from a number of sheets into a new sheet 3
Calling Excel shortcuts from VBA 1
Steam: Portal *FREE* - Offer Ends 24th May! 4
Saving a workbook to an iKnow portal 2

Back
Top