append excel data to text file

Hot Topic

Creating Logon in MS Access
copy file into clipboard
worksheet_change and data validation
User form issue
Contact in Canada
Microsoft Platform Test for ISV Solutions
ADO Recordsets
What is the difference between Excel Dates and VBA Dates ?
Business Scorecard Manager to Sharepoint deployment
Adding a command button to the toolbar or menu bar in Excel?

Microsoft ISV

Edit Record Error
Error in IE 7
Question: How do I hide the Title Bar?
Creating a new number style using macro for MS Word
Can't open regedit
Edit Record Error
Applying InsertBreak to a style?
Scorecard & Sharepoint
Validation with List drop down?
Select/cut/insert

append excel data to text file

I am going to have multiple excel files feeding one text file (each file will only append one line of data). Any suggestions

Thanks



Answer this question

append excel data to text file

  • Webstar

    The data in your XL file can be in a cell, or an autoshape, or a chart etc.

    Because you did not specify where that data lives, I assume you have it in cells. To get the text from a cell using VBA you write something like this:

    ActiveWorkbook.Sheets(idxSheet).Cells(idxRow,idxColumn).Text

    ,where

    idxSheet - index of the sheet you have the data on

    idxRow - index of the Row

    idxColumn - index of the Column

    Another option is not to use VBA at all: if indeed the data you have is only on Excel cells, you can add the excel document as an ODBC provider and connect to it as to a regular database, and see the Excell sheet as a database table.



  • Hassan Ayoub

    thanks but i found a way to append to my text file by using text boxes. Now i need to know how to import data into specific cells using a macro.

    thanks for your help..


  • append excel data to text file
Answer this question