Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Invisible Can You Make Your Code???
This is my mission: users will run my two macros on a daily basis (BDs only) as a W XP Pro Scheduled Task. The macros are digitally signed and the certificate will be 'accepted' by the users. My preference is for there to be zero windows displayed on the users' monitors when the macro is triggered by the Scheduled Task. One macro sends out an e-mail (selects one of five depending upon results of a calculated cell) and saves three worksheet files to a specified location; the other macro prints a specified range on each of three worksheets. I am using 'Application.Visible = False' at the beginning of each macro and 'Application.Visible = True' immediately preceding each of the 'Application.Quit's. In each of the macro files, the 'IsAddin' Property of 'ThisWorkbook' is set to 'True' (apparently, whether the files are saved with .xlA or .xlS is irrelevant). The above is accomplishing most of my wishes. When each macro is triggered, the grey screen appears for 2 seconds <-- this is due to 'Handshaking' the digital certificate, then it disappears, the macro continues to run for about 30 seconds (as files are opened and closed, there are zero application buttons opening and closing on the W XP Pro Taskbar), then one of two things happens depending if it is Macro 1 or Macro 2: the e-mail draft appears briefly before it is 'Sent'; or three pop-ups appear in rapid succession indicating that each of the three worksheet print jobs has been sent to the printer -- lastly, immediately before each instance of Excel is shut down, a conventional Excel blank worksheet window (with cell divisions) appears for about one second <-- this is due to the 'Application.Quit'. (Upon inserting a 'MsgBox' before the 'Application.Quit', I see that the grey screen window is displayed -- this is the result of the 'Application.Visible = True'. When running at full-speed, this second grey screen is 'invisible'.) Any ideas on eliminating the 2-second grey screen and the 1-second conventional Excel blank worksheet screen? Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=389166 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Invisible Can You Make Your Code???
I am using ... 'Application.Visible = True' immediately preceding each of
the 'Application.Quit's. Why? Keep it invisible. -- Jim "Chuckles123" wrote in message ... | | This is my mission: users will run my two macros on a daily basis (BDs | only) as a W XP Pro Scheduled Task. The macros are digitally signed | and the certificate will be 'accepted' by the users. My preference is | for there to be zero windows displayed on the users' monitors when the | macro is triggered by the Scheduled Task. One macro sends out an | e-mail (selects one of five depending upon results of a calculated | cell) and saves three worksheet files to a specified location; the | other macro prints a specified range on each of three worksheets. | | I am using 'Application.Visible = False' at the beginning of each macro | and 'Application.Visible = True' immediately preceding each of the | 'Application.Quit's. In each of the macro files, the 'IsAddin' | Property of 'ThisWorkbook' is set to 'True' (apparently, whether the | files are saved with .xlA or .xlS is irrelevant). | | The above is accomplishing most of my wishes. When each macro is | triggered, the grey screen appears for 2 seconds <-- this is due to | 'Handshaking' the digital certificate, then it disappears, the | macro continues to run for about 30 seconds (as files are opened and | closed, there are zero application buttons opening and closing on the W | XP Pro Taskbar), then one of two things happens depending if it is Macro | 1 or Macro 2: the e-mail draft appears briefly before it is 'Sent'; or | three pop-ups appear in rapid succession indicating that each of the | three worksheet print jobs has been sent to the printer -- lastly, | immediately before each instance of Excel is shut down, a conventional | Excel blank worksheet window (with cell divisions) appears for about | one second <-- this is due to the 'Application.Quit'. (Upon inserting | a 'MsgBox' before the 'Application.Quit', I see that the grey screen | window is displayed -- this is the result of the 'Application.Visible = | True'. When running at full-speed, this second grey screen is | 'invisible'.) | | Any ideas on eliminating the 2-second grey screen and the 1-second | conventional Excel blank worksheet screen? | | Chuckles123 | | | -- | Chuckles123 | ------------------------------------------------------------------------ | Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 | View this thread: http://www.excelforum.com/showthread...hreadid=389166 | |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Invisible Can You Make Your Code???
Jim, Your post does eliminate the 1-second conventional Excel blank worksheet screen. However, I remember reading several posts on this site indicating bad things happen (like not being able to make Excel visible again) if macros did not contain matched pairs of App.Visible=F/T. Any comments? Also, as I implied in my first sentence, I made your suggested deletion. When stepping through my code (using F8), it works perfectly. However, at full speed, it is doing some strange things like sending out e-mails based on both results of an If statement. I will continue to research. Chuckles123 Any hopes of eliminating the 2-second 'Handshaking' screen? -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=389166 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Invisible Can You Make Your Code???
Any comments?
I have been doing an application.visible = False as part of my Excel apps for years when users quit my apps. The reason is to seem to shutdown in a snap rather than side there for 3 or 4 seconds running the closing routine. Of course Excel takes the same amount of time to truly shutdown visible or hidden (I assume). No bad side effects in 10 years so I swear by it. There always could be some action you take in a closing macro that requires Excel to be visible for some reason, but I haven't hit one. Blocking the printing message box is a tough one. I don't know of a way to do that. -- Jim "Chuckles123" wrote in message ... | | Jim, | | Your post does eliminate the 1-second conventional Excel blank | worksheet screen. | However, I remember reading several posts on this site indicating bad | things happen (like not being able to make Excel visible again) if | macros did not contain matched pairs of App.Visible=F/T. Any | comments? | | Also, as I implied in my first sentence, I made your suggested | deletion. When stepping through my code (using F8), it works | perfectly. However, at full speed, it is doing some strange things | like sending out e-mails based on both results of an If statement. I | will continue to research. | | Chuckles123 | | Any hopes of eliminating the 2-second 'Handshaking' screen? | | | -- | Chuckles123 | ------------------------------------------------------------------------ | Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 | View this thread: http://www.excelforum.com/showthread...hreadid=389166 | |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Invisible Can You Make Your Code???
Still researching the prob with the macro ignoring an 'App.Quit'; ther may be some type of prob with the code returning from a 'Call' stmt. You misunderstood one of my queries. I am not trying to eliminate th pop-ups reports sent to printer. If possible, I am trying t eliminate the pop-ups 'Handshaking' (this is a combination of: using Windows' Scheduled Tasks to trigger the macro; naming the macr 'Auto_Open'; and having the users previously accept the digita signature of the macro). This is the 2-second pop-up at the ver beginning. Chuckles12 -- Chuckles12 ----------------------------------------------------------------------- Chuckles123's Profile: http://www.excelforum.com/member.php...fo&userid=1494 View this thread: http://www.excelforum.com/showthread.php?threadid=38916 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How Invisible Can You Make Your Code???
Jim, I discovered that I need an 'End' after each 'Application.Quit'; so, I deleted all of the 'Application.Visible=True' stmts and there are no pop-ups at the end of macro processing. Still interested in your comments on the 2-second 'Handshaking' pop-up. Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=389166 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make counter invisible | Excel Programming | |||
thanks TOM. How to run macros and make the workbooks invisible | Excel Programming | |||
How to make the Toolbar Invisible through VBA | Excel Programming | |||
Code to make graph invisible / invisisble | Excel Programming | |||
Make one column Invisible. | Excel Programming |