Purchase Solution

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

Not what you're looking for?

Ask Custom Question

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, if you close Word document, the process terminates, but I need to kill the process BEFORE closing Word (presumably using a slightly improved VBA subroutine).]

Attachments
Purchase this Solution

Solution Summary

The solution assists with answering the question using VBA in Excel.

Purchase this Solution


Free BrainMass Quizzes
Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

C++ Operators

This quiz tests a student's knowledge about C++ operators.