Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Count the no. of Excel sheets using VB Code

Author  Topic 

srinivas.alwala
Starting Member

30 Posts

Posted - 2008-02-29 : 01:06:45

Hi,

I would like to know how to count the no. of Excel Sheets using VB.

Regards,
Srinivas Alwala

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-02-29 : 01:10:23
Have you tried asking your question in a forum that deals with VB?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-29 : 01:13:23
Use Microsoft Excel Object Library.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-02-29 : 06:09:16
Try at www.vbcity.com

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -