Excel Web Query Connection to login automatically and pull specific tables

Hi,

I am new to the forum!

I have been researching for a long time about the best and fastest way to have excel automatically update a data table from a database I have to log into online, and import the correct data table.

--> Here is a link of another using doing what I believe is what I want to do. http://www.excelforum.com/excel-prog...matically.html
--> I've tried switching the code to my website, but honestly I'm not really sure at all what I'm doing.

So to spell it out better I want to: Open my saved excel sheet, the table automatically logs in to the database(with VBA? I think), finds my saved queries which when you run turn into tables, and pulls that information every time when I refresh in my excel sheet.

Here is the website: https://www.pinnavigator.jdpa.com/Na.../asp/Main.aspx

I really really appreciate your guys help with this. If this can be done and from the other link I posted it looks like it can, it would save me a lot of time and energy.

I also realize this might be a little confusing or you need more information so I will provide that as soon as possible.

Thank you,

Stuart