Trying to develop Access-Illustrator application to help catalogue .eps files
Hi everyone.
I was looking on the web and couldn't find any application that would allow fairly easily to catalogue by hierarchy and rename a whole bunch of .eps files i.e. home-kitchen-utensils or home-kitchen-appliances, etc.
I'm fairly proficient in VBA Excel and Access so I thought that I could develop the actual database in one of those and then using VBA I could pass a parameter with the file name and directory to Illustrator then Illustrator could open the file allowing me to preview it and I would be able to work on the Access database while having a preview of the file in Illustrator. Later VBA could command Illustrator to either save the file under the new name or just close it and rename it using VBA to be consistent with the hierarchy.
Ideally what I am looking for are 3 things:
1. An existing piece of vba code that would allow Excel/Access to pass parameters and start a script in Illustrator
2. A script in Illustrator that would open a specific file based on the parameters sent from the vba code.
3. A script that would save the open file based on new set hierarchy or just simply closes the file.
.....4. Software that already allows to preview .eps files, categorize, rename them and export information to a txt or cvs file...
Thanks,
Roland