macro error
 

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

macro error
 

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

macro error
 

http://www.gnu.org/software/gawk/gawk.html

possibly.

--
Regards,
Tom Ogilvy


"Kevin" wrote in message
...
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

macro error
 

Any way you can get access to your old system?

Maybe you can copy both those files from the old pc
(use windows start button|search to find them)

And put them in folders with the same name/structure.

If you're lucky, that could work. If you're unlucky, you may have to edit the
macro code to point at the correct location.

If you don't have access to the old pc, maybe the IT department can restore from
a backup of that old pc and give you copies that way.



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

--

Dave Peterson