I am generating a Sheet called Scripts based on a series of user inputs in other Sheet tabs in the same Workbook.
I need some ideas on how to execute this Scripts in excel automatically.
Right now it is working, if I select all contents of Scripts sheet and paste in the Query Analyzer (Manual process).
I was trying to save this sheet as text document, but somehow it is not working with the options (Unicode, DOS, space delimited).
Any ideas would be appreciated.
Thanks,
Carlos
I need some ideas on how to execute this Scripts in excel automatically.
Right now it is working, if I select all contents of Scripts sheet and paste in the Query Analyzer (Manual process).
I was trying to save this sheet as text document, but somehow it is not working with the options (Unicode, DOS, space delimited).
Any ideas would be appreciated.
Thanks,
Carlos