| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating data from a portal (web)
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Manipulating data from a portal (web)
Look into DataImport External DataNew 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 "Chinx21" . wrote in message ... 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help With Manipulating Data | Excel Discussion (Misc queries) | |||
| Help with manipulating data in excel? | Excel Discussion (Misc queries) | |||
| Need help using VBA to compare data in Excel columns, then manipulating data | Excel Programming | |||
| Manipulating Data in a row | Excel Programming | |||
| Help in calling excel files under portal | Excel Programming | |||
Linear Mode
