Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy one spreadsheet into another without activating second spreadsheet's user form
I have a workbook that I open automatically with a user form
(frmQuery)showing. Upon opening the workbook in the initialization event, I have a second workbook open in order to copy information from one to the other and then close the second workbook. The second workbook also opens automatically with a user form (frmSurvey). The problem I have is I don't want the second workbook form (frmSurvey) to show during the copy process. I can't seem to get it to not show. I have tried the UNLOAD and the HIDE methods, neither of which works. Any suggestions? PAM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy one spreadsheet into another without activating second spreadsheet's user form
Try checking if the first file is already open, then YOU
don't do the workbook_open event like this on error resume next dim nms as string nms="" nms=workbooks("MyfirstFile.xls").name if nms="" then ' This section is for your actual code on ' the Workbook_open event end if Francisco Mariscal fcomariscal at hotmail dot com -----Original Message----- I have a workbook that I open automatically with a user form (frmQuery)showing. Upon opening the workbook in the initialization event, I have a second workbook open in order to copy information from one to the other and then close the second workbook. The second workbook also opens automatically with a user form (frmSurvey). The problem I have is I don't want the second workbook form (frmSurvey) to show during the copy process. I can't seem to get it to not show. I have tried the UNLOAD and the HIDE methods, neither of which works. Any suggestions? PAM . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy one spreadsheet into another without activating second spreadsheet's user form
Pamela,
The Application.Enableevents property migth do the trick. In your module that's opening the second workbook try this: Application.EnableEvents = False Workbooks.Open "test1.xls" Application.EnableEvents = True However, this will disable all workbook_open events, so if you have others that you do want to run this won't work. hth Doug "P Cheek" wrote in message om... I have a workbook that I open automatically with a user form (frmQuery)showing. Upon opening the workbook in the initialization event, I have a second workbook open in order to copy information from one to the other and then close the second workbook. The second workbook also opens automatically with a user form (frmSurvey). The problem I have is I don't want the second workbook form (frmSurvey) to show during the copy process. I can't seem to get it to not show. I have tried the UNLOAD and the HIDE methods, neither of which works. Any suggestions? PAM |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy one spreadsheet into another without activating second spreadsheet's user form
Are you opening the workbook with frmSurvey manually, or through code? If
it's through code, have you tried disabling events (i.e. application.enableevents = false) before you begin the process that causes frmSurvey to display? Or even by copying from the second workbook without making it active? Not being able to close it may be because of your forms' modality - whichever form is 'topmost' has the focus, and you can't close a form that's not the topmost, unless all your forms are modeless (because you can't mix modal & modeless forms) HTH. "P Cheek" wrote in message om... I have a workbook that I open automatically with a user form (frmQuery)showing. Upon opening the workbook in the initialization event, I have a second workbook open in order to copy information from one to the other and then close the second workbook. The second workbook also opens automatically with a user form (frmSurvey). The problem I have is I don't want the second workbook form (frmSurvey) to show during the copy process. I can't seem to get it to not show. I have tried the UNLOAD and the HIDE methods, neither of which works. Any suggestions? PAM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedding spreadsheet in a user form | Excel Discussion (Misc queries) | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
Put "put user form" in spreadsheet | New Users to Excel | |||
User form and hiding spreadsheet | Excel Discussion (Misc queries) | |||
Why is my Excel spreadsheet's sorting not being remembered? | Excel Discussion (Misc queries) |