I have an Access app which uses Office Automation to manipulate and then
save PowerPoint files to disk. It works fine, but I need to update the code
and I am having problems with the syntax. Currently, it saves all of the
files to one main subdirectory. Now I need it to save the files to separate
directories based on the value of a new field in the database.
The new field is the name of a person assigned to an account. I have no
control over how this value is input and its format is rather inelegant,
sometimes it is just first and last name and other times it contains a
nickname. So it might be in the form of "John Doe" or it might be "William
(Bill) Doe". Anyhow, I need to strip out the last name in this field so I
can append it to the path variable.
So, my thought was to grab the value of that field, then run a for-next loop
starting with the last char and going backwards until a space is found.
Then I would use that string as the name of the directory and, if it does
not already exist, create it on-the-fly . But I am having trouble with the
syntax as it has been more than a year since I did any programming.
Does anybody know the syntax for what I am trying to accomplish?
Thanks
Alan