View Single Post
 
Old 01-05-2017, 05:46 PM
wlcdo2 wlcdo2 is offline Windows 7 32bit Office 2013
Novice
 
Join Date: Jun 2016
Posts: 17
wlcdo2 is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
You can download a progress bar userform from the link, and use the following code to update it.
Hello Graham,
I came across your post here which was very valuable for my project. Thank you. I did try the link to download but I kept getting a 404 error. Wasn't a deal breaker for me because I managed to create a Progress Bar version based on the additional code you had also posted in the same thread. Just wondered if you knew the link wasn't working? or maybe it's at my end?

Secondly, when I call my Progress Bar to display from Document_Open, it seems to run after Word has finished loading all other attributes of the document (i.e. ActiveX Controls, Shapes & Images, etc). I've tried calling it from Document_Open located in ThisDocument and also AutoOpen from a standard Module. My document takes perhaps 10 - 15 secs to open so I was hoping to display the Progress Bar at this time; Progress Bar is updated simply based on time interval as per your example. I'm currently using Word 2016 - if that matters?

Thirdly, I had to change Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) to Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) as I'm running a 64 bit system. Is there a way to use VBA to check whether 32 or 64 bit?

I'm still reasonably new to using these forums so I hope this isn't out of line & is is OK to ask?

Kind regards, Corin.
Reply With Quote