VBA to change date in Data picker on web page

**freespirityu** · 02-13-2018, 04:18 AM

Here is my code:

Please Login or Register  to view this content.

VBA open page and it does change dates to one I've set but doesn't apply data range to generate report. I've noticed later that DateFrom is readonly. How can I change DateFrom and DateTo with VBA and execute date change to generate report?

For some reason I couldn't post HTML code in this thread...

Thnx guys!

**AliGW** · 02-13-2018, 04:19 AM

No, HTML code is blocked by the server - sorry. It's a security measure.

**freespirityu** · 02-13-2018, 04:22 AM

Ah, ok... Anyway, question still standing! I'm clueless what to do here...

**AliGW** · 02-13-2018, 04:24 AM

Of course the question is still standing - why wouldn't it be? What might help, though, is if you could attach a Notepad file containing the HTML code.

**freespirityu** · 02-13-2018, 04:24 AM

DateFrom, DateTo and GO.PNG

Here is at least as SCRCPTR!

**AliGW** · 02-13-2018, 04:25 AM

That's tiny - very hard to read and not editable. Please attach a Notepad file with the code in it.

**freespirityu** · 02-13-2018, 04:45 AM

I couldn't attach file for some reason, so here is link to gDrive:

https://drive.google.com/open?id=1gC...Qz5GG5VLmhb2bC

**AliGW** · 02-13-2018, 04:56 AM

Attach the file directly here, please. Many members will not or cannot access file-sharing sites.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.