Purchase Solution

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

Not what you're looking for?

Ask Custom Question

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 code is 'nearly right' but not quite right.

Attachments
Purchase this Solution
Solution Summary

The solution assists with opening and closing an Excel file using VBA.

Solution Preview

Please find the modified file of your code as a text format.

I have modified the OpenXL4OE_Click() function in your code with the following line. It was working fine on my machine.

XL.ScreenUpdating = True

Public ...

Purchase this Solution
Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Javscript Basics

Quiz on basics of javascript programming language.

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.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

C# variables and classes

This quiz contains questions about C# classes and variables.

View More Free Quizzes
Related BrainMass Solutions

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

    51377 Using VBA in Excel, 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.

  • interface features

    capability of using data stored in Outlook or Access when creating mail-merge documents in Word * Commands for linking and embedding data from several Office applications in a single compound document * VBA, the common programming language

  • VBA product price calculator

    Hi, Open the attached Price Data file and press the Purchase product button. Enter the correct item code and the number of items purchase and it'll calcuate the total cost, along with the discount if applicable.

  • Autocorrelation and heteroscedasticity

    434510 5 Probs Multi Choice- Stats- Need Help to Validate My Answers Open the Cons Trans 59 - 00.xls file.

  • Microsoft Office applications

    capability of using data stored in Outlook or Access when creating mail-merge documents in Word * Commands for linking and embedding data from several Office applications in a single compound document * VBA, the common programming language

  • The Answer to Sample Distribution

    In this particular case because the number of records is too low, the relation does not hold exactly, but it is pretty close.

  • Velocity of an Object

    I am assuming we are in a systems of relative velocities where Newtonian mechanics is appropriate, since these are rocket ships and not elementary particles. The velocity of an object using Newtonian Models are provided.

  • A C++ program that shows how to read files

    This is exactly what you do when you are editing a file in a program such as Word. First you open the file, then you edit, then you save and close. A program does the same thing. In C++ we keep track of a file using a file stream object.

  • C++ Bank Queue Simulation Program

    401580 Bank Queue Simulation using C++ Customers walking into a bank are placed in a queue based on an arrival time distribution. Each customer has: 1. Customer number 2. Arrival time 3. Waiting time 4.

View More Related Solutions