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 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.