Using a web query/command button/macro to make a parts search from a secured site (Cessna)

[Hackboss007]

Hi everyone!

I'd like to make an aircraft parts search on a secured site (cpdexpress.com). I have credentials to access the search. However, I want to use the table that appears on their site to search for parts with prices. I want the exact same table on my excel sheet. In doing so, whenever they update their parts prices, it will automatically update on my excel sheet(kind of virtually using their table, offcourse I would have to sign in everytime but the advantage is that i can use the resulting values from the table within my excel sheet to be linked to other cells on my sheet) I tried the conventional web query method but when copying the table, I lose the table fuctionality and buttons that they have on their site to search for parts. Only color and the text gets copied.The "parts inquire" button to search for the part is not copied and I can't search for any parts. Any help would be very much appreciated. Thanks.

[Leith Ross]

Hello Hackboss007,

Because this is a secure site, you will not be able to provide the critical information needed to code a working solution. Unless there is member here at the forum who also has access to the site and the requisite programming knowledge to do this, you are pretty much out of luck.

[Hackboss007]

Hi Leith Ross,

That's a bummer! Thank you though!