Excel + FTP - Looking for some approach guidance

1medic · Post by **1medic** » Sat Apr 22, 2006 11:42 am

Hello

I'm brand new here, was trying a competing product then came across this website and was surprised by the many compelling testimonials. So I'm currently using the free trial.

I have a question about how I could approach my first macro. I've looked through the help file and my mind's a bit blank. I don't clearly see how I could automate the actions I want.

I'd like to:
- Log into multiple websites (via information I've saved in an Excel spreadsheet).
- Upload a bunch of files from a directory
- CHMOD or change permissions for certain files and directories.
- Repeat on next site.

I'm not sure how I would go into each cell of an Excel file read, and save the information.

I'm not sure which FTP tool/program I could pass this information. The help file mentions FTP but doesn't mention CHMOD as one of the supported functions.

Thanks.

Luke

1medic · Post by **1medic** » Sat Apr 22, 2006 4:51 pm

I've looked around a bit more. I see that I should have posted this to the very helpful Beginners section.

Marcus made a post here http://www.mjtnet.com/forum/viewtopic.php?t=2618 that led me to an Excel example that does much of what I need on the Excel side. He also explained about the general approach to using this product - that in reality macros need to be written manually - which is fine - now that I understand.

I'm still unsure about the general approach for automating the CHMOD part of FTPing. Normally I do this by clicking on the files in a window in FlashFXP. Could an automation script read the name of an object in an app window?

Luke