RE: [MS_AccessPros] Working with Excel tabs

 

When you add a new sheet to the workbook object, that becomes the activesheet, so you can address it so

 

xlApp.xlWB.Activesheet

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: 05 March 2015 20:44
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Working with Excel tabs

 

 

So, when I add a new sheet, Access will use that one until I add a new one?

 

Thanks,

 

 

Gary

__._,_.___

---

Posted by: "Bob Phillips" <bob.phillips@dsl.pipex.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (7)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___