Prev: Learning excel programming
Next: txt-file is in ANSI format or OEM Character format.
From: eggpap on 19 Jul 2008 08:33
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


From: Lars-�ke Aspelin on 20 Jul 2008 04:02
On Sat, 19 Jul 2008 14:33:45 +0200, "eggpap" <eggpap(a)gmail.com> wrote:

>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
>

Use

ThisWorkbook.Path

to get the the path to your workbook

Hope this helps / Lars-�ke
From: eggpap on 20 Jul 2008 05:54
hi,

I know that statement, but I don't know how to change the data source path
programmatically.

thanks,
Emiliano

--
Se hai fretta non hai tempo
perch� il tempo non ha fretta

Emiliano
"Lars-�ke Aspelin" <larske(a)REMOOOVE.telia.com> ha scritto nel messaggio
news:s7s584dn7b20uuhn9b1m2jtivht2lnm4jt(a)4ax.com...
> On Sat, 19 Jul 2008 14:33:45 +0200, "eggpap" <eggpap(a)gmail.com> wrote:
>
>>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
>>
>
> Use
>
> ThisWorkbook.Path
>
> to get the the path to your workbook
>
> Hope this helps / Lars-�ke
>


 | 
Pages: 1
Prev: Learning excel programming
Next: txt-file is in ANSI format or OEM Character format.