By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,607 Members | 1,978 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,607 IT Pros & Developers. It's quick & easy.

AccessCode must wait until excel closes. HOW?

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.