passing values from access to excel

R

rtiguy

I use a command button on an Access form to open up an Excel spreadsheet
file. It does this through a Visual Basic shell command. Is there any way to
pass a value to Excel? It would use this value to run its own query to
retreive and display information related to the record that is present on the
Access form.

Thanks.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to cause a spreadsheet (Excel) to run from an Access Macro 4
Exporting to Excel from Access 3
passing params to multiple querydefs and transferspreadsheet 8
Populate cells in an excel spreadsheet with information from an access database 1
Excel MS Access 2010- Excel templete autofill from form record 0
Importing from Excel to a droplist field 1
Access Count query 1

Top