Unwanted "quotes"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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>"
"<td>Microsoft Outlook</td>"
"<td>11.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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top