Good Morning,
I am working on an excel workbook that has a data connection to a page on the website fltplan.com. The site requires me to log in with a username and password. Currently I have the data connection set up utilizing data connections with a connection string like this:
https://ww8.fltplan.com/AwMPToFlightListing.exe?CRN10=xxxxxx&CARRYUNAME=xxxxx&MODE=DSB&end=end
I have removed my username and password info represented by the x's. The string works like I need it to but I have found the CRN10 information representing my password changes over time causing the connection to break. I then have to look at the source info for the webpage when I am logged in and get the new number representing my password, edit the string and re-save my workbook. I know I may not have this connection set up in the best way for what I am trying to accomplish. The connection imports flight schedule data into my workbook. Is there a better way to do this, possibly with VBA that will prompt for the connection username and password? Looking for better options than getting the source info and editing the string every time it changes.
Thanks in advance for your ideas.
I am working on an excel workbook that has a data connection to a page on the website fltplan.com. The site requires me to log in with a username and password. Currently I have the data connection set up utilizing data connections with a connection string like this:
https://ww8.fltplan.com/AwMPToFlightListing.exe?CRN10=xxxxxx&CARRYUNAME=xxxxx&MODE=DSB&end=end
I have removed my username and password info represented by the x's. The string works like I need it to but I have found the CRN10 information representing my password changes over time causing the connection to break. I then have to look at the source info for the webpage when I am logged in and get the new number representing my password, edit the string and re-save my workbook. I know I may not have this connection set up in the best way for what I am trying to accomplish. The connection imports flight schedule data into my workbook. Is there a better way to do this, possibly with VBA that will prompt for the connection username and password? Looking for better options than getting the source info and editing the string every time it changes.
Thanks in advance for your ideas.