ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Write command including unwanted quotaton marks (https://www.excelbanter.com/excel-programming/306060-write-command-including-unwanted-quotaton-marks.html)

Stephen Bliss

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

Harald Staff

Write command including unwanted quotaton marks
 
Hi

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

Print #1, "WEB"

HTH. Best wishes Harald

"Stephen Bliss" <Stephen skrev i melding
...
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 . . .





All times are GMT +1. The time now is 05:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com