How do I export populated cells to a TXT file

Hi

Bit more detail on the structure of your sheet, what the data looks like, order the cells are to be processed, any concatenation, separation characters etc, etc.

rylo

Hi rylo,

Thanks for replying.

The purpose of my sheet is to create a txt file that is used in another script that uploads .txt files saved in another location to members in a dataset on an IBM mainfrane. (if that makes sense!)

The sheet uses columns A-E. The user only has access to type or paste an eight character jobname in column B. When they populate this column the other columns will be auto populated. The breakdown of column content is as follows. Only data in columns B & D will ever change.

A) q:\sw ops ins to tso prose\jobs\
B) J1234567
C) .txt text2~'CSDSHIFT.CA7.PROSE(
D) J1234567
E) )'

The ultimate goal is that it will be saved in a txt doc in the following format...

q:\sw ops ins to tso prose\jobs\J1234567.txt text2~'CSDSHIFT.CA7.PROSE( J1234567)'

Hope that helps, sorry if this is really easy and I'm being stupid here I dont have a lot to do with VBS.

Regards,

Tom