Unwanted "quotes"
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. |
All times are GMT +1. The time now is 04:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com