View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephen Bliss Stephen Bliss is offline
external usenet poster
 
Posts: 1
Default Write command including unwanted quotaton marks

I am trying to construct a .IDY file for subsequent web data extraction:

Open Filename for output as #1
write #1, "WEB"
write #1, "1"
write #1, cText
etc
close #1

The probem is that "WEB" is being written to the file exactly that way,
quotes included, not simply WEB. The same is true of cText variable and
every other line.

How do I get this stripped out so Excel will process the IDY file? It now
rejects it as invalid.

Thanks in advance . . .