Reference a cell in Excel

[JF Bouthillier]

Hi all,

How can I display the value of a specific Excel worksheet
cell in a form?

Thank you.
JF

 

[John Nurick]

Hi JF,

One way is to use a listbox one row high, with a RowSourceType of
Table/Query and a RowSource like this (adjusted for the workbook,
worksheet and cell address:

SELECT F1
FROM [Excel 8.0;HDR=No;database=D:\folder\file.xls;].[Sheet1$B5:B5];