<div>
You can use this Add-In for excel, much easier to change linked tables/pivot tables with it. <br />
<br />
<a href="http://www.contextures.com/xlPivotPlayPlus01.html" rel="ugc">http://www.contextures.com/xlPivotPlayPlus01.html</a>
</div>


You can use this Add-In for excel, much easier to change linked tables/pivot tables with it.

http://www.contextures.com/xlPivotPlayPlus01.html [http://www.contextures.com/xlPivotPlayPlus01.html]

<div>
It's often just as easy to delete the Linked table and re-create using Files, Get External Data... and follow the wizard.
</div>


It's often just as easy to delete the Linked table and re-create using Files, Get External Data... and follow the wizard.

<div>
GRayL I know but unfortunately there &nbsp;are more tables, moreover daily changing file names like file2904.xls so also would like to build a logic in vba to follow those changes with the link<br />
<br />

</div>


GRayL I know but unfortunately there  are more tables, moreover daily changing file names like file2904.xls so also would like to build a logic in vba to follow those changes with the link



<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
I have an excel table linked to Access database, in the table properties it appears like this below:<br />
<br />
Excel5.0;HDR=YES;IMEX=2;DA<wbr />TABASE=D:\<wbr />Folder\rou<wbr />ting.xls;T<wbr />ABLE=Routi<wbr />ng_PLF5_01<wbr />15$<br />
<br />
Of course but this can not be changed in table Design View, can you please advise could it be changed by VBA code?<br />
<br />
For example I would like to have the file linked from C:\My documents<br />
<br />
thanks,
</div>
</div>


Dear Experts,

I have an excel table linked to Access database, in the table properties it appears like this below:

Excel5.0;HDR=YES;IMEX=2;DATABASE=D:\Folder\routing.xls;TABLE=Routing_PLF5_0115$

Of course but this can not be changed in table Design View, can you please advise could it be changed by VBA code?

For example I would like to have the file linked from C:\My documents

thanks,

VBA Access 2000 - Modify linked table path with VBA code

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.