Sukotto
05-21-2007, 08:52 AM
How do I setup Visual Studio (2005) to give me the same debugging features as the Excel/Word/Outlook VBA editors?
My job for the next few months is to create and maintain .vbs and .wsf scripts that drive MS Office applications. (e.g. a scheduled script that opens a series of Office documents, runs embedded vba functions, and do some other stuff)
When programming in Excel or whatever, I can test functions, set breakpopints, use the "Immediate" window, etc....
I would really like to step through scripts and check variables in these driver scripts but can't figure out how to make it happen. So I have to edit the script, save, then run the script manually via start->run or on the commandline. :banghead:
How do I set up Visual Studio to allow the same debugging features?
I'm runinng VS2005 on Windows 2k, interacting with Office 2k and IE 6.
My job for the next few months is to create and maintain .vbs and .wsf scripts that drive MS Office applications. (e.g. a scheduled script that opens a series of Office documents, runs embedded vba functions, and do some other stuff)
When programming in Excel or whatever, I can test functions, set breakpopints, use the "Immediate" window, etc....
I would really like to step through scripts and check variables in these driver scripts but can't figure out how to make it happen. So I have to edit the script, save, then run the script manually via start->run or on the commandline. :banghead:
How do I set up Visual Studio to allow the same debugging features?
I'm runinng VS2005 on Windows 2k, interacting with Office 2k and IE 6.