Write command including unwanted quotaton marks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Write encapsulates the strings in quotes, Print doesn't:

Print #1, "WEB"

HTH. Best wishes Harald
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel to PDF or XPS boilerplate routines 3
Write text data to text file without quotes 4
using write #1 to create a batch file 2
How to write binary data to a file 3
How to write to file the contents of a generic array/collection 4
excel sheet dirty read and dirty write? 6
Cannot write the contents of an Object to file 7
display a file in excel by using vba 0

Back
Top