Checking for existence of macros or code in an Excel Spreadsheet
 

Hi everyone,

I was wondering if there is a quick or easy way of
checking whether a file has any code or macros attached to
it?

thanks for your help in advance,

regards, Youssef

Checking for existence of macros or code in an Excel Spreadsheet
 

Youssef,

The easiest way would be to set your security level to Medium
Tools/Macro/Security
If there's code, you'll be prompted to enable it. If not, the workbook
will just open up without the prompt.
That's not to say that there couldn't be an empty module in the workbook

with no code as that would give the prompt too.

John

Youssef Mourra wrote:

Hi everyone,

I was wondering if there is a quick or easy way of
checking whether a file has any code or macros attached to
it?

thanks for your help in advance,

regards, Youssef

Checking for existence of macros or code in an Excel Spreadsheet
 

Youssef,

Found this little tidbit from Earl Takasaki posted back
on 3/28/2002.
http://makeashorterlink.com/?H19362C75
It's a little involved but he gives a good explanation of how
to code it and make it work.

John

Youssef Mourra wrote:

Hi John,

thanks for that. I should have clarified that I wanted to
check for existence of code/macros by using a macro to do
it. I've about 1000 excel files that we want to migrate
but I want my code to not only open and then close each
file to do other things, I also want to know if it
contains any code/macros. Is that possible?

thanks, Youssef Mourra
-----Original Message-----
Youssef,

The easiest way would be to set your security level to
Medium
Tools/Macro/Security
If there's code, you'll be prompted to enable it. If not,
the workbook
will just open up without the prompt.
That's not to say that there couldn't be an empty module
in the workbook

with no code as that would give the prompt too.

John

Youssef Mourra wrote:

Hi everyone,

I was wondering if there is a quick or easy way of
checking whether a file has any code or macros attached
to
it?

thanks for your help in advance,

regards, Youssef

.

Checking for existence of macros or code in an Excel Spreadsheet
 

John, thanks for this. I'm going to work it out with that
information.

regards,
-----Original Message-----
Youssef,

Found this little tidbit from Earl Takasaki posted back
on 3/28/2002.
http://makeashorterlink.com/?H19362C75
It's a little involved but he gives a good explanation of
how
to code it and make it work.

John

Youssef Mourra wrote:

Hi John,

thanks for that. I should have clarified that I wanted
to
check for existence of code/macros by using a macro to
do
it. I've about 1000 excel files that we want to migrate
but I want my code to not only open and then close each
file to do other things, I also want to know if it
contains any code/macros. Is that possible?

thanks, Youssef Mourra
-----Original Message-----
Youssef,

The easiest way would be to set your security level to
Medium
Tools/Macro/Security
If there's code, you'll be prompted to enable it. If
not,
the workbook
will just open up without the prompt.
That's not to say that there couldn't be an empty
module
in the workbook

with no code as that would give the prompt too.

John

Youssef Mourra wrote:

Hi everyone,

I was wondering if there is a quick or easy way of
checking whether a file has any code or macros
attached
to
it?

thanks for your help in advance,

regards, Youssef

.


.