[Bill Lunney]

You could record and store a macro then save it to your personal macros.
Assigning a hotkey to this would mean you could load any file and press the
relevent key combination to execute the macro.

Just remember to save the changes to personal.xls when prompted.

However even this may be tedious for 60 files. Depending on the complexity
you could wrap the operation you want to perform into a macro then write a
function which loads all the workbooks in a directory (for example) one by
one and executes the macro on each (saving as you go if required). This is
obviously more demanding but certainly possible and maybe necessary
depending on what you want to do.



--

Regards,


Bill Lunney
www.billlunney.com

"igor" wrote in message
...
Hi,

here is my issue, pleeeease help. i have 60 files that are
formated identically. i need to make the same changes to
all of them without copying and pasting the code into each
individual file. can anyone help please.


Thank you
Igor

[Randall Arnold[_2_]]

I haven't found personal.xls to work well, myself (see my post below). On
my machine, the subs in personal.xls only fire when the first default
worksheet is loaded, then do nothing when additional workbooks are
created/opened.

You have any idea why this is?

Randall Arnold
"Bill Lunney .com" <mail@billlunney<removeme wrote in message
...
You could record and store a macro then save it to your personal macros.
Assigning a hotkey to this would mean you could load any file and press
the
relevent key combination to execute the macro.

Just remember to save the changes to personal.xls when prompted.

However even this may be tedious for 60 files. Depending on the
complexity
you could wrap the operation you want to perform into a macro then write a
function which loads all the workbooks in a directory (for example) one by
one and executes the macro on each (saving as you go if required). This
is
obviously more demanding but certainly possible and maybe necessary
depending on what you want to do.



--

Regards,


Bill Lunney
www.billlunney.com

"igor" wrote in message
...
Hi,

here is my issue, pleeeease help. i have 60 files that are
formated identically. i need to make the same changes to
all of them without copying and pasting the code into each
individual file. can anyone help please.


Thank you
Igor

[Dave Peterson[_3_]]

See one guess at your first post.

Randall Arnold wrote:

I haven't found personal.xls to work well, myself (see my post below). On
my machine, the subs in personal.xls only fire when the first default
worksheet is loaded, then do nothing when additional workbooks are
created/opened.

You have any idea why this is?

Randall Arnold
"Bill Lunney .com" <mail@billlunney<removeme wrote in message
...
You could record and store a macro then save it to your personal macros.
Assigning a hotkey to this would mean you could load any file and press
the
relevent key combination to execute the macro.

Just remember to save the changes to personal.xls when prompted.

However even this may be tedious for 60 files. Depending on the
complexity
you could wrap the operation you want to perform into a macro then write a
function which loads all the workbooks in a directory (for example) one by
one and executes the macro on each (saving as you go if required). This
is
obviously more demanding but certainly possible and maybe necessary
depending on what you want to do.



--

Regards,


Bill Lunney
www.billlunney.com

"igor" wrote in message
...
Hi,

here is my issue, pleeeease help. i have 60 files that are
formated identically. i need to make the same changes to
all of them without copying and pasting the code into each
individual file. can anyone help please.


Thank you
Igor



--

Dave Peterson

[Randall Arnold[_2_]]

That was it, Dave!

Looks like Chip's suggestions will work for me; thanks again!

Randall

"Dave Peterson" wrote in message
...
See one guess at your first post.

Randall Arnold wrote:

I haven't found personal.xls to work well, myself (see my post below).
On
my machine, the subs in personal.xls only fire when the first default
worksheet is loaded, then do nothing when additional workbooks are
created/opened.

You have any idea why this is?

Randall Arnold
"Bill Lunney .com" <mail@billlunney<removeme wrote in message
...
You could record and store a macro then save it to your personal
macros.
Assigning a hotkey to this would mean you could load any file and
press
the
relevent key combination to execute the macro.

Just remember to save the changes to personal.xls when prompted.

However even this may be tedious for 60 files. Depending on the
complexity
you could wrap the operation you want to perform into a macro then
write a
function which loads all the workbooks in a directory (for example)
one by
one and executes the macro on each (saving as you go if required).
This
is
obviously more demanding but certainly possible and maybe necessary
depending on what you want to do.



--

Regards,


Bill Lunney
www.billlunney.com

"igor" wrote in message
...
Hi,

here is my issue, pleeeease help. i have 60 files that are
formated identically. i need to make the same changes to
all of them without copying and pasting the code into each
individual file. can anyone help please.


Thank you
Igor



--

Dave Peterson