Thread
:
WorkBook Activate event not working
View Single Post
#
5
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
WorkBook Activate event not working
I don't do C++. This is visual basic for applications VBA
--
Don Guillett
SalesAid Software
wrote in message
ups.com...
Don Guillett wrote:
Application.EnableEvent(True)
Application.EnableEventS=true
Here is one I use with a double_click event to goto a workbook whose name
is
typed in a cell.
Sub GetWorkbook()
If ActiveCell.Value = "" Then Exit Sub
workbookname = ActiveCell.Value
On Error GoTo OpenWorkbook
Windows(workbookname & ".xls").Activate
Exit Sub
OpenWorkbook:
Workbooks.Open(workbookname & ".xls").RunAutoMacros xlAutoOpen
End Sub
--
Don Guillett
SalesAid Software
wrote in message
ups.com...
Hello,
I have an excel addin (.xla) file under excel startup folder (ie,
\office11\startup), where I have defined App_WorkbookActivate event.
This macro executes fine when I open the excel file from explorer. But
when I open the file from automation, it does not execute.
The code is as follows,
Application.EnableEvent(True)
ActiveWorkbook = AllWorkbooks.Open("filename")
ActiveWorkbook.RunAutoMacros(3)
Any suggestions would help!
Thankyou.
Thanks for your reply.
The code looks similar, except for
Windows(workbookname & ".xls").Activate
What does the above line of code do?
I am writing in c++ and I am not sure what is the code equivalent to
the above in c++?
I understand Workbook activate is executed when workopen is opened.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett