Excel plus WEB World

[vikas.bhandari]

Usually I need to go to clients Site and pull some reports depending on some parameters. For example, I need to go to my client's Site, and then I select the Sale Type, for example Credit/Cash...I select one option and click submit then it returns me an excel file with the output with an option to download....can I do this with Excel Macro??? Is there any HTTP Model I can use in this...I never tried this so if u can give me some useful links to learn or create something....that will be wonderful!!

[Bryan Hessey]

Usually I need to go to clients Site and pull some reports depending on some parameters. For example, I need to go to my client's Site, and then I select the Sale Type, for example Credit/Cash...I select one option and click submit then it returns me an excel file with the output with an option to download....can I do this with Excel Macro??? Is there any HTTP Model I can use in this...I never tried this so if u can give me some useful links to learn or create something....that will be wonderful!!

Hi,

it apparently doesn't work on the OP's local net, but you could start with the code shown at http://www.excelforum.com/showthread.php?t=585587

hth
---

[vikas.bhandari]

Hi,

it apparently doesn't work on the OP's local net, but you could start with the code shown at http://www.excelforum.com/showthread.php?t=585587

hth
---

Well, i have no idea about any ports are opened or not...can you shred some lights on how this technology works??

Thanks!!!

[Bryan Hessey]

Well, i have no idea about any ports are opened or not...can you shred some lights on how this technology works??

Thanks!!!

unless you are intending to use it to access private web pages on an internal network that part doesn't matter.

Did you try the code, and did it load the web page for you?

---

[vikas.bhandari]

unless you are intending to use it to access private web pages on an internal network that part doesn't matter.

Did you try the code, and did it load the web page for you?

---

Yeah..it gives me an error of Application Defined or object Defined Error..

Just an FYI..the page is on 128 bit(HTTPS).

Also, when I go to some of my Client's Sites and choose rght click-->export data to excel....then I gve an error whose image I have attached here...

Plzzzz Plzzzz help me

Thanks!!!

[Bryan Hessey]

Yeah..it gives me an error of Application Defined or object Defined Error..

Just an FYI..the page is on 128 bit(HTTPS).

Also, when I go to some of my Client's Sites and choose rght click-->export data to excel....then I gve an error whose image I have attached here...

Plzzzz Plzzzz help me

Thanks!!!

the https doesn't seem to scare the sub, these both work on Excel 2003 (English) version

Please Login or Register  to view this content.

---
added,

also, either site works with the 'Export to Microsoft Excel' - but the active pane only is exported from the HTTPS site.

---

[vikas.bhandari]

OK...i wil give it a try..but tell me one more thing(I hope I am not being a Pain )......suppose If I have a HTML/ASP File on my local hard disk which gives me output after selection some options in a combobox...

Suppose in my Combobox..following are the values :

--Select age--
Option 1 = 18-20
Option 2 = 20-22
Option 3 = 22-24
Option 4 = 24-26

If I select one option, it gives me the result for the respective...now How can i actually transfer the results in to excel from a macro???

Thanks!!!

[Bryan Hessey]

OK...i wil give it a try..but tell me one more thing(I hope I am not being a Pain )......suppose If I have a HTML/ASP File on my local hard disk which gives me output after selection some options in a combobox...

Suppose in my Combobox..following are the values :

--Select age--
Option 1 = 18-20
Option 2 = 20-22
Option 3 = 22-24
Option 4 = 24-26

If I select one option, it gives me the result for the respective...now How can i actually transfer the results in to excel from a macro???

Thanks!!!

a combobox would normally have a Linked Cell, where the selected value would be found. If this is a Forms combo then rightmouse and Format Control to see.

From your macro you can pick up the value of this cell.

hth
---