Access - Excel Integration

  • Thread starter Thread starter omsoft
  • Start date Start date
O

omsoft

I have an Access DB where I create a dept table from a department selected in
the form.

Then when Show Projects button is pressed in that form, this table/record is
read by a separate Excel workbook and it does some calculations and creates a
report.

I also need to be able to run in Excel workbook standalone. It has its own
UI where if a department is selected, same calculations are done.

How do I know whether the query is coming from Access (press of the button
in the form) or the Excel workbook is opened standalone.

Sorry if this is an Excel question. I was not sure.

Thanks,
 
It's up to you to write the code to make things happen the way you
want from which ever platform you want. The concept is called
"Automation". Look for it in Help. There isn't much help but what's
there is really enough to get you going. It assumes that you already
know how to write VBA for the platforms you are considering using.

HTH
 
Back
Top