ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Writing to notepad file (https://www.excelbanter.com/excel-discussion-misc-queries/109992-writing-notepad-file.html)

Jeff

Writing to notepad file
 
Hi,

I am writing a file to a notepad file, in excel.

So I have

Write #1,"Header1","Header2","Header3",

and then more writing.

When this file is viewed in notepad there are "" around the headers. Is
there any way to write the notepad file so there are not "" around the
headers?

Thanks for your help

Bernard Liengme

Writing to notepad file
 
Have you tried
Write #1,Header1,Header2,Header3,
I assume these are the names of variables.
Have you though of Save As | TXT file ?

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jeff" wrote in message
...
Hi,

I am writing a file to a notepad file, in excel.

So I have

Write #1,"Header1","Header2","Header3",

and then more writing.

When this file is viewed in notepad there are "" around the headers. Is
there any way to write the notepad file so there are not "" around the
headers?

Thanks for your help




Earl Kiosterud

Writing to notepad file
 
Jeff,

You might want to try the Text Write Program at www.smokeylake.com/excel.
It's an Excel workbook. No programming required.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Jeff" wrote in message
...
Hi,

I am writing a file to a notepad file, in excel.

So I have

Write #1,"Header1","Header2","Header3",

and then more writing.

When this file is viewed in notepad there are "" around the headers. Is
there any way to write the notepad file so there are not "" around the
headers?

Thanks for your help





All times are GMT +1. The time now is 01:59 PM.

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