ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating a text file and printing excel spreadsheet data onto it (https://www.excelbanter.com/excel-programming/348745-creating-text-file-printing-excel-spreadsheet-data-onto.html)

Brett Smith[_2_]

Creating a text file and printing excel spreadsheet data onto it
 
I am in need of a little VBA help. I was successfully able to print#
function my header information onto the text file using VBA code onto a text
file document, but now I need to send data from my excel spreadsheet onto
this text file. This is not a comma delimited text file I would be creating,
I would need something like this.

Section1: a column variable
Section2: b column variable
Section3: (If c is empty then print a string else concatanate and print
columns c and d)

if anybody can help me on this that would be great.



Tom Ogilvy

Creating a text file and printing excel spreadsheet data onto it
 
Should use the same method.

--
Regards,
Tom Ogilvy

"Brett Smith" wrote in message
...
I am in need of a little VBA help. I was successfully able to print#
function my header information onto the text file using VBA code onto a

text
file document, but now I need to send data from my excel spreadsheet onto
this text file. This is not a comma delimited text file I would be

creating,
I would need something like this.

Section1: a column variable
Section2: b column variable
Section3: (If c is empty then print a string else concatanate and print
columns c and d)

if anybody can help me on this that would be great.






All times are GMT +1. The time now is 12:29 PM.

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