Please I i'm not good to this so..........

I have this
Private Sub Workbook_Open()
Run (GetData_Example1)


End Sub
Is a macro i will have running every time i open the workbook

But this is not the way so if some one will answer me then please do it so i
can understand it.
Thank you

Alvin

Hi
there have you put this macro? It has to go in your workbook module!

--
Regards
Frank Kabel
Frankfurt, Germany


Alvin Hansen wrote:
Please I i'm not good to this so..........

I have this
Private Sub Workbook_Open()
Run (GetData_Example1)


End Sub
Is a macro i will have running every time i open the workbook

But this is not the way so if some one will answer me then please do
it so i can understand it.
Thank you

Alvin

It is in a module call
macroexamples

Alvin



"Frank Kabel" skrev:

Hi
there have you put this macro? It has to go in your workbook module!

--
Regards
Frank Kabel
Frankfurt, Germany


Alvin Hansen wrote:
Please I i'm not good to this so..........

I have this
Private Sub Workbook_Open()
Run (GetData_Example1)


End Sub
Is a macro i will have running every time i open the workbook

But this is not the way so if some one will answer me then please do
it so i can understand it.
Thank you

Alvin

Hi
and as Ron stated in your other thread it has to go in the workbook
module (called 'ThisWorkbook' in the VBA project bexplorer)

--
Regards
Frank Kabel
Frankfurt, Germany


Alvin Hansen wrote:
It is in a module call
macroexamples

Alvin



"Frank Kabel" skrev:

Hi
there have you put this macro? It has to go in your workbook module!

--
Regards
Frank Kabel
Frankfurt, Germany


Alvin Hansen wrote:
Please I i'm not good to this so..........

I have this
Private Sub Workbook_Open()
Run (GetData_Example1)


End Sub
Is a macro i will have running every time i open the workbook

But this is not the way so if some one will answer me then please
do
it so i can understand it.
Thank you

Alvin

Hi
I know why it dosn't work
I open ecxel first and then i open the filw(workbook)
If i open the fil(worbook) whitout open excel first then is working

Thanks

Alvin


"Frank Kabel" skrev:

Hi
there have you put this macro? It has to go in your workbook module!

--
Regards
Frank Kabel
Frankfurt, Germany


Alvin Hansen wrote:
Please I i'm not good to this so..........

I have this
Private Sub Workbook_Open()
Run (GetData_Example1)


End Sub
Is a macro i will have running every time i open the workbook

But this is not the way so if some one will answer me then please do
it so i can understand it.
Thank you

Alvin

Hi

See your other thread Alvin

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Alvin Hansen" wrote in message ...
Please I i'm not good to this so..........

I have this
Private Sub Workbook_Open()
Run (GetData_Example1)


End Sub
Is a macro i will have running every time i open the workbook

But this is not the way so if some one will answer me then please do it so i
can understand it.
Thank you

Alvin

Hi again
Please see he

This working:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
GetData_Example1
End Sub

This Working:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
GetData_Example1
End Sub

This not working:

Private Sub Workbook_Open()
GetData_Example1
End Sub

BEst regards alvin

"Ron de Bruin" skrev:

Hi

See your other thread Alvin

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Alvin Hansen" wrote in message ...
Please I i'm not good to this so..........

I have this
Private Sub Workbook_Open()
Run (GetData_Example1)


End Sub
Is a macro i will have running every time i open the workbook

But this is not the way so if some one will answer me then please do it so i
can understand it.
Thank you

Alvin