I want to run some VBA code on a PC whenever ANY workbook is opened in excel.
It can not only be when excel opens, it need to be even if a new file is
oened once excel is already running. Any suggestions?

In a module, create an Auto_Open macro, like:

Public Sub Auto_Open()
'do the hokie pokie
End Sub

Save your file with the .xla extension, to make it an Add-in.
Pick Extra/Add-ins and check your own file. After that, it'll always run
when Excel is opened.




"Shimmess" schreef in bericht
...
I want to run some VBA code on a PC whenever ANY workbook is opened in
excel.
It can not only be when excel opens, it need to be even if a new file is
oened once excel is already running. Any suggestions?

http://www.cpearson.com/excel/appevent.htm

so you would need to start application level events by using an addin in
Excel that is loaded when excel starts.

--
Regards,
Tom Ogilvy




"Shimmess" wrote:

I want to run some VBA code on a PC whenever ANY workbook is opened in excel.
It can not only be when excel opens, it need to be even if a new file is
oened once excel is already running. Any suggestions?

Will this work then on a file that is opened and excel is already running?

"moon" wrote:


In a module, create an Auto_Open macro, like:

Public Sub Auto_Open()
'do the hokie pokie
End Sub

Save your file with the .xla extension, to make it an Add-in.
Pick Extra/Add-ins and check your own file. After that, it'll always run
when Excel is opened.




"Shimmess" schreef in bericht
...
I want to run some VBA code on a PC whenever ANY workbook is opened in
excel.
It can not only be when excel opens, it need to be even if a new file is
oened once excel is already running. Any suggestions?

It only runs when the addin gets loaded - it has nothing to do with any other
file being opened. So the short answer is no.

--
Regards,
Tom Ogilvy




"Shimmess" wrote:

Will this work then on a file that is opened and excel is already running?

"moon" wrote:


In a module, create an Auto_Open macro, like:

Public Sub Auto_Open()
'do the hokie pokie
End Sub

Save your file with the .xla extension, to make it an Add-in.
Pick Extra/Add-ins and check your own file. After that, it'll always run
when Excel is opened.




"Shimmess" schreef in bericht
...
I want to run some VBA code on a PC whenever ANY workbook is opened in
excel.
It can not only be when excel opens, it need to be even if a new file is
oened once excel is already running. Any suggestions?

thuoght so. Your suggestion works fine. It seems that the application that
is launching the ecel files I want to edit is able to bypass the code I put
in. Is it possible for apps to code in to bypass the Open function? If they
did, any other options to force my code anyways or am I out of luck?

"Tom Ogilvy" wrote:

It only runs when the addin gets loaded - it has nothing to do with any other
file being opened. So the short answer is no.

--
Regards,
Tom Ogilvy




"Shimmess" wrote:

Will this work then on a file that is opened and excel is already running?

"moon" wrote:


In a module, create an Auto_Open macro, like:

Public Sub Auto_Open()
'do the hokie pokie
End Sub

Save your file with the .xla extension, to make it an Add-in.
Pick Extra/Add-ins and check your own file. After that, it'll always run
when Excel is opened.




"Shimmess" schreef in bericht
...
I want to run some VBA code on a PC whenever ANY workbook is opened in
excel.
It can not only be when excel opens, it need to be even if a new file is
oened once excel is already running. Any suggestions?

I suspect if excel is being launched by some other application, then your
addin isn't being loaded. There wouldn't be a way around this that I could
think of. When excel is opened via automation, it doesn't load addins or
files in the xlstart directory.

Just a guess that your code is correct and that is what is happening.

--
Regards,
Tom Ogilvy

"Shimmess" wrote in message
...
thuoght so. Your suggestion works fine. It seems that the application
that
is launching the ecel files I want to edit is able to bypass the code I
put
in. Is it possible for apps to code in to bypass the Open function? If
they
did, any other options to force my code anyways or am I out of luck?

"Tom Ogilvy" wrote:

It only runs when the addin gets loaded - it has nothing to do with any
other
file being opened. So the short answer is no.

--
Regards,
Tom Ogilvy




"Shimmess" wrote:

Will this work then on a file that is opened and excel is already
running?

"moon" wrote:


In a module, create an Auto_Open macro, like:

Public Sub Auto_Open()
'do the hokie pokie
End Sub

Save your file with the .xla extension, to make it an Add-in.
Pick Extra/Add-ins and check your own file. After that, it'll always
run
when Excel is opened.




"Shimmess" schreef in bericht
...
I want to run some VBA code on a PC whenever ANY workbook is opened
in
excel.
It can not only be when excel opens, it need to be even if a new
file is
oened once excel is already running. Any suggestions?