Link Tables

  • Thread starter hyperionaxa via AccessMonster.com
  • Start date
H

hyperionaxa via AccessMonster.com

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
 
J

Jeff Boyce

I may be missing something, but since you apparently don't need to save the
"old" Excel file, why not just replace the "old" one with the new one,
giving it the same name. That way, Access wouldn't have to look for
anything new...

Or maybe I really am missing something!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Ð

Ðндрей БрынÑких

hyperionaxa via AccessMonster.com said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking data in MS Word into Excel 5
Adding data to MS Access from csv file 0
List all tables, including document structure 0
Embed the same Excel multiple times 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Using checkbox to change cell color 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Automation of scanned file storage based on content 0

Top