Upon Opening Doc1/Open Doc2 without showing.
Hi,
I have a little code issue that is likely quite easy for someone experienced
in VBA. I have written this code:
Private Sub Workbook_Open()
Workbooks.Open ("document link here")
'Application.ActiveWorkbook.Visible=False This is the bad line!
Application.ActiveWorkbook.Close
End Sub
Basically, upon opening one workbook, I open another, as well and this is
working fine. However, I do not want the second workbook to show at all
during this process (note the commented out code). This commented code
doesn't work but is likely close. Any ideas on the correct syntax for this
line? I have tried a few different ways to no avail.
Your help is appreciated,
--
Michael J. Nowak
Texas City, TX
|