Using VBA in Exel Open and Close an .XLS file (and Process)

Attached Word document (Word2000) appears to successfully open and close an Excel file. BUT the Excel process is still there. [The Excel process goes away after I close the Word document] I may not be 'fully closing' Excel...I would not think I would have to execute any 'special code' to close the process, and assume my VBA ...continues

Using VBA in Exel, Open and Close an .XLS file AND End Process

Environment: Win2K, Work2000 Attached Word document has an OpenXL and a CloseXL VBA subroutine. Procedure: Open the Task Manager. Click the OPENXL and notice (in the Task Manager) that the Excel process is created. Click the CloseXL and notice(in the Task Manager) that the Excel process DOES NOT GO AWAY. [Granted, ...continues

Database Maintenance Tools

Please discuss what you believe to be a good backup and crisis management strategy for the following scenario. You work for a small consulting firm with a sterling reputation for high-quality work and outstanding technical aptitude. You've been assigned as the SQL Server 2000 DBA for an e-commerce project based in coastal Fl ...continues

Data Manipulation and Monitoring

What do you feel is the best strategy for monitoring the performance of your SQL Server 2000 installation? What hardware components are involved in successful monitoring of a database installation? What can be done within the database itself to performance?

Upgrading to SQL Server 2005

What are the advantages as far as features like improvement, new features, and ease of use to upgrading to SQL Server 2005 from older versions? Also where can I find references on that information?

Microsoft Excel

True or false questions 1. All functions use a range of cells for the argument. There are no single cell referenced formulas? 2. When Excel calculates averages, blank cells or cells containing text are ignored? 3. The NOW function can be used to display the current date, time, or a combination of the two in several differen ...continues

Microsoft Excel

13. A new workbook will initially contain only three worksheets; more can be added later if needed. 14. If you inadvertently delete a worksheet, you can restore it by clicking the Undo button 15. You can move and copy worksheets to another workbook only if that workbook is open? 16. If a range of sheets is referenced in a for ...continues

Microsoft excel

28. What is the first step that should be taken when creating a chart? A. providing a name for the chart B. selecting the chart type C. selcting the range of cells that contain the data the chart will use D. choosing the data labels that will be used on the chart 29. If you want to print only the chart in a worksheet, wh ...continues

Microsoft excel

Predefined formatting attributes that can be applied to a cell are called? A. designs B. themes C. styles D. schemes If a worksheet is saved as a Web Page, and you want to jump from the worksheet to another file or location on the internet, you need to insert which of the following into the worksheet? A. Hyperlink B. ...continues

Microsoft Excel

You are Sam Vestering, manager of North American Distribution for Worldwide Enterprises. You are preparing a projected distribution revenue schedule for Marquee Productions' latest films Two by Two, to be released February 14, 2003. Create a new workbook that will estimate Worldwide's projected revenue using the following inform ...continues