Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    diegomarino is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    409
    My pleasure.
    To be more precise, i added just sleep before saving. 1700 milliseconds allow the chart load properly even on the most big data. You should choose the duration empirically



    Code:
    xlx.DisplayAlerts = False
    Sleep (1700)
    xlw.Close SaveChanges:=True
    xlx.DisplayAlerts = True
    
    to be able using sleep function read this
    https://nolongerset.com/how-to-pause...rval%20elapses.

  2. #17
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    A common practice that may serve you down the road for this sort of thing is to write a timer sub that accepts an input as a duration. When code branches to the timer code for x seconds (or part seconds if the parameter is a Single) you achieve a delay. The advantage is that you can call it with one line from anywhere in your project.
    Thanks for the update!
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 11
    Last Post: 12-25-2015, 02:41 PM
  2. Replies: 2
    Last Post: 04-06-2015, 12:08 PM
  3. Image Load
    By RayMilhon in forum Forms
    Replies: 2
    Last Post: 12-03-2014, 06:30 PM
  4. Export Access Chart to Excel using VBA code
    By ADFC in forum Programming
    Replies: 8
    Last Post: 04-09-2014, 03:05 PM
  5. Bitmap image won't export to excel?
    By C6067 in forum Import/Export Data
    Replies: 2
    Last Post: 03-04-2013, 03:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums