Do a file search on those other systems for those files.

Also, it sounds like "gawk" probably some sort of user defined function.
This suspition os based on the error message. This function is probably in
some sort of external (to your spreadsheet file) dll file or something
similar. The sendit.bat may be a batch file of some sort. If that does not
work, from your system, open the VBA editor by selecting from your menu
Tools/Macro/Visual Basic Editor. From the Visual Basic Editor again from the
menu choose Tools/References. If any references on the list show "MISSING"
next to the reference your problem is a missing reference. If there is one
missing, the path to the reference file is shown on the Reference Window.
Write down this file. Search on your system for this file. If is is on your
system, but not in the same path, copy the file from it's current location to
the correct path location. I would copy instead of relocate all together in
case other applications expect the file there. If the file is missing, search
for than same file on the other systems that work properly. Copy the file
from there and place it into the correct location expected from the reference
Window.

I hope that helps!

Kevin

"Greg" wrote:

Hi,
I have a macro that I have been running for about two years to send internal
emails within our company without any problems. Now I have changed systems
(and platforms - Windows XP) and the macro gives me an error message as
follows:

The system cannot find the file specified.
'gawk' is not recognized as an internal or external command,
operable program or batch file.

About to send emails to the above.
Press Ctrl-C to quit or any other key to continue

At this point I would normally see all the email addresses above the text
that the emails are about to be sent to. I then hit any key and get the
following message..

The system cannot find the path specified.
'.\sendit.bat' is not recognized as an internal or external command,
operable program or batch file.
Done! Press any key to continue...

The mystery is that this macro still works fine on other user's computers
(who are also on Windows XP). My computer seems to have an issue with the
GAWK and sendit.bat files.

Any help, ideas or suggestions would be greatly appreciated.
Thanks,
Greg