View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] skeet4220@fcifw.com is offline
external usenet poster
 
Posts: 2
Default using excel data to create multiple web pages

an exampleof what i need, suppose i have an inventory file with
part#
desc
qty
price

and it has 100 part#'s in it.

i would like a program or routine that reads each line item and
creates a webpage
based on static data (ie, heading, footing, etc that is the same for
all web pages)
and creates a web page for each line item so that the end result will
be 100 seperate
web pages with one specific part#, desc, qty and price on each page.
one part# per web page.

sounds simple, i have very little experience with excel programming or
vba so please make your explantions simple or clear as you can. also,
if anyone is interested i am willing to pay
someone for this.

perferably, what i would like would be a master page with all the
static data, and the
individual fields would be labeled out in this master page (like,
field1, field2, field3, etc)
the routine would then place the data in the fields and then create
the single web page, write
it out to disk, and then go on to the next line item. when done, the
routine would just stop, and i could then transfer the entire
directory of web pages to my web site.

also including pics would be cool. the pics could be a link to
another directory with the jpg's
in them.

email me back at