By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,751 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

View Excel in VB APP

P: 3
Hi,


does anybody know which control I can use to view an Excel sheet inside my program. I just want to show the sheet as is, no editing etc


Thanks
Apr 19 '07 #1
Share this Question
Share on Google+
2 Replies


P: 9
Hi,

Include excel type library in the project references and then use the following:

Dim m_oExcelSheet As Excel.Application

Set m_oExcelSheet = New Excel.Application
m_oExcelSheet.Workbooks.Open "TestExcel.xls"

this is the simplest way to do that.

Thanks,
Asim.
Apr 19 '07 #2

SammyB
Expert 100+
P: 807
Hi,


does anybody know which control I can use to view an Excel sheet inside my program. I just want to show the sheet as is, no editing etc


Thanks
Which VB are you using, VBA, VB6 or VB.NET? Do you want to open the sheet in a control on your form or as if you just opened the workbook? asimzia gave you the the second way for VB6 or VBA.
Apr 19 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.