By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,208 Members | 1,072 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,208 IT Pros & Developers. It's quick & easy.

Progress bar needed during Excel macro call from MS Access.

P: n/a
I don't know if there's even a way to do what I want. I click on a
button in an Access form, and it opens an instance of Excel, and opens
a workbook and runs a macro that's in it. So far, fine, I know how
to do this. I'm preferring to keep the Excel instance invisible, but
while the macro is running, it would be nice to see some sort of
progress indicator.

(By the way, here's basically what the Excel macro is doing: it's
opening nine workbooks, doing a lot of copying and pasting, and then
saving a workbook. I'd be satisfied if, after each of the 9 workbooks
that get opened, some sort of display shows on the screen so the user
knows that workbook is finished.)

It almost seems as if Excel would need to have a way to display info
on an Access form. Is that even possible? Or alternatively, maybe I
should not make the Excel instance invisible, and then the progress
could be displayed on some sort of Excel screen. The only thing is,
if the Excel instance is visible, the screen will be flashing kind of
annoyingly, due to the large amount of copying and pasting going on.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Add the following to your Excel VBA code:

at the beginning:

Application.ScreenUpdating = False

And obviously at the end:

Application.ScreenUpdating = True

This will also speed up your Excel code.

P

"Mrs Howl" <ti********@yahoo.com> wrote in message
news:5b************************@posting.google.com ...
I don't know if there's even a way to do what I want. I click on a
button in an Access form, and it opens an instance of Excel, and opens
a workbook and runs a macro that's in it. So far, fine, I know how
to do this. I'm preferring to keep the Excel instance invisible, but
while the macro is running, it would be nice to see some sort of
progress indicator.

(By the way, here's basically what the Excel macro is doing: it's
opening nine workbooks, doing a lot of copying and pasting, and then
saving a workbook. I'd be satisfied if, after each of the 9 workbooks
that get opened, some sort of display shows on the screen so the user
knows that workbook is finished.)

It almost seems as if Excel would need to have a way to display info
on an Access form. Is that even possible? Or alternatively, maybe I
should not make the Excel instance invisible, and then the progress
could be displayed on some sort of Excel screen. The only thing is,
if the Excel instance is visible, the screen will be flashing kind of
annoyingly, due to the large amount of copying and pasting going on.

Nov 12 '05 #2

P: n/a
Thanks for that great tip! I suppose I can let Excel do the progress
reporting, and just before each progress reporting stat, I could
reenable screen updating, display the stat (maybe by changing a cell
and then selecting that cell), and then disable screen updating again.
So I suppose I better not make the Excel task invisible.

"Phobos" <la******@spammers.co.uk> wrote in message news:<m8********************@brightview.com>...
Add the following to your Excel VBA code:

at the beginning:

Application.ScreenUpdating = False

And obviously at the end:

Application.ScreenUpdating = True

This will also speed up your Excel code.

P

"Mrs Howl" <ti********@yahoo.com> wrote in message
news:5b************************@posting.google.com ...
I don't know if there's even a way to do what I want. I click on a
button in an Access form, and it opens an instance of Excel, and opens
a workbook and runs a macro that's in it. So far, fine, I know how
to do this. I'm preferring to keep the Excel instance invisible, but
while the macro is running, it would be nice to see some sort of
progress indicator.

(By the way, here's basically what the Excel macro is doing: it's
opening nine workbooks, doing a lot of copying and pasting, and then
saving a workbook. I'd be satisfied if, after each of the 9 workbooks
that get opened, some sort of display shows on the screen so the user
knows that workbook is finished.)

It almost seems as if Excel would need to have a way to display info
on an Access form. Is that even possible? Or alternatively, maybe I
should not make the Excel instance invisible, and then the progress
could be displayed on some sort of Excel screen. The only thing is,
if the Excel instance is visible, the screen will be flashing kind of
annoyingly, due to the large amount of copying and pasting going on.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.