Hi,
I'm new to VBA, but I have adapted some code that I found here to help
with my project. I'm using Access 2000. On winXP.
I'm being given an Access Database (one Table) that needs every row
exported as a static HTML file with the name generated based on the ID
field. I've got that part figured out. These html files need to be
placed into folders that are named, also, withe the ID field. Which
brings me to my two questions:
(1) How can I export those files, which are named by their ID field,
to a corresponding folder that already exists with that folder having
the same name as the ID field.( hope that made sense?!?)
(2) If it would be easier, can I create a folder on the fly,
corresponding to the ID field name, and then export the html into
those folders being created.
Thanks for any help.. this NG has helped me out a bunch.
Steve
I'm new to VBA, but I have adapted some code that I found here to help
with my project. I'm using Access 2000. On winXP.
I'm being given an Access Database (one Table) that needs every row
exported as a static HTML file with the name generated based on the ID
field. I've got that part figured out. These html files need to be
placed into folders that are named, also, withe the ID field. Which
brings me to my two questions:
(1) How can I export those files, which are named by their ID field,
to a corresponding folder that already exists with that folder having
the same name as the ID field.( hope that made sense?!?)
(2) If it would be easier, can I create a folder on the fly,
corresponding to the ID field name, and then export the html into
those folders being created.
Thanks for any help.. this NG has helped me out a bunch.
Steve
Comment