+ 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
    Serbia
    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
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    44,227

    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!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    04-21-2015
    Location
    Serbia
    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
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    44,227

    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
    Serbia
    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
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    44,227

    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
    Serbia
    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
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    44,227

    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
    Serbia
    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