View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
eggpap eggpap is offline
external usenet poster
 
Posts: 29
Default linking external data

hello,

how can I link external data (from Access tables) without referring the
DataSource to a fixed path, but to the Workbook path by VBA code?

Now I refer to a fixed path (e.g. C:\P1) containing the workbook and the mdb
files and the workbook refreshes the data external links at the opening, but
if the workbook is installed in another directory the refreshment process
fails or asks parameters that confuse the user.

Emiliano