Link to specific cells on Excel Spreadsheet to generate reports

G

Guest

Is it possible to link to a specific cell in an excel spreadsheet in a
report? Like bind text boxes to specific cells on an Excel spreadsheet?
 
G

Guest

Have you looked in VBA Help for TransferSpreadsheet?
You will find most of what you need there. As to the argument, it is like
any other Excel range reference. For example if you want cells A3 through
J250, it would be
"A3:J250"
 

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
Importing Specific Worksheet from Excel Spreadsheet 2
Excel Linking (I think) 17
Alt codes 4
TransferSpreadheet: Importing a Specific Spreadsheet 3
Unlink cells- how? 0
How do I insert a photo into a specific cell? 3
Create Excel Lab test results 1

Top