View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shp Shp is offline
external usenet poster
 
Posts: 1
Default Open Html file i Excel

Hi

I using Excel to open an Htm file, and after this I run a
Macro to do some conversion. I the Htm file there is some
numbers in rage 1-10000. If the number is 1000 it's
written 1.000 an so one.
If I those open from the file menu all number are ok.
But when I use the Macro
Workbooks.Open Filename:="MyFile.htm"
number 1000 is now 1
number 2000 is now 2

How can I get the same whit the Workbooks.Open as when I
use Open from File menu.