Hi Barry,
Thanks for the quick reply. First, I am not a professional programmer. I am generally referred to as a self-taught hobbyist. I have a lot of exerience with VBA for Office. Mostly Excel but some with Word, Access and Outlook. I am learning the Mac.
The Mac I will be running AW 5 & 6 on is running OS X 10.6.8. AW 6 is version 6.2.7. I am awaiting AW 5 so I have no information on it at the moment.
What i will start with is a list of file names complete with path to the flash drive containing the cwk files. The list is in a AW 5 spreadsheet. I know all the cwk files are spreadsheet types. I want to go down the list opening each cwk file and then saving it in a new format. As I said, I have done this with a couple of the files manually.
There are 84 of them.
I am debating doing the whole thing manually as opposed to my initial idea of writing (or recording) a macro to do the job. It took me a week to write a simple LO Basic macro to list in a spreadsheet (ods) all files in a starting folder including all subfolders recursively and then separating the text files from the spreadsheet ones. The recorder was no help in LO Basic. It was a real chore.
If the AW 5 recorder could get me the basic code to do the open and save around which i put the looping i thought it might be doable. As someone who is familiar with all this I would value your opinion. I am retired and have lots of time but.
Best regards,
Russ