office assistant code does not work anymore

G

Guy Cohen

Hi all
In the past this code worked - now it does not.
WHY? :)
I get rte 4601.
===========
Dim objOffice As Word.Application
Set objOffice = New Word.Application
objOffice.WindowState = wdWindowStateMinimize
Call objOffice.Activate
===========


TIA
Guy
 
T

Tony Jollans

I don't know why it might have worked before but I don't think you can
Activate - or, for that matter, Minimize - an invisible application. Add
this line:

objOffice.Visible = True

before setting the window state.
 

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

Making a macro only work on certain files 2
Problems starting Word from Excel VBA 3
VBA Coding Help for Beginner 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
VBA word change keys 0
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Syntax to pull from data *open*Word instance? (XL2007) 1

Top