hello,

how can i
1. open notepad,

shell ?

2. paste excel range as value into notepad

3. save notepad as html

4. close notepad

?

or do it with create object ?

thank for suggestion.

rgs

Shell will do it.

Perhaps you have some kind of "super" Notepad, but mine has no "save as
HTML" function...



--
Tim Williams
Palo Alto, CA


"pm" wrote in message ...
hello,

how can i
1. open notepad,

shell ?

2. paste excel range as value into notepad

3. save notepad as html

4. close notepad

?

or do it with create object ?

thank for suggestion.

rgs

I'm curious why you'd want to go through all those gyrations with Notepad when
Excel allows you to save as html directly? And Notepad doesn't...

Bill
--------------------
pm wrote:
hello,

how can i
1. open notepad,

shell ?

2. paste excel range as value into notepad

3. save notepad as html

4. close notepad

?

or do it with create object ?

thank for suggestion.

rgs

Bill Martin wrote:

I'm curious why you'd want to go through all those gyrations with Notepad when
Excel allows you to save as html directly? And Notepad doesn't...

i build all code in excel..

when saving excel as html you get each sheet as different subpage in html, moreover
excel saves too much unnecessary styles and tags - i want to have control what i get
in html code..

i use such a code:

Sub notepad()
Application.ScreenUpdating = False

Dim FF As Integer
Dim plik As String
Dim tekst As String
Dim kom As Range

plik = "C:\Documents and Settings\user\Pulpit\webpage1.html"
FF = FreeFile
Open plik For Output As #FF
For Each kom In Sheets("prob").Range("A1:B16088")
tekst = kom.Text
Print #FF, tekst
Next
Close #FF

Application.ScreenUpdating = True
End Sub

You might find ideas at http://www.meadinkent.co.uk/xlhtmltable.htm
to help you do what you want directly from Excel.

--
Gordon Rainsford

London UK

pm wrote:

Bill Martin wrote:

I'm curious why you'd want to go through all those gyrations with
Notepad when Excel allows you to save as html directly? And Notepad
doesn't...

i build all code in excel..

when saving excel as html you get each sheet as different subpage in html,
moreover excel saves too much unnecessary styles and tags - i want to have
control what i get in html code..

i use such a code:

Sub notepad()
Application.ScreenUpdating = False

Dim FF As Integer
Dim plik As String
Dim tekst As String
Dim kom As Range

plik = "C:\Documents and Settings\user\Pulpit\webpage1.html"
FF = FreeFile
Open plik For Output As #FF
For Each kom In Sheets("prob").Range("A1:B16088")
tekst = kom.Text
Print #FF, tekst
Next
Close #FF

Application.ScreenUpdating = True
End Sub