collect data and place in text file.

[Stone Cold]

This was end product. Thanks to T-J and MickG. If someone could please annotate the code to explain the workings and how it all fits together, their time will be much appreciated.
Thanks in advance.

Please Login or Register  to view this content.

----------------

Hi, I needed a macro that would collect the information in e.g. cell A1 and C3 and place it into a text file.

Thanx to MickG,

Please Login or Register  to view this content.

I now see that it would also help me if a new file was created instead of using an exsiting one.

+Plz, if the new file could be named after the contents of D8, or (8, 4) as Mick puts it.

So if Cell D8 contained "inkypoo". A .txt file would be created in "C:\" called "inkypoo.txt" and contain the contents of e.g. cell A1 and C3

or.. as it finally turned out:

Please Login or Register  to view this content.

Tank you.

[mudraker]

Will the macro be using an existeng text file or creating a new file

If using an existing file where will ot be adding the data within the file & will it be replacing existing data within the file

[MickG]

XLForum_Stone Cold_Need to collect data and place in text file.
--------------------------------------
Hi, Here's a starting point.
The File "mick.txt" is a "Notpad" file save on the Desktop
Mod the code to suit:-

Please Login or Register  to view this content.

Regards Mick

[Stone Cold]

Thanks alot, can anyone help me with naming the file using the contents of cell D8?

[Stone Cold]

Bump - Read first post.

[T-J]

+Plz, if the new file could be named after the contents of D8, or (8, 4) as Mick puts it.

So if Cell D8 contained "inkypoo". A .txt file would be created in "C:\" called "inkypoo.txt" and contain the contents of e.g. cell A1 and C3

or.. as it finally turned out:

Please Login or Register  to view this content.

Tank you.

Use a subroutine that takes arguments (Range of cells to output and the Filename) to give more flexibility.

Please Login or Register  to view this content.

[Stone Cold]

THANK YOU SO!!! MUCH. You're help has really been appreciated, not forgetting MickG either. Thanks to both of u.

[Stone Cold]

This was end product. Thanks to T-J and MickG. If some could please annote the code to explain the workings and how it all fits together, their time will be much appreciated.
Thanks in advance.

Please Login or Register  to view this content.

[Stone Cold]

Bump -- Read first post.

[mudraker]

this is from your 1st post in this thread

Please Login or Register  to view this content.

[Stone Cold]

Thanks MUDRAKER, thanks alot.