The first time I've posted I think and after hours of trying to figure it out
I did. Answering myself I found that I should use the

PRINT #1, data

instead of

WRITE #1, data


One of these days I really need to take a VB class. Thanks anyway.



"Vance Lee Meurer" wrote:

My Excel macro is supposed to be building a web page. As you can see from
the next several lines I am getting " " when I don't want them.

"<tr"
"<tdMicrosoft Outlook</td"
"<td11.0.6359</td"
"<td</td"
"</tr"

The code looks like this

Open ThisWorkbook.Path & "\" & Range("H28").Value & ".htm" For Output As #1
...
...
'Get office apps
For i = 77 To 82
Outline = "<tr"
Write #1, Outline
Outline = "<td" & Range("H" & i).Value & "</td"
Write #1, Outline
Outline = "<td" & Range("G" & i).Value & "</td"
Write #1, Outline
Outline = "<td" & Range("E" & i).Value & "</td"
Write #1, Outline
Outline = "</tr"
Write #1, Outline
Next

Thanks for your help in advance.