I am using an Access database to create some simple html pages. I have hundreds of them to do, and it was a tedious job to do them individually, so I got the idea to create a simple database to hold the variables for each page.
Before you suggest that I just create a dynamic site, the purpose of these pages is for search engine optimization of a complex catalog and it wasn't my idea.
For some strange reason, my code creates a quotation mark at the beginning and the end of my html file which is created. Can anybody tell me how to get rid of it (using code)?
MrsBean
Before you suggest that I just create a dynamic site, the purpose of these pages is for search engine optimization of a complex catalog and it wasn't my idea.
For some strange reason, my code creates a quotation mark at the beginning and the end of my html file which is created. Can anybody tell me how to get rid of it (using code)?
Code:
Do Until rst.EOF
htmlOut = "<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.01
Transitional//EN'> " & vbCrLf & _
"<html> " & vbCrLf & _
"<head> " & vbCrLf & _
"<title>" & rst("webhTitle") & "</title> " & vbCrLf & _
"<meta name='keywords' content='" & rst("webhKeywords") & "'>" &
vbCrLf
Open "c:\HTMLFILES\" & rst("webdPage") For Output As #1
Write #1, htmlOut
Close #1
rst.MoveNext
LoopMrsBean
