View Single Post
 
Old 04-16-2017, 06:08 AM
rogerbowering rogerbowering is offline Windows 10 Office 2010 32bit
Novice
 
Join Date: Apr 2017
Posts: 15
rogerbowering is on a distinguished road
Post Help with Complex VBA program

Hi

At work I have to create Report templates using Word and pre-supplied Macro enabled Template (.dotm)

The template provides additional buttons and code to the Word documents I work on

The purpose of the code is to, essentially create a HTML version of the document ('documentname.tmp') in a subdirectory (compiled) of the original working document directory, i.e. //my directory/compiled/ and then it 'compiles' the HTML code into a further sub directory //my directory/compiled/mydocument_files/ and a jsp version of the document.

So I start with
//my directory/myworddoc.docx

and end with
//my directory/myworddoc.docx
//my directory/compiled/createdoc_myworddoc.jsp
//my directory/compiled/createdoc_myworddoc.tmp
//my directory/compiled/myworddoc_files/

For the last year, when I run the code, all the necessary folders and documents are created and I am left with the active docx file on screen.

But now when I run the code I left in the compiled folder with the tmp file as the active document (and the docx file closed).

Can anyone make sense of the VBA and advise if it can be changed to achieve what I need

PS the original coder has now disappeared
Attached Files
File Type: dotm McLarens Document Production Template.dotm (147.4 KB, 20 views)
File Type: txt Document Template VBA and Properties.txt (18.6 KB, 13 views)
Reply With Quote