473,657 Members | 2,426 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

AccessCode must wait until excel closes. HOW?

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
2 2810
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%******** ************@ph obos.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
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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2067
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 keys I've provided to close the Excel apps and COM interfaces. But I really need the ability to manage the workbook if someone closes it using the 'exit' command or the right/upper 'x' from within the excel spreadsheet.
6
2399
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 automation. N.B. the environment is a totally enclosed intranet, all the client machines have WinXP, IE6 and Office Pro 2003 with all the latest SPs, and the IE security settings are sufficient to allow the Local Intranet Zone to instantiate...
12
5261
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 block protecting a resource. Thread 2 and 3 also have a SyncLock block protecting the same resource and after executing some code in their blocks they both do a Monitor.Pulse to hand of the locked resource back to thread 1. While thread 1 has...
0
1497
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 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_xl2003_ta/html/odc_XLxmlhowto_.asp - Using VB and ASP with XML to generate Excel 2003 workbooks). This works fine. The problem is that in XP SP2, the IE instance opened for the vbscript only page no longer closes when Excel is closed. The user has to manually...
1
5675
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 frmRandom, i tried it with the Sleep API and a Do/Until Loop and neither worked, could you please help me, I have my code below. frmMachine 'Slot Machine, (c) 2006 Peter Browne, GPL Licensed ' 'Peter Browne 'Sheridan Corporate Centre '2155 Leanne...
6
12831
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 doesn't return) until the process exits??? Any help is highly appreciated! The code is like this: Process myProcess = new Process(); myProcess.StartInfo.FileName = Application.StartupPath + "\\myCmdLine.exe";
4
11091
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. However, when I open the window, JavaScript immediately issues the next command statement. How can I get JavaScript to wait until the window is closed before continuing? Here's visually what I'm trying to do: statement1; GB_show('mycaption,...
4
21458
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 products. They can set this form to varying statuses so that their supervisors can review the orders before they get placed. When the user (call them technicians) sets the order form to "review" status, the code goes through each individual item that...
2
3032
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 retrieving values. I have attempted using sleep(60) but would like something a little more "deterministic". Is there anyway to get a status on when calculations are done? TIA.
0
8829
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8734
jinu1996
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8508
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7341
agi2029
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6172
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4164
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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4323
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2733
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 we have to send another system
2
1962
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.