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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Access Integration 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Protection 2
Record insert/delete anomaly 0
Access Making a memo in Access 0
Access Switchboard error message 1
Email Excel Workbook Automatically Daily 3
Access Automatically Send a notification email once a record is added 0

Back
Top