AccessCode must wait until excel closes. HOW?

Filips Benoit

Dear all,

A Access2000 interface handling quotations as excel-files. Exceldata and
images are mixed in access-reports.
All excelfiles are opened from access.
I want to run some code after the user has closed the quotation and is back
in access.

Open excel-file
Wait while excel is running
.... The user closes excel and saves as new or excisting version (
Filip_0.xls Filip_1.xls) >> Excel-macro handles versionnames.
Some code: did the user save as a now version or not. If yes show new
version as last version.
HOW ??

Thanks,

Nov 13 '05 #1

Subscribe Reply

2804

Filips Benoit

I found this solution:

After the code that opens the excelfile i have a msgbox that waits for an
OK.
Only after the OK-click ( then excel is closed) i search the last version
in the users folder.
(The msgbox is displayed while excel is open but not visible because the
excelwindow covers the accesswindow!)

Filip
"Filips Benoit" <be***********@pandora.be> wrote in message
news:b%********************@phobos.telenet-ops.be...

Dear all,

A Access2000 interface handling quotations as excel-files. Exceldata and
images are mixed in access-reports.
All excelfiles are opened from access.
I want to run some code after the user has closed the quotation and is back in access.

Open excel-file
Wait while excel is running
... The user closes excel and saves as new or excisting version (
Filip_0.xls Filip_1.xls) >> Excel-macro handles versionnames.
Some code: did the user save as a now version or not. If yes show new
version as last version.
HOW ??

Thanks,

Nov 13 '05 #2

Trevor Best

Filips Benoit wrote:

Dear all,

A Access2000 interface handling quotations as excel-files. Exceldata and
images are mixed in access-reports.
All excelfiles are opened from access.
I want to run some code after the user has closed the quotation and is back
in access.

Open excel-file
Wait while excel is running
... The user closes excel and saves as new or excisting version (
Filip_0.xls Filip_1.xls) >> Excel-macro handles versionnames.
Some code: did the user save as a now version or not. If yes show new
version as last version.
HOW ??

http://www.mvps.org/access/api/api0004.htm

--
This sig left intentionally blank

Nov 13 '05 #3

Similar topics

2064

COM - Excel: What happens if users closes workbook externally?

by: Marc | last post by:

Hi all, I have a problem with managing the interchange between COM/Excel and Python if the user closes the workbook externally. Everything works fine as long as the user only uses the exit...

Python

2379

Output to Word & Excel

by: Mark Rae | last post by:

Hi, My client has asked me to provide a "quick and dirty" way to export the contents of a DataGrid to both Excel for analysis and Word for editing and printing, so I'm investigating client-side...

ASP.NET

5237

threading - Monitor.Wait/Pulse

by: Perecli Manole | last post by:

I am having some strange thread synchronization problems that require me to better understand the intricacies of Monitor.Wait/Pulse. I have 3 threads. Thread 1 does a Monitor.Wait in a SyncLock...

.NET Framework

1493

ASP/XML stream to Excel

by: Xanthus | last post by:

My webpage opens a vbscript only page that gets data in xml format and streams it to Excel. (As described at...

ASP / Active Server Pages

5657

Slot Machine Game, need to have frmMachine wait for frmRandom

by: peterggmss | last post by:

This is a slot machine game, 2 forms. One is the actual game (frmMachine) and the other is in the background and randomizes the images shown on frmMachine. I need to make frmMachine wait for...

Visual Basic 4 / 5 / 6

12786

StandardOutput.ReadLine() doesn't work until the app exits???

by: Ole | last post by:

Hi, I'm running a command line process from my C# application trying to catch the output messages from the process into a textbox in my windows form. But the text doesn't update (the ReadLine...

C# / C Sharp

11073

Wait until window closed before continuing

by: Eddie | last post by:

I am opening a windows (well, technically a greybox() call GB_show() which shows a nicer window than normal), and want to wait until that window is closed before moving to the next command. ...

Javascript

21429

URGENT - VBA Code to wait until Form Closes

by: Luke Bailey | last post by:

I'm trying to complete some changes to a database that I have created and I need to finish it by tomorrow morning! Here's the situation: I have a form where people can order a number of...

Microsoft Access / VBA

3025

Wait for Excel to calculate

by: alagalah | last post by:

Hi there, I have a series of Excel sheets with some heavy calculations (may take about a minute for them to calc). I want Python to open the spreadsheets and wait until the calc stops before...

Python

7339

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7463

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5581

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4678

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3168

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3157

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1515

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

738

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

389

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General