Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file saved in HTML format
Hello,
I have saved an excel chart in a html format. How to write a statement to open that chart. Lets say I want to open the file called "MOPSDIFF.HTM". Thanks, Sheela |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file saved in HTML format
Hi Sheela,
Here are a couple of suggestions: To open it in your browser using Excel VBA: Sub OpenHtml() Dim Open1 As Variant Open1 = Shell("explorer.exe C:\path\MOPSDIFF.HTM", 1) End Sub If you saved it on a Web site use 'http://...../ MOPSDIFF.HTM' instead of 'C:\path\MOPSDIFF.HTM' To open in Excel you need to find and Insert the Gif-file that the Chart is saved as or in VBA: Sub Pic() ActiveSheet.Pictures.Insert _ ("C:\path\MOPSDIFF1.gif").Select End Sub I hope this will help you Ron -----Original Message----- Hello, I have saved an excel chart in a html format. How to write a statement to open that chart. Lets say I want to open the file called "MOPSDIFF.HTM". Thanks, Sheela . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file saved in HTML format
Hi,
I have so many html files to open. Actually, this file was created in a 16-bit environment and this charts were converted to GIF and then it is opened in Internet explorer. I want it to work in a 32-bit environment. I want to open the chart directly in the html format. Another question relating to this, is it possible for this chart(html format) to be updated if any changes made in the excel spreadsheet? Thanks, Sheela -----Original Message----- Hi Sheela, Here are a couple of suggestions: To open it in your browser using Excel VBA: Sub OpenHtml() Dim Open1 As Variant Open1 = Shell("explorer.exe C:\path\MOPSDIFF.HTM", 1) End Sub If you saved it on a Web site use 'http://...../ MOPSDIFF.HTM' instead of 'C:\path\MOPSDIFF.HTM' To open in Excel you need to find and Insert the Gif- file that the Chart is saved as or in VBA: Sub Pic() ActiveSheet.Pictures.Insert _ ("C:\path\MOPSDIFF1.gif").Select End Sub I hope this will help you Ron -----Original Message----- Hello, I have saved an excel chart in a html format. How to write a statement to open that chart. Lets say I want to open the file called "MOPSDIFF.HTM". Thanks, Sheela . . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file saved in HTML format
If the chart is in a GIF format, it no longer has any relation to Excel or
data stored in a worksheet. It is a picture of a chart created in Excel - it is no longer a chart and thus can not be changed to reflect new data values. If you want to open the file in Excel, then you just do workbooks.Open filename:="C:\Data\MOPSDIFF.HTM" I can't guarantee this will bring in any gifs in the htm, but I believe it will. You can easily test it an see by doing File = Open and typing in the location and name of the file - if it is on the internet, then just type in the URL. -- Regards, Tom Ogilvy "Sheela" wrote in message ... Hi, I have so many html files to open. Actually, this file was created in a 16-bit environment and this charts were converted to GIF and then it is opened in Internet explorer. I want it to work in a 32-bit environment. I want to open the chart directly in the html format. Another question relating to this, is it possible for this chart(html format) to be updated if any changes made in the excel spreadsheet? Thanks, Sheela -----Original Message----- Hi Sheela, Here are a couple of suggestions: To open it in your browser using Excel VBA: Sub OpenHtml() Dim Open1 As Variant Open1 = Shell("explorer.exe C:\path\MOPSDIFF.HTM", 1) End Sub If you saved it on a Web site use 'http://...../ MOPSDIFF.HTM' instead of 'C:\path\MOPSDIFF.HTM' To open in Excel you need to find and Insert the Gif- file that the Chart is saved as or in VBA: Sub Pic() ActiveSheet.Pictures.Insert _ ("C:\path\MOPSDIFF1.gif").Select End Sub I hope this will help you Ron -----Original Message----- Hello, I have saved an excel chart in a html format. How to write a statement to open that chart. Lets say I want to open the file called "MOPSDIFF.HTM". Thanks, Sheela . . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open file saved in HTML format
Workbooks has an open method, workbook doesn't.
-- Regards, Tom Ogilvy Sheela wrote in message ... Hi, I still cannot open the file. Workbooks.Open Filename:="N:\Shell Project (Oil Pricing) \HTML\MOPSPROD.HTM" What is the difference between "Workbooks" & "Workbook" class in excel. I'm using Excel 2002. Thanks, Sheela -----Original Message----- If the chart is in a GIF format, it no longer has any relation to Excel or data stored in a worksheet. It is a picture of a chart created in Excel - it is no longer a chart and thus can not be changed to reflect new data values. If you want to open the file in Excel, then you just do workbooks.Open filename:="C:\Data\MOPSDIFF.HTM" I can't guarantee this will bring in any gifs in the htm, but I believe it will. You can easily test it an see by doing File = Open and typing in the location and name of the file - if it is on the internet, then just type in the URL. -- Regards, Tom Ogilvy "Sheela" wrote in message ... Hi, I have so many html files to open. Actually, this file was created in a 16-bit environment and this charts were converted to GIF and then it is opened in Internet explorer. I want it to work in a 32-bit environment. I want to open the chart directly in the html format. Another question relating to this, is it possible for this chart(html format) to be updated if any changes made in the excel spreadsheet? Thanks, Sheela -----Original Message----- Hi Sheela, Here are a couple of suggestions: To open it in your browser using Excel VBA: Sub OpenHtml() Dim Open1 As Variant Open1 = Shell("explorer.exe C:\path\MOPSDIFF.HTM", 1) End Sub If you saved it on a Web site use 'http://...../ MOPSDIFF.HTM' instead of 'C:\path\MOPSDIFF.HTM' To open in Excel you need to find and Insert the Gif- file that the Chart is saved as or in VBA: Sub Pic() ActiveSheet.Pictures.Insert _ ("C:\path\MOPSDIFF1.gif").Select End Sub I hope this will help you Ron -----Original Message----- Hello, I have saved an excel chart in a html format. How to write a statement to open that chart. Lets say I want to open the file called "MOPSDIFF.HTM". Thanks, Sheela . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number Format on Excel File saved from .html file | Excel Discussion (Misc queries) | |||
Excel file not opening when saved with Extention .html | Excel Worksheet Functions | |||
Excel saved as .xls but data/text converted to html format/languag | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Picture disappears when saved as html file | Excel Discussion (Misc queries) |