J
Jack
I currently manage a website with several hundred webpages. The webpages are
generally identical with exception of some keywords on each page. Currently
when an update has to be made, it is a very tedious task. This is what I
currently have to do:
Make a temp page with the keywords(are throughout page) marked out - ie
##keywords1##, ##keywords2##
I then have excel spreadsheet with 3 cols.(col 1 is keywords 1, col2 is
keywords 2, col 3 is what I what the file to be saved as)
I have a macro set up that copies text from cell 1 col1 and does a replace
all in notepad of any instance ##keywords1##. It then does the same thing for
cell1 col2 ##keywords2##. And finally it copies info from cell1 col 3 which
is what I need the file to be named. Delete row in Excel - load temp page and
repeat the process. This works fine but takes forever!
What I am hoping to do is have access do this for me. I would like to either
import temp file(.txt)- or preferbly stored in a table.
Have a keywords table that would store keywords stored
Have a filename table that would store what I need files to be saved as.
Would do a line by line find&replace of temp file and save it according to
filename table.
Can this be done in access and is there any size limitation of the input
file (temp)
Thanks,
Jack
generally identical with exception of some keywords on each page. Currently
when an update has to be made, it is a very tedious task. This is what I
currently have to do:
Make a temp page with the keywords(are throughout page) marked out - ie
##keywords1##, ##keywords2##
I then have excel spreadsheet with 3 cols.(col 1 is keywords 1, col2 is
keywords 2, col 3 is what I what the file to be saved as)
I have a macro set up that copies text from cell 1 col1 and does a replace
all in notepad of any instance ##keywords1##. It then does the same thing for
cell1 col2 ##keywords2##. And finally it copies info from cell1 col 3 which
is what I need the file to be named. Delete row in Excel - load temp page and
repeat the process. This works fine but takes forever!
What I am hoping to do is have access do this for me. I would like to either
import temp file(.txt)- or preferbly stored in a table.
Have a keywords table that would store keywords stored
Have a filename table that would store what I need files to be saved as.
Would do a line by line find&replace of temp file and save it according to
filename table.
Can this be done in access and is there any size limitation of the input
file (temp)
Thanks,
Jack