| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Progress bar during workbook save
Hi there... I have hidden Excel(application.visible=False) and running
strickly from Userforms... on my userform is a Save commandbutton. I would like to show a progressbar during the save procedure. This is the code that runs when I click the Save Button. "Application.ThisWorkBook.Save". Is it possible to make the progressbar work at the same progress as the workbook save duration? Thanks Craig |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Progress bar during workbook save
Hello Craig, Since you don't control the save process, it is impossible to kno which block of n blocks total has been saved. You might want to displa a animation instead. This at least let's the user know the computer i processing and not hung up (not entirely true I know). Just suggestion. Sincerely, Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=49625 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Progress bar during workbook save
The size of the file is allways about the same... is it possible to use a
progressbar that takes 20 seconds to run while the workbook is saving? This would be fairly close to the time needed. "Leith Ross" wrote in message ... Hello Craig, Since you don't control the save process, it is impossible to know which block of n blocks total has been saved. You might want to display a animation instead. This at least let's the user know the computer is processing and not hung up (not entirely true I know). Just a suggestion. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=496253 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Progress bar during workbook save
You don't seem to understand that a progress bar does not run. You have to
have code within your code that progresses the bar. (A progress bar is no more sophisticated than a text box.) You can't do that for a single command. -- Regards, Tom Ogilvy "Craig" wrote in message news:AWisf.209236$Gd6.33533@pd7tw3no... The size of the file is allways about the same... is it possible to use a progressbar that takes 20 seconds to run while the workbook is saving? This would be fairly close to the time needed. "Leith Ross" wrote in message ... Hello Craig, Since you don't control the save process, it is impossible to know which block of n blocks total has been saved. You might want to display a animation instead. This at least let's the user know the computer is processing and not hung up (not entirely true I know). Just a suggestion. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=496253 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Progress bar during workbook save
Just to add, whether you knew how many "blocks" have been saved or not, Save
is a single command and you would not be able to get control back to update your progress bar (until the command is completed). At that point, the need has passed. -- Regards, Tom Ogilvy "Leith Ross" wrote in message ... Hello Craig, Since you don't control the save process, it is impossible to know which block of n blocks total has been saved. You might want to display a animation instead. This at least let's the user know the computer is processing and not hung up (not entirely true I know). Just a suggestion. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=496253 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Progress bar during workbook save
OK... I understand now... instead could I display a messagebox / Userform
with the message "Saving File...Please Wait!" which would show before the file save and dissapear after the file save? Craig "Tom Ogilvy" wrote in message ... Just to add, whether you knew how many "blocks" have been saved or not, Save is a single command and you would not be able to get control back to update your progress bar (until the command is completed). At that point, the need has passed. -- Regards, Tom Ogilvy "Leith Ross" wrote in message ... Hello Craig, Since you don't control the save process, it is impossible to know which block of n blocks total has been saved. You might want to display a animation instead. This at least let's the user know the computer is processing and not hung up (not entirely true I know). Just a suggestion. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=496253 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Progress bar during workbook save
If using xl2000 or later
Sub AABB() UserForm1.Show vbModeless DoEvents ActiveWorkbook.Save Unload UserForm1 End Sub -- Regards, Tom Ogilvy "Craig" wrote in message news:vhjsf.89962$2k.86206@pd7tw1no... OK... I understand now... instead could I display a messagebox / Userform with the message "Saving File...Please Wait!" which would show before the file save and dissapear after the file save? Craig "Tom Ogilvy" wrote in message ... Just to add, whether you knew how many "blocks" have been saved or not, Save is a single command and you would not be able to get control back to update your progress bar (until the command is completed). At that point, the need has passed. -- Regards, Tom Ogilvy "Leith Ross" wrote in message ... Hello Craig, Since you don't control the save process, it is impossible to know which block of n blocks total has been saved. You might want to display a animation instead. This at least let's the user know the computer is processing and not hung up (not entirely true I know). Just a suggestion. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=496253 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared workbook - to save or not to save | Excel Discussion (Misc queries) | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| How do I save a workbook as a new workbook by using macros? | Excel Discussion (Misc queries) | |||
| Help on Workbook close and workbook save events | Excel Programming | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
![Craig[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
