Running Macro from Word vs running macro from vb.net prog

S

Simon

I'm using the following to open and run a macro in word

wordApp.Documents.Open(MyDoc)
wordApp.Run("CatgTitle")
wordApp.save()

The Macro goes through each item in Column A and based on the properties
adjusts row hight, column width, font etc. also merges columns

this takes 40 mins for 4000 rows

Works fine if I run this from word using tools > macro run

But if I execute it from VB with above code the column width are not set
correctly

because columns are merged I can't adjust the columns after running the
macro!

Any help would be appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to set the desired column width for a table with merged cells 0
Unable to set the desired column width for a table with merged cells 0
Macro to run on a Table after Merge 6
Merging Macros 1
After Macro runs, no cell activated - what am I missing? 2
Import Word Table Macro running very slow 13
Saving a Word document as PDF from en Excel macro 2
Macro to Run Functions and VBA code??? 0

Top