VBA need to input yesterdays date in a field in IE11

Hi John,

Try something like:

Please Login or Register  to view this content.

Change the contents of the format statement to suit your web site requirements.

Lewis

Basic example, of course you can change the date formatting to whatever you want:

Please Login or Register  to view this content.

HTML Code: 

This is the code for the box I am trying to enter this in.

HTML Code: 

I think this is the full code for this area.

correct, there is a table cell for selecting the date, or you can just type in the date and click a submit button under this.

I was thinking that entering the date and clicking the button would be a lot easier than using the table.

In my playing with this Table Cell I have found that I can click on the Table and press the left arrow, this will always put me on the previous date. Enter after this will fill the box I am looking to fill with the date needed.

Think this may be the best way to get this done?

Only reason I am reluctant to post the entire page code is, it does contain many private html links. Is there a certain piece of this code you are looking for?

Code for boxes and Table Cells

HTML Code: 

Code for button

HTML Code: 

Thank You Leith Ross,

This is not working for what I am trying to do. I have come up with the code below, as I have found that by simply clicking the calendar box and pressing the left key then enter this will ALWAYS select the previous date.

as of now this is what I put in, but it is not working in the calendar box.

Please Login or Register  to view this content.

Do you know of any way to make the sendkeys function act in the calendar box?

Thanks,
John

Note: I can select the calendar box, I am just having trouble getting VBA to act in this window when it is opened.

Any ideas?

Originally Posted by Leith Ross

Hello Johhnyv150,

Here is the promised code. You will have to adapt this to your code. This lets you select the starting and ending dates and clicks the "Get Report" button.

After doing some testing, it seems that an Input object will default to Type "text" if the Type property is missing. Although I could not find it any HTML literature, it proved to be true through testing.

Please Login or Register  to view this content.

I have tried using this code with the Input value of "Date() -1" but I am getting the runtime error 91 when entering the "With" statement.


Any ideas on how to solve this?

Thanks,
John

Please Login or Register  to view this content.

Originally Posted by Leith Ross

Hello John,

The "With" statement assigns the HTML objects to VBA object variables. The date would be assigned to either"Output1" or "Output2". These are the start and ending dates respectively.

The date must be a string in the format mm/dd/yyyy.

For Example...

Please Login or Register  to view this content.

Thanks Leith Ross,

I think I am missing something. I am using this.

Please Login or Register  to view this content.

still pulling the runtime 91 when the code gets to "With IE.document"

Originally Posted by Leith Ross

Hello John,

Internet Explorer runs asynchronously. Which means what VBA executes is not in sync with Internet Explorer. That is why the first While loop is used.

This keeps VBA occupied until Internet Explorer has loaded the web page. However, a loaded web an HTML document does not make. There is a certain about of time needed to convert the text into their HTML counter parts.

It is not uncommon for the document not to have been converted by the time VBA executes the "With IE.Document" statement.

You can add another loop to check that the document exists before proceeding like this...

Please Login or Register  to view this content.

I have added the second loop, and I am running the whole macro through steps "F8". and I am still getting the runtime error 91 at the With Statement.

here is my full code as of now. everything is running fine up to the point we are speaking about.

Please Login or Register  to view this content.

hmmm. still got the runtime 91 object variable or With block variable not set.

Do not remove Busy condition from waiting loop !

Other tip : IE.locationName is equal to the title of the webpage only when IE finishes to load it …

GOT IT!
Thank you so much Leith Ross, you have been an amazing help on this. I ended up running the same code as above only I added a application.wait line to halt VBA for a minute while the page loaded up. Works like a champ.

Thanks Again,
John