Link to specific cells on Excel Spreadsheet to generate reports

T

twen

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?
 
K

Klatuu

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"
 
Top