Hi,

I have spreadsheet which is an extract from an access database and the data
can be refreshed automatically from the DB.

I would like the spreadsheet to carry out a number of actions once the data
has been refreshed without having the user push any further buttons. Is there
some programming i can use that will invoke a macro to run these commands as
soon as the data has been refreshed?

I'm quite new to programming so if you can provide examples of code, it
would be much appreciated!

Thanks

Bhavini

Answer depends in part on what you use to trigger the refresh. Do you have a
control (e.g. command button) to initiate a refresh, or do you have the query
refresh on file open, or do you have it set to refresh if a parameter cell
value changes?
--
- K Dales


"Bmistry" wrote:

Hi,

I have spreadsheet which is an extract from an access database and the data
can be refreshed automatically from the DB.

I would like the spreadsheet to carry out a number of actions once the data
has been refreshed without having the user push any further buttons. Is there
some programming i can use that will invoke a macro to run these commands as
soon as the data has been refreshed?

I'm quite new to programming so if you can provide examples of code, it
would be much appreciated!

Thanks

Bhavini

Hi,

The query refreshes, when the user initiates by pushing the refresh data
button under the Data menu on the main tool bar.

Thanks


"K Dales" wrote:

Answer depends in part on what you use to trigger the refresh. Do you have a
control (e.g. command button) to initiate a refresh, or do you have the query
refresh on file open, or do you have it set to refresh if a parameter cell
value changes?
--
- K Dales


"Bmistry" wrote:

Hi,

I have spreadsheet which is an extract from an access database and the data
can be refreshed automatically from the DB.

I would like the spreadsheet to carry out a number of actions once the data
has been refreshed without having the user push any further buttons. Is there
some programming i can use that will invoke a macro to run these commands as
soon as the data has been refreshed?

I'm quite new to programming so if you can provide examples of code, it
would be much appreciated!

Thanks

Bhavini

hI b

The refresh button will contain some code as click or double click event
;This code performs your refresh. It will be present as code or as a call
for some other macro.

To perform other actions after the existing code executes simply add more
code or write a seperate proceduure and then call it at the appropriate
point

as with :

Private Sub CommandButton1_Click()

code to refresh workbook

code to do what you want

End Sub

Best N10



"Bmistry" wrote in message
...
Hi,

The query refreshes, when the user initiates by pushing the refresh data
button under the Data menu on the main tool bar.

Thanks


"K Dales" wrote:

Answer depends in part on what you use to trigger the refresh. Do you
have a
control (e.g. command button) to initiate a refresh, or do you have the
query
refresh on file open, or do you have it set to refresh if a parameter
cell
value changes?
--
- K Dales


"Bmistry" wrote:

Hi,

I have spreadsheet which is an extract from an access database and the
data
can be refreshed automatically from the DB.

I would like the spreadsheet to carry out a number of actions once the
data
has been refreshed without having the user push any further buttons. Is
there
some programming i can use that will invoke a macro to run these
commands as
soon as the data has been refreshed?

I'm quite new to programming so if you can provide examples of code, it
would be much appreciated!

Thanks

Bhavini