469,603 Members | 2,106 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,603 developers. It's quick & easy.

creating links to excel in vba

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
Nov 14 '06 #1
1 1376
On Tue, 14 Nov 2006 11:17:15 -0500, ChasW <wrote:
>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?
Nov 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Jeremy Langworthy | last post: by
5 posts views Thread by Guy Incognito | last post: by
4 posts views Thread by Randy | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.