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.
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.