macro to copy cells to text files

**docaia** · 02-04-2008, 10:46 AM

I am a beginner in Macro writing, I can only record a macro or do some basic VB commands, so I have a very basic question.
I need a macro to copy a cell or a range of cells to text file, i.e when the macro runs, it copies your specified cells with their correct order to a normal text file

**Paul** · 02-05-2008, 12:07 AM

Hi docaia,

What are your 'specified cells' and what order would you want them written to the file?

An example of writing cells to a file is shown below:

Please Login or Register  to view this content.

**docaia** · 02-06-2008, 04:24 AM

thanks for your reply,
suppose I want to copy the range you specified but at column number 13 of the output text file in the example, how can this be done?

**docaia** · 02-07-2008, 07:04 AM

I used your code and it works fine,

Please Login or Register  to view this content.

the question now is how can I paste these cells to a specified column in the text file, like copying the cells in the range A1 to A20 to column # 1 in the text file, and copying the values in the range C1 to C20 to column # 13 for example

any help with that will be much appreciated, it will save me a lot of time

thanks

**docaia** · 02-27-2008, 03:26 PM

I tried the following code to copy cells to text file so that the macro searches for the cells till the last cell that has data and exports them to text file, this is the code I used:

Please Login or Register  to view this content.

the code works fine till a specific number of rows, I think till 10 rows, if more rows are introduced it begins exporting only the first 3 or 4 rows and ignores the rest, in a reverse way, i.e if I intoduce 11 rows, 9 rows are exported to text, if 12 rows are written then 8 rows are exported to text and so on.
can some one tell me please what is wrong with this code?