+ Reply to Thread
Results 1 to 9 of 9

VBA to change date in Data picker on web page

  1. #1
    Registered User
    Join Date
    04-21-2015
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    12

    VBA to change date in Data picker on web page

    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!

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: VBA to change date in Data picker on web page

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


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-21-2015
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    12

    Re: VBA to change date in Data picker on web page

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

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: VBA to change date in Data picker on web page

    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.

  5. #5
    Registered User
    Join Date
    04-21-2015
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    12

    Re: VBA to change date in Data picker on web page

    DateFrom, DateTo and GO.PNG

    Here is at least as SCRCPTR!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: VBA to change date in Data picker on web page

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

  7. #7
    Registered User
    Join Date
    04-21-2015
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    12

    Re: VBA to change date in Data picker on web page

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

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

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: VBA to change date in Data picker on web page

    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.

  9. #9
    Registered User
    Join Date
    04-21-2015
    Location
    https://t.me/pump_upp
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    12

    Re: VBA to change date in Data picker on web page

    Ok, here it is in .txt...
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Date Picker Error in another page using Userform Multipage
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2017, 06:24 AM
  2. [SOLVED] Excel Data From Web using dropdown list to change website date page...
    By Ourkid123uk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2017, 02:17 PM
  3. [SOLVED] Change Date with Date Picker If Date Less Than 7 Days From Another Date
    By Macfool in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-16-2016, 09:10 AM
  4. Replies: 5
    Last Post: 04-06-2016, 06:58 AM
  5. Date Picker to change date
    By mohansingh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2015, 09:43 AM
  6. [SOLVED] Date Time Picker Change to Text
    By juriemagic in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 10-23-2014, 08:49 AM
  7. Date Picker - can't change start date
    By JohnFex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 04:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1