Copy one spreadsheet into another without activating second spreadsheet's user form

  • Thread starter Thread starter P Cheek
  • Start date Start date
P

P Cheek

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
 
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
 
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
 
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.
 
Back
Top