I wanted to know how to create text files that get populated from specific ranges of cells from excel
An example that I am looking for is to create a header and a line tab delimited text file. The header file would only have one row of data. The line text file could have one row of data or it could have 100 rows. I want to be able to export the data from the spreadsheet and have it create two different text files. One for the header reacord and one for the line record.
If someone can point me in the right direction on how to do this in excel using vba
Thank you
Creating tab delimited text files form excel using vba
abtcabe
This forum is mainly for issues that pertain to the Visual Studio 2005 Tools for Office per se, which is uses managed code.
You might get a better answer in the appropiate forum / newsgroup. These links might point you in the right direction:
Excel.programming newsgroup
http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.excel.programming&lang=en&cr=US
Office.developer.vba newsgroup
http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.vba&lang=en&cr=US
Visual Basic for Applications (VBA) forum http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=74&SiteID=1