Re: Link Tables

"hyperionaxa via AccessMonster.com" <u41306@[EMAIL PROTECTED]
>
сообщил/сообщила в новостях 
следующее: news:82dbb504f5001@[EMAIL PROTECTED]
> Hi All
>
> I am new to the VBA hence don't understand all the jargon. I have an 
> access
> database which has one of the tables linked to an excel spreadsheet
which
> changes every month ( I mean the name of the file, not the location).
What 
> I
> am looking for is, if possible please, can I have a code to re-link the
> tables to the excel spreadsheet with a prompt to find the new file. I 
> don't
> need to save this file any where else, as it is already saved on our 
> network.
> Pleaseeeeeeeeeeeeeeeee bear in mind I dont understand VBA jargon so if
you
> asked me to copy and paste and code, along with that please also tell me

> how
> and where to do that (MODULE, MACRO OR FORM). I am really very
desperate, 
> as
> I have been looking on the web for last 3 days. 
> Pleaseeeeeeeeeeeeeeeeeeeeeeee
> Helppppppppppppppppppppppppppp.
>
> Thanks in advance.
>
> Chris
>
> -- 
> Message posted via http.com
>
>