| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open Workbooks
I am looping through all the workbooks in a folder, opening them, performing
some task and then closing them without saving. I have turned screen updating off, but want to know if there is any way I can stop the name of the file appearing in the task bar when the file is opened? I know there are lots of arguments to the workbooks.open event but none seem to allow this. Paul Smith |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Workbooks
'/=======================================/
Sub TitleBar_FullName() 'change toolbar '...from ASAP Utilities - 08/11/2004 Application.Caption = Empty Windows(1).Caption = "Hello World" End Sub '/=======================================/ Sub TitleBar_Standard() 'change toolbar back to normal '...from ASAP Utilities - 08/11/2004 Application.Caption = Empty Windows(1).Caption = ActiveWorkbook.Name End Sub '/=======================================/ -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Paul W Smith" wrote: I am looping through all the workbooks in a folder, opening them, performing some task and then closing them without saving. I have turned screen updating off, but want to know if there is any way I can stop the name of the file appearing in the task bar when the file is opened? I know there are lots of arguments to the workbooks.open event but none seem to allow this. Paul Smith . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Workbooks
No idea what all this means.
Maybe it does what I want maybe it does not, but I have no idea how to use it. "Gary Brown" wrote in message ... '/=======================================/ Sub TitleBar_FullName() 'change toolbar '...from ASAP Utilities - 08/11/2004 Application.Caption = Empty Windows(1).Caption = "Hello World" End Sub '/=======================================/ Sub TitleBar_Standard() 'change toolbar back to normal '...from ASAP Utilities - 08/11/2004 Application.Caption = Empty Windows(1).Caption = ActiveWorkbook.Name End Sub '/=======================================/ -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Paul W Smith" wrote: I am looping through all the workbooks in a folder, opening them, performing some task and then closing them without saving. I have turned screen updating off, but want to know if there is any way I can stop the name of the file appearing in the task bar when the file is opened? I know there are lots of arguments to the workbooks.open event but none seem to allow this. Paul Smith . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Workbooks
I think you have mis-read my question!!!!!
I asked how to stop a file from appearing in the Task bar not the Title bar of the application. What I am asking about is the taskbar that appears, usually at the bottom of the screen and has the names of all the open applications. Paul Smith "Gary Brown" wrote in message ... '/=======================================/ Sub TitleBar_FullName() 'change toolbar '...from ASAP Utilities - 08/11/2004 Application.Caption = Empty Windows(1).Caption = "Hello World" End Sub '/=======================================/ Sub TitleBar_Standard() 'change toolbar back to normal '...from ASAP Utilities - 08/11/2004 Application.Caption = Empty Windows(1).Caption = ActiveWorkbook.Name End Sub '/=======================================/ -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Paul W Smith" wrote: I am looping through all the workbooks in a folder, opening them, performing some task and then closing them without saving. I have turned screen updating off, but want to know if there is any way I can stop the name of the file appearing in the task bar when the file is opened? I know there are lots of arguments to the workbooks.open event but none seem to allow this. Paul Smith . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Workbooks
You're right, I did misread your question...
To turn the StatusBar off, give it a blank value... Application.StatusBar = False To put the StatusBar back to normal Application.StatusBar = False These would go in procedures. You asked your question in the 'Programming' forum so I'm assuming you are a bit familiar with programming in VBA. ??? -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Paul W Smith" wrote: I think you have mis-read my question!!!!! I asked how to stop a file from appearing in the Task bar not the Title bar of the application. What I am asking about is the taskbar that appears, usually at the bottom of the screen and has the names of all the open applications. Paul Smith "Gary Brown" wrote in message ... '/=======================================/ Sub TitleBar_FullName() 'change toolbar '...from ASAP Utilities - 08/11/2004 Application.Caption = Empty Windows(1).Caption = "Hello World" End Sub '/=======================================/ Sub TitleBar_Standard() 'change toolbar back to normal '...from ASAP Utilities - 08/11/2004 Application.Caption = Empty Windows(1).Caption = ActiveWorkbook.Name End Sub '/=======================================/ -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Paul W Smith" wrote: I am looping through all the workbooks in a folder, opening them, performing some task and then closing them without saving. I have turned screen updating off, but want to know if there is any way I can stop the name of the file appearing in the task bar when the file is opened? I know there are lots of arguments to the workbooks.open event but none seem to allow this. Paul Smith . . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Workbooks
Let's try that again :O
To turn the StatusBar off, give it a blank value... Application.StatusBar = "" To put the StatusBar back to normal Application.StatusBar = False -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Gary Brown" wrote: You're right, I did misread your question... To turn the StatusBar off, give it a blank value... Application.StatusBar = False To put the StatusBar back to normal Application.StatusBar = False These would go in procedures. You asked your question in the 'Programming' forum so I'm assuming you are a bit familiar with programming in VBA. ??? -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Paul W Smith" wrote: I think you have mis-read my question!!!!! I asked how to stop a file from appearing in the Task bar not the Title bar of the application. What I am asking about is the taskbar that appears, usually at the bottom of the screen and has the names of all the open applications. Paul Smith "Gary Brown" wrote in message ... '/=======================================/ Sub TitleBar_FullName() 'change toolbar '...from ASAP Utilities - 08/11/2004 Application.Caption = Empty Windows(1).Caption = "Hello World" End Sub '/=======================================/ Sub TitleBar_Standard() 'change toolbar back to normal '...from ASAP Utilities - 08/11/2004 Application.Caption = Empty Windows(1).Caption = ActiveWorkbook.Name End Sub '/=======================================/ -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Paul W Smith" wrote: I am looping through all the workbooks in a folder, opening them, performing some task and then closing them without saving. I have turned screen updating off, but want to know if there is any way I can stop the name of the file appearing in the task bar when the file is opened? I know there are lots of arguments to the workbooks.open event but none seem to allow this. Paul Smith . . |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Workbooks
You are still misreading.
Status Bar is not the TaskBar. I think the only way is to AutoHide the Taskbar Gord Dibben MS Excel MVP On Tue, 16 Mar 2010 11:21:01 -0700, Gary Brown wrote: You're right, I did misread your question... To turn the StatusBar off, give it a blank value... Application.StatusBar = False To put the StatusBar back to normal Application.StatusBar = False These would go in procedures. You asked your question in the 'Programming' forum so I'm assuming you are a bit familiar with programming in VBA. ??? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Open Workbooks
Thanks Gord,
I had the feeling it was not something that could be achieved in VBA. Paul Smith "Gord Dibben" <gorddibbATshawDOTca wrote in message ... You are still misreading. Status Bar is not the TaskBar. I think the only way is to AutoHide the Taskbar Gord Dibben MS Excel MVP On Tue, 16 Mar 2010 11:21:01 -0700, Gary Brown wrote: You're right, I did misread your question... To turn the StatusBar off, give it a blank value... Application.StatusBar = False To put the StatusBar back to normal Application.StatusBar = False These would go in procedures. You asked your question in the 'Programming' forum so I'm assuming you are a bit familiar with programming in VBA. ??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel2007; workbooks.count is not counting all open workbooks | Excel Programming | |||
| When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
| workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
| Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
| Workbooks.Open / .Open Text - How do you stop the .xls addition? | Excel Programming | |||
Linear Mode
