Running Macro's after Refreshing data

[Bmistry]

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

[K Dales]

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

[Bmistry]

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

[N10]

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" <[email protected]> wrote in message
news:[email protected]...
> 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