Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Saving in the html format using excel macros

Posted on 1998-10-08
2
Medium Priority
?
218 Views
Last Modified: 2010-04-30
Here is the problem.
I have a excel spreadsheet with data. I want to save this file into html format using macros. Does anybody know the macro to save the file into the html format.
thanks
0
Comment
Question by:sgarg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 3

Accepted Solution

by:
vmano earned 40 total points
ID: 1438866
To make your Microsoft Excel data available to users on your intranet or the World Wide Web, use the Internet Assistant add-in program to convert worksheet data or charts to HTML Web pages (Save As HTML command, File menu). Microsoft Excel doesn’t support using Visual Basic to save data as HTML documents.

vmano
0
 
LVL 3

Expert Comment

by:vmano
ID: 1438867
FYI: the vice versa of your question can be done.

To open HTML documents in Microsoft Excel with Visual Basic, use the Open method. You don’t need to specify the file converter to use, because the Open method tries each available file converter until it succeeds. The following example opens an HTML document on a local drive.
 
Workbooks.Open "C:\My Documents\Product List.htm"
 
Similarly, you can specify a URL to open a file located on an HTTP server, as follows.  
Workbooks.Open "http://myserver.com/default.htm"
 
You can also get data from an intranet site or from HTTP, FTP, or Gopher sites on the World Wide Web by running a Web query. To run a Web query, point to Get External Data on the Data menu, and then click Run Web Query.

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question