On Tue, 14 Nov 2006 11:17:15 -0500, ChasW <wrote:
Quote:
>I am seeking to create links to excel spreadsheets using DAO and VBA.
>The links will be "linked tables."
>
>I have working code to refresh links, but that is not what I want to
>do. I also need to create them from.
>
>Can anybody point me in the right direction?
>
>Thank you,
>Charles
|
Well I have isolated the problem. It was with some of the sheet names
within the spreadsheet ending with a space and access not allowing the
last character in the field to be a space?
How can I get access to allow the last character in the field to be a
space?
Is there a way to read all of the sheet names from and excel file?
