Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Blindly Open External Workbook/Worksheet

Status
Not open for further replies.

hunterjj1

IS-IT--Management
Jun 27, 2005
1
US
I have a macro that opens, updates, and closes multiple external workbooks. My problem is that my screen keeps showing me the external workbooks that I'm opening and closing. Is there a way to open the external workbook without it appearing?
 
Code:
Application.ScreenUpdating = false
'your code
Application.ScreenUpdating = true


Skip,

[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top