Hello,

Can anybody tell me if this coding works with Excel 2002?

Open OutputFile For Output As #1

LineInput = "<html<head<title" & HeaderData
& "</title</head<body"
HtmlWrite (LineInput)
LineInput = "<basefont size=3<table cellpadding=0
cellspacing=0 width=100%<tr<td valign=top align=left"
HtmlWrite (LineInput)
LineInput = "<a href=""../mopscrud.htm""<strongCrude
Platts</strong</a ... "
HtmlWrite (LineInput)
LineInput = "<a href=""../termcrud.htm""<strongTapis
PTP</strong</a ... "
HtmlWrite (LineInput)
LineInput = "<a href=""ptp.htm""<strongTerm
Prices</strong</a ... "
HtmlWrite (LineInput)
LineInput = "<a href=""../diff-tpc.htm""<strongTapis
Trends</strong</a"
HtmlWrite (LineInput)

LineInput = "</td</tr</table<hr"
HtmlWrite (LineInput)


Thanks,
Sheela

I put your code into a module in Excel 2002 and my VBA editor didn't
recognize anything past the first line. 'LineInput' was not found in my
Object Browser search.

Bruce Cooley



"Sheela" wrote in message
...
: Hello,
:
: Can anybody tell me if this coding works with Excel 2002?
:
: Open OutputFile For Output As #1
:
: LineInput = "<html<head<title" & HeaderData
: & "</title</head<body"
: HtmlWrite (LineInput)
: LineInput = "<basefont size=3<table cellpadding=0
: cellspacing=0 width=100%<tr<td valign=top align=left"
: HtmlWrite (LineInput)
: LineInput = "<a href=""../mopscrud.htm""<strongCrude
: Platts</strong</a ... "
: HtmlWrite (LineInput)
: LineInput = "<a href=""../termcrud.htm""<strongTapis
: PTP</strong</a ... "
: HtmlWrite (LineInput)
: LineInput = "<a href=""ptp.htm""<strongTerm
: Prices</strong</a ... "
: HtmlWrite (LineInput)
: LineInput = "<a href=""../diff-tpc.htm""<strongTapis
: Trends</strong</a"
: HtmlWrite (LineInput)
:
: LineInput = "</td</tr</table<hr"
: HtmlWrite (LineInput)
:
:
: Thanks,
: Sheela
:

She was using LineInput as the name of a variable. VBA does have a Line Input command (2 words),
so IMO LineInput isn't a good choice for a variable name -- too confusing.


On Mon, 08 Sep 2003 04:07:40 GMT, "Bruce Cooley" wrote:

I put your code into a module in Excel 2002 and my VBA editor didn't
recognize anything past the first line. 'LineInput' was not found in my
Object Browser search.

Bruce Cooley



"Sheela" wrote in message
...
: Hello,
:
: Can anybody tell me if this coding works with Excel 2002?
:
: Open OutputFile For Output As #1
:
: LineInput = "<html<head<title" & HeaderData
: & "</title</head<body"
: HtmlWrite (LineInput)
: LineInput = "<basefont size=3<table cellpadding=0
: cellspacing=0 width=100%<tr<td valign=top align=left"
: HtmlWrite (LineInput)
: LineInput = "<a href=""../mopscrud.htm""<strongCrude
: Platts</strong</a ... "
: HtmlWrite (LineInput)
: LineInput = "<a href=""../termcrud.htm""<strongTapis
: PTP</strong</a ... "
: HtmlWrite (LineInput)
: LineInput = "<a href=""ptp.htm""<strongTerm
: Prices</strong</a ... "
: HtmlWrite (LineInput)
: LineInput = "<a href=""../diff-tpc.htm""<strongTapis
: Trends</strong</a"
: HtmlWrite (LineInput)
:
: LineInput = "</td</tr</table<hr"
: HtmlWrite (LineInput)
:
:
: Thanks,
: Sheela
: