Set Excel active Workbook
Set Excel active Workbook
Set Excel active Workbook
Set Excel active Workbook
Set Excel active Workbook
Set Excel active Workbook Set Excel active Workbook Set Excel active Workbook Set Excel active Workbook Set Excel active Workbook Set Excel active Workbook Set Excel active Workbook Set Excel active Workbook
Set Excel active Workbook Set Excel active Workbook
Set Excel active Workbook
Go Back  Xtreme Visual Basic Talk > > > Set Excel active Workbook


Reply
 
Thread Tools Display Modes
  #1  
Old 06-04-2013, 09:21 AM
Meridian2000 Meridian2000 is offline
Contributor
 
Join Date: Jul 2003
Location: London/England
Posts: 573
Default Set Excel active Workbook


I've used the following code to get all the names of open Excel workbooks, my question is how do I set the active workbook, so that instead of using msgbox to display each workbook I can set the active workbook, go off and work on that, then get the next workbook and make that active and so on?

Code:
xlApp = GetObject(, "Excel.application")
For iTmp = 1 To xlApp.Workbooks.Count 'Each workbook In xlApp.Workbooks
     MsgBox(xlApp.Workbooks(iTmp).Name)
Next
__________________
Bumshanka - May the seed of your loins be fruitful in the belly of your woman - The Young Ones
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Set Excel active Workbook
Set Excel active Workbook
Set Excel active Workbook Set Excel active Workbook
Set Excel active Workbook
Set Excel active Workbook
Set Excel active Workbook Set Excel active Workbook Set Excel active Workbook Set Excel active Workbook Set Excel active Workbook Set Excel active Workbook Set Excel active Workbook
Set Excel active Workbook
Set Excel active Workbook
 
Set Excel active Workbook
Set Excel active Workbook
 
-->