get data from a linked excel form.

[Fisky]

Hi,
I have a file "MatchingData" thats linked to another file "Clist" . What I'm looking for to open "MatchingData" and update from "Clist" on opening. I don't know if I can do this without opening "CList". I have a feeling that I may have to open the "CList" (Hidden), update,then close "CList".
thanks.

 

[Cronk]

You are frugal supplying information about your situation.

Assuming the file "MatchingData" is actually MatchingData.accdb and the file CList is actually CList.xlsx, and that your database has a linked table into the spreadsheet, you don't need to open the spreadsheet to read the information.

But then you'd know that already if you tried it.

 

[Fisky]

Hi Cronk, sorry about the lack of info (I'm new at vbs and forums). The "MatchingData" is MatchingData.xls aswell as the CList.xls. I've used this code (I decided to keep it simple. It refreshes data but shows CList, then closes it :

CODE:

Dim x
Dim y

Set y = Workbooks.Open ("C:\...MatchingData.xls ")
Set x = Workbooks.Open ("C:\...CList.xls")
x.Visable = False
ActiveWorkbook.RefreshAll
x.Close