When I execute one of my macros, it starts another excel
file before executing the macro. I think that vba has it
stored in the second excel file.

Can anyone tell me how to check this; and how to get the
macro located only in the first excel file so the macro
does not start another excel file in order to do its work?

hi,
if the macro excutes then it is stored in your 1st file or
at least enough code to open the 2nd file to call the
macro.
if it opens another file, then the macro has code in it to
open the 2nd file.
Post your code.

-----Original Message-----
When I execute one of my macros, it starts another excel
file before executing the macro. I think that vba has it
stored in the second excel file.

Can anyone tell me how to check this; and how to get the
macro located only in the first excel file so the macro
does not start another excel file in order to do its work?

.

Instead of doing Macro, Run do Macro, Edit.
Copy the whole macro and post it here.

RBS

"Paul" wrote in message
...
When I execute one of my macros, it starts another excel
file before executing the macro. I think that vba has it
stored in the second excel file.

Can anyone tell me how to check this; and how to get the
macro located only in the first excel file so the macro
does not start another excel file in order to do its work?

hi again,
forgot to mention,
to see modules, open the vb editor (alt+F11). on the left
click the + next to your project(file name). this should
display all the modules in your file.

-----Original Message-----
hi,
if the macro excutes then it is stored in your 1st file
or
at least enough code to open the 2nd file to call the
macro.
if it opens another file, then the macro has code in it
to
open the 2nd file.
Post your code.

-----Original Message-----
When I execute one of my macros, it starts another excel
file before executing the macro. I think that vba has
it
stored in the second excel file.

Can anyone tell me how to check this; and how to get the
macro located only in the first excel file so the macro
does not start another excel file in order to do its
work?

.

.