Exporting html to folders

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Steve Gerety

    #1

    Exporting html to folders

    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
  • Steve Gerety

    #2
    Re: Exporting html to folders

    steve@geretygra phics.com (Steve Gerety) wrote in message news:<cfe4fe01. 0405120834.7ba4 2f98@posting.go ogle.com>...[color=blue]
    > 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[/color]

    Well,

    Can anybody at least tell me to f**k off and do my own homework or is
    this such a basic question that does not bear repeating. If the post
    following mine in in response to my, possibly, banal question, well
    sorry. I did find code here that I'm uusing but I do understand what
    it's doing. I'm not a newbie to programming, but possibly just stuck
    on a concept I'm not getting my head around at this time.

    Again, thank you for your time.
    Steve

    Comment

    • Steve Gerety

      #3
      Re: Exporting html to folders

      steve@geretygra phics.com (Steve Gerety) wrote in message news:<cfe4fe01. 0405130547.71a4 c0d2@posting.go ogle.com>...[color=blue]
      > steve@geretygra phics.com (Steve Gerety) wrote in message news:<cfe4fe01. 0405120834.7ba4 2f98@posting.go ogle.com>...[color=green]
      > > 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[/color]
      >
      > Well,
      >
      > Can anybody at least tell me to f**k off and do my own homework or is
      > this such a basic question that does not bear repeating. If the post
      > following mine in in response to my, possibly, banal question, well
      > sorry. I did find code here that I'm uusing but I do understand what
      > it's doing. I'm not a newbie to programming, but possibly just stuck
      > on a concept I'm not getting my head around at this time.
      >
      > Again, thank you for your time.
      > Steve[/color]

      Thanks for the responses. It really is quite overwhelming... No really...... Thanks.

      Comment

      Working...