Error 1004 Workbooks.Add Inplace-Activation

  • Thread starter Thread starter Magnus Pettersson
  • Start date Start date
M

Magnus Pettersson

Hi !
I don't know if I am in the correct forum
but here it comes any way

Sub AddWorkBook()
ThisWorkbook.Application.Workbooks.Add
End Sub

this simple macro only works from the debugger environment if I have XL
Inplace Activated

Is there any workarounds ?

Best regards Magnus
 
Is it so that XL has a state that it cannot do this ?

COleClientItem::activeUIState

Do I have to change state to
pItem->DoVerb (OLEIVERB_OPEN, pView ); ????
 
You must log in or register to reply here.

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

Excel Runtime error 1004:: Method 'Range' of Global Failed 0
Runtime Error 1004 1
Need a Error Handling for this Macro 2
Run-time Error '1004' 1
question about syntax in a simple macro... 3
Run time 1004 5
Why do I get VLookup error 1004 2
Run time error 1004 in loop 4

Back
Top