Hi Guys,
I am a VERY amateur programmer in need of some help.
I need to write a macro that enters HTML code into a cell in a worksheet in Excel. The HTML code never changes so the macro just needs to write the HTML to the Excel cell which will produce the table required. If I simply copy and paste the HTML code into the cell there are no problems but I cannot get a macro to accept the HTML code that I need to write.
Without going into major detail, the HTML code starts and finishes like this …..
<HTML><HEAD>
<META HTTP_EQUIV=”REFRESH” CONTENT=”3600”>
<TITLE>top.html</TITLE>
.
.
.
.
</CENTER>
</BODY></HTML>
I think I just need the correct format in the Macro so that it accepts the HTML that needs to be written to the cell but I’ve hit a brick wall.
If you could help I’d be so grateful
Regards
AliJay
I am a VERY amateur programmer in need of some help.
I need to write a macro that enters HTML code into a cell in a worksheet in Excel. The HTML code never changes so the macro just needs to write the HTML to the Excel cell which will produce the table required. If I simply copy and paste the HTML code into the cell there are no problems but I cannot get a macro to accept the HTML code that I need to write.
Without going into major detail, the HTML code starts and finishes like this …..
<HTML><HEAD>
<META HTTP_EQUIV=”REFRESH” CONTENT=”3600”>
<TITLE>top.html</TITLE>
.
.
.
.
</CENTER>
</BODY></HTML>
I think I just need the correct format in the Macro so that it accepts the HTML that needs to be written to the cell but I’ve hit a brick wall.
If you could help I’d be so grateful
Regards
AliJay
