Can you write data on a Access form from excel VBA?

[easyit]

Hi,


I have an access application that generates a excel sheet (background, not visible). This sheet is from a template which pulls data from access using AD. All works fine, but I would like to show the Accessuser the progress of the excel sheet. So I was wondering if it is possible to write data into a access form th that is being shown.


Does anybody know?

EasyIT

 

[JerryKlmns]

EasyIT,

you could use a progress bar (use SysCmd Method) since you do know the work in process going behind the scenes.

I had also found a progress bar example in a sample using a label in a form as .. a progress bar! Info found inside the form's module

JetSofts - Solution Informatique

http://www.jetsofts.com

code@jetsofts.com

but I think the site doesn't exist any more! It is here

http://www.mvps.org/access/resources/downloads.htm,

scroll down to progress bar