Search results for query: *

Hi Gerry, I have all the elements almost built, in test it works well but need to pull it all together now and add in the additional html code that the site will need. It may not be the best code but it works. I will post when finished or if I get stuck again.

Thanks for your input Tony and Gerry, it's been helpful. The content written by other users would be created using word (a tool they can all use) and would be created using specific and limited formats. Using excel enables me to hold a site map with appropriate meta values etc. I can then build...

Hi, Thanks to some great advice on a previous thread, using Excel I am able to open a word doc exctract each paragraph test for the applied style and write it into a line of html. However I realise now that I need to go deeper into the document as normal paragraphs will possibly contain some...

Your a star Tony, That worked fine. Many thanks to Gerry and yourself for your help.

Just when I thought it was cracked I've noticed something strange. If Outlook is open and I open the spreadsheet everything works fine. If I close Outlook and run the code I get this error If I do not open Outlook and open the spreadsheet and run the code I get the error Sub Main() Dim...

Many Thanks Gerry, your comments have resolved my problems and once I moved the oWord.quit to the end the error 91 went. This is my first time I have tried getting excel to talk to word through vba so your help is much appreciated. Bryan

The plan is that content owners who are not web publishers write the page in word following a set format and these files are then placed into a folder. The spreadsheet is then populated with the file names and when run reads each document and builds an html page based on the content and...

Hi, I want to automate a web site where word documents can be completed following a set format and an excel spreadsheet would read the document/s and build web pages basedon the word doc formating but need a pointer in the right direction when it comes to interogating the word file. I have code...