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!

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

Opening Multiple Workbooks on Userform

Status
Not open for further replies.
AmyJade

AmyJade

Programmer
Feb 26, 2004
12
CA
Hi,

I'm wondering if anyone can help me with the coding for this scenario:

I need to be able to open existing multiple Excel workbooks with a click of a command button on a userform in VBA. This click of a command button must also hide the active userform. Also, I'm only trying to extract data from one of the workbooks to copy and paste into another existing workbook.

How would I make this happen? Any thoughts?

Amy




 
Status
Not open for further replies.

Similar threads

huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
1K
huiettcm
huiettcm
remeng
  • Locked
  • Question
multiple err handling
Replies
6
Views
806
remeng
remeng
AncientTiger
  • Locked
  • Question
How to screenshot a userform and save the capture as JPG 1
Replies
7
Views
2K
AncientTiger
AncientTiger
thanhthanh12
  • Locked
  • Question
How create a button to record a macro in userform
Replies
5
Views
492
thanhthanh12
thanhthanh12
JTBorton
  • Locked
  • Question
Determine when a userform is closes without the Terminate event 1
Replies
6
Views
1K
JTBorton
JTBorton

Part and Inventory Search

Sponsor

Back
Top