Search results for query: *

Tony and fumei... once again thanks, I have built a UCASE2.dot template and staged the following. Do I have all the requirement right? Or is something missing or overlooked? I'm looking at both solutions at the same time. Please review this version of the macro... (This is my go-live...

Hum... Okay... I have created a standard template, MyTemplate.dot, with the requirements. What and where should I place the code in the above marco? template header example: Prefix: xxxx 001 <-- (xxx 001) this data changes with incoming EXCEL data> Environment: xxxxxxxx <--(xxxxxxx)...

Tony and fumei, thanks for all the help as I learn Excel/Word automation... Ok. I tried adding WordApp but took an error at If .HeaderFooter.IsHeader = True Then Maybe I'm not clear in whats needed. Let me start over... I know its simple I just can't put it together. I need to accomplish...

I ran the basic marco without the HeaderFooter code and it runs fine. Creating a HeaderFooter for each Word doc and listing the steps for each doc is the challenge/problem. Its a basic Word report with a number of font changes... I can handle the font changes. Please help!

Thanks fumei, Below is a sample of the Word document I'm trying to build for each record in my sheet. I have most of it working... my challenge is inserting a Header (2-lines) and Footer (1-line) in the Word document. Also, when the data from Excel comes into the Word document I need to list...

Hello, I need help with two areas in the following marco. The macro is extracting data from EXCEL into WORD. I'm trying insert data from the sheet into my HeaderFooter and create a list from the STEPS cell. More details are in the marco: Sub ExceltoWord() ' ExceltoWord Macro ' Creates...