MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

how 2 connect Excel Sheet With other Application

  Asked By: Elliott    Date: Aug 24    Category: MS Office    Views: 2040

Im new to this excel n VBA,
Just wanna know is it possible to connect Excel Sheet With other Application

if Yes Just Tell me how .

It would Be Helpful if any one Explains Login Process

LOGIN --->Select reports using Button in Login_sucesses frm (1.htm) --->
Display 1.htm in Excel



3 Answers Found

Answer #1    Answered By: Aamanee Khan     Answered On: Aug 24

And obviously to asking questions on groups too?

Please write in proper English. I (for one) am not interested in working
round abbreviations and slang.

Please give a little mode detail (OK a LOT more detail). For instance, what
other application?

What investigation have you done prior to writing this message? Detail it.

Please read http://www.catb.org/~esr/faqs/smart-questions.html to learn a
little more about asking questions properly. Then, by all means, ask a
well-researched and thought out question.

Answer #2    Answered By: Michele Grant     Answered On: Aug 24

I 'm looking for
detailed information on how to use VBA to grab data from a website requiring
a username/password login.
I need to connect  an excel  spreadsheet to a website that requires login
credentials and task would be to login  and obtain reports  and dump them
into excel.
and I have Username/Password for this site .

initially i checked this Forum nothing seemed to work

2. http://www.ozgrid.com/forum/showthread.php?t=19168

Answer #3    Answered By: Aberto Rossi     Answered On: Aug 24

That question is much easier to understand.

First make sure you can connect  to the website using Data/Import External
Data/New WebQuery. If that works then turn on macro record and do the same
again. This will record a macro that will do the task for you.

You can then look at the macro and try to understand what it is doing. If you
want to change anything try altering the macro to make your changes.

If you get stuck please come back to the list. When you do that please
include the code you are using in your post as that will make it easier for us
to understand what is happening.

Didn't find what you were looking for? Find more on how 2 connect Excel Sheet With other Application Or get search suggestion and latest updates.