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

open Excel/Htm file in Excel mode

P: n/a
I have a file that is created in Excel and saved as an htm file.
(if I open the file through Excel it open as Excel file, if I click on the
file name it open in internet explorer).

I need to read this Excel/htm file but in excel mode through VB.net, in
order to have acces to specifc cells and worksheets.

how can I do that ?

thanks

Nov 22 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
pm
IF you open up the file in notepad you will see that it consists of a style
sheet and html. If you open the file and read it you should be able to get
to the HTML and then parse it out.

If you need a more detailed answer let me know.

"zino" wrote:
I have a file that is created in Excel and saved as an htm file.
(if I open the file through Excel it open as Excel file, if I click on the
file name it open in internet explorer).

I need to read this Excel/htm file but in excel mode through VB.net, in
order to have acces to specifc cells and worksheets.

how can I do that ?

thanks

Nov 22 '05 #2

P: n/a
Hello Zino,

I think the best way to do it is to use Automation to automate Excel in
VB.NET. Then open this file in the code and access to cells and worksheets
using Excel object model.

Please refer to the following artcile for how to automate Excel in VB.NET.
"HOWTO: Automate Microsoft Excel from Visual Basic .NET"
http://support.microsoft.com/?id=301982
This article demonstrates how to create an Automation client for Microsoft
Excel by using Microsoft Visual Basic .NET.

Does that answer your question?

Best regards,
Yanhong Huang
Microsoft Community Support

Get Secure! C www.microsoft.com/security
Register to Access MSDN Managed Newsgroups!
-http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.as
p&SD=msdn

This posting is provided "AS IS" with no warranties, and confers no rights.

Nov 22 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.