| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use excel vba to specify the path of a link table in access
In an access database, I have a link table linking to an external text
file. What i want to do is to specify the path of that text file in vba code in an excel file. I noticed there is a way to do it in a module in access vba, but i don't know how to do it in excel vba. Any help would be greatly appreciated. Thanks a lot. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to use excel vba to specify the path of a link table in access
Show us how you'd do it in Access VBA. I'm betting it's much the same. Post
what you have and we can assist. Barb Reinhardt "MCI" wrote: In an access database, I have a link table linking to an external text file. What i want to do is to specify the path of that text file in vba code in an excel file. I noticed there is a way to do it in a module in access vba, but i don't know how to do it in excel vba. Any help would be greatly appreciated. Thanks a lot. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make the Embedded Excel file link to the table of Access | Links and Linking in Excel | |||
| How do I link Excel to a dynamically column named access table? | Excel Programming | |||
| Link an excel sheet to access table with pics | Excel Discussion (Misc queries) | |||
| Link Access table to Excel worksheet | Excel Discussion (Misc queries) | |||
| How To Link To An ACCESS Table | Excel Programming | |||
Hybrid Mode
