I am trying to save a file in excel using the SaveAs function, due to the need of making the file an Excel 5/95 & 97 compatible.
Everything works fine, however when the current file is overwritten, excel wants the user to select yes to the prompt asking if the user wants to overwrite.
I have tried to use the following after the code that saves the file:
SendKeys("%y"
The macro when ran, produces the prompt after the code that saves the file, but before the above line of code!
Can anybody Help me????
Thanks in advance
Phasid "If something is hard to do - then it isn't worth doing" - Homer Simpson
Everything works fine, however when the current file is overwritten, excel wants the user to select yes to the prompt asking if the user wants to overwrite.
I have tried to use the following after the code that saves the file:
SendKeys("%y"
The macro when ran, produces the prompt after the code that saves the file, but before the above line of code!
Can anybody Help me????
Thanks in advance
Phasid "If something is hard to do - then it isn't worth doing" - Homer Simpson