open excel & have access wait for excel to close (1 Viewer)

K

krberube

just beyond new

Local time

Today, 02:21

Joined

Jan 14, 2005

Messages

142

• Jun 8, 2005

• #1

Good afternoon all,
If I place some code to export a table to Excel, open excel so a person can do something, then close excel.

will my access code wait for excel to close before the code continues running?

If not, what would a good way to code this "wait" into the event?

Thanks
Kevin

 

ghudson

Registered User.

Local time

Today, 02:21

Joined

Jun 8, 2002

Messages

6,195

• Jun 9, 2005

• #2

Why do you need to do that? You should be able to update the data within Access, not having to use Excel for the user to make adjustments.

Search for the keyword WAIT for I have seen a few related threads.

 

M

modest

Registered User.

Local time

Today, 02:21

Joined

Jan 4, 2005

Messages

1,220

• Jun 9, 2005

• #3

"Sleep" or "pause" is another thing you can search for. I'm also curious why you would want to wait for excel to close.

 

K

krberube

just beyond new

Local time

Today, 02:21

Joined

Jan 14, 2005

Messages

142

• Jun 9, 2005

• #4

I seem to have alot of trouble doing graphs in access, at least getting them to look the way management wants them. I found that by exporting the data to excel, changing the data a little (graph is updates by itself), saving the .xls file. Then show the excel graph in the access report it works quite well.

I would like to do this until I can come up to speed with the access graph program, which seems to be abit tricky.

So I guess I need to code something to make it wait. No problem I think

Thanks

 

M

modest

Registered User.

Local time

Today, 02:21

Joined

Jan 4, 2005

Messages

1,220

• Jun 9, 2005

• #5

I've never fiddled with what you speak of, but if you're "creating" the graph from Access through Excel... meaning, if you the code to make the graph is done through Access's VBA, then you shouldn't have to wait.

However if you're just sending the data to Excel and manually making the graph or if you're using Excel's VBA to make the graph, then yes you would have to wait.

So I guess the question comes down to: how are you making the graph?


Here is some basic logic you could use in access:

1. Open Excel
2. Transfer Data
3. Create Graph
4. Save Excel
5. Get graph from Excel
6. Close Excel
7. Continue with Program

 

K

krberube

just beyond new

Local time

Today, 02:21

Joined

Jan 14, 2005

Messages

142

• Jun 9, 2005

• #6

Modest:
you have it correct. I Believe it to be pretty straight forward to do.

Thanks