Can you push data..........? 1

[JamieArvato]

I have a sheet which on Open is refreshing an External data source...

Is there a way I can be in the external data source and push the refresh into the other file ?

 

[xlbo]

depends on what the external data source is - if it exposes itself to VBA then you most certainly can.

Rgds, Geoff

Yesterday it worked. Today it is not working. Windows is like that.

Please read FAQ222-2244 before you ask a question

 

[fredericofonseca]

Yes, but it will depend on the external data source.

If you are dealing with a Database that allows access to COM objects, or to ODBC/OLEDB databases then yes you can.
Otherwise it may not be possible.

More details of your set-up required

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[JamieArvato]

This sounds hopeful.

They are both Excel sheets, many sheets draw in a list from 1 central sheet.

I don't like linking files.

 

[xlbo]

In which case - certainly

2 methods spring to mind - the 1st would use ADO / DAO to create a recordset object which would then be read into each file in turn
- the advantage of this would be that you only need to run the query once

The 2nd method would be to utilise the ODBC queries you currently have and run them in turn, using the central sheet as the control and looping through each file in turn, running the query - this would cause overhead however as you could be running the same query many times


Rgds, Geoff

Yesterday it worked. Today it is not working. Windows is like that.

Please read FAQ222-2244 before you ask a question

 

[JamieArvato]

Method one sounds like the answer, where can I go to learn this ?

 

[xlbo]

type ADO or DAO in VBA help or google either should come up with a plethora of examples

key words / functions / methods are:
Recordset
BOF
EOF
Database
Workspace
OpenRecordset
CopyFromRecordset

Rgds, Geoff

Yesterday it worked. Today it is not working. Windows is like that.

Please read FAQ222-2244 before you ask a question

 

[xlbo]

oh and I forgot a couple of keywords

Connection
ADOConnection

Rgds, Geoff

Yesterday it worked. Today it is not working. Windows is like that.

Please read FAQ222-2244 before you ask a question