Writing results to a text file

**cameronyoung** · 06-12-2009, 10:58 PM

Hello,

I'm trying to do something very simple, but I haven't had any luck searching for a function in excel that will let me do it.

Column A is a list of directories on a server, i.e. 01april, 02april, etc.
Column B is the path to those main directories, i.e. /raid0/data/documents/april/
Column C is where users can can type "1" if they want the directory or leave it blank if they do not want it selected.
Column D, if the corresponding row in column C=1, will show the complete source path/filename based on Column A and Column B.
Column E, if the corresponding row in column C=1, will show the complete destination path/filename based on Column A and Column B.

This is all working fine.

What I want to be able to do now though, is somehow, when someone sends the document back to me, create an FTP queue. I can do this with BulletProof FTP, because it allows really simple text queues.

So, what I need excel to do is, when someone has finished selecting their files, is write the results to a text file like exactly like this (without the Line1:, etc.):

Line1: <text from D2>
Line2: 0
Line3: 0
Line4: 0
Line5: ?
Line6: <text from E2>
(then repeated for each row in the excel document until column A is returning blank)

Seems simple enough.. Any ideas?

Also, an extra question--> is there any way I can make Excel list a directory structure automatically? Could it display the file size for the entire directory? I don't necessarily want it to list every file, just the directory paths and size of each directory.

Thank you!

**teshiburu1988** · 06-13-2009, 01:15 AM

Cameronyoung,

I have a solution for both of your issues, however it would make things easier if you could state which version of excel you are using?

Teshi

**cameronyoung** · 06-13-2009, 01:21 AM

Sorry about that, I'm using Office 2007. Though I do have a copy of Office 2003 if your solution is for that version. Thank you!

**teshiburu1988** · 06-13-2009, 04:09 AM

My Solution is for every version, the only issues is that '07 cannot support one of the functions, i will put my solution up today for you

Teshi...

**cameronyoung** · 06-13-2009, 07:12 PM

Great, I'm really looking forward to a solution.

Would be great if you could solve my directory listing / directory size problem too; would basically make the whole thing fully automatic.