Inderect.Ext or copy -- Combobox
 

Hi
I have try to use Inderect.ext diect in a combo box it dosn't work
so i belive i shall have a copy off the sheet where the data are
but this file are close.
Can't i i some way every time i open my file have a makro there take a copy
off the sheet in the close file and replace it in my open file.
So i can use it with my combobox

alvin

Inderect.Ext or copy -- Combobox
 

Yes, you can put such code in the workbook_open event

http://www.cpearson.com/excel/events.htm
Chip Pearson's site with a page on events.

--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
Hi
I have try to use Inderect.ext diect in a combo box it dosn't work
so i belive i shall have a copy off the sheet where the data are
but this file are close.
Can't i i some way every time i open my file have a makro there take a
copy
off the sheet in the close file and replace it in my open file.
So i can use it with my combobox

alvin

Inderect.Ext or copy -- Combobox
 

Okay thanks
But what about the code to copy the sheet, i'm not good to this

Alvin


"Tom Ogilvy" skrev:

Yes, you can put such code in the workbook_open event

http://www.cpearson.com/excel/events.htm
Chip Pearson's site with a page on events.

--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
Hi
I have try to use Inderect.ext diect in a combo box it dosn't work
so i belive i shall have a copy off the sheet where the data are
but this file are close.
Can't i i some way every time i open my file have a makro there take a
copy
off the sheet in the close file and replace it in my open file.
So i can use it with my combobox

alvin

Inderect.Ext or copy -- Combobox
 

Turn on the macro recoder

Open the workbook, copy the sheet, close the workbook

Turn off the macro recorder.

Put code like that in you workbook_open event. surround it with

application.ScreenUpdating = Fasle

'code you recorded

application.ScreenUpdating = True

--
Regards,
Tom Ogilvy


"Alvin Hansen" wrote in message
...
Okay thanks
But what about the code to copy the sheet, i'm not good to this

Alvin


"Tom Ogilvy" skrev:

Yes, you can put such code in the workbook_open event

http://www.cpearson.com/excel/events.htm
Chip Pearson's site with a page on events.

--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
Hi
I have try to use Inderect.ext diect in a combo box it dosn't work
so i belive i shall have a copy off the sheet where the data are
but this file are close.
Can't i i some way every time i open my file have a makro there take a
copy
off the sheet in the close file and replace it in my open file.
So i can use it with my combobox

alvin

Inderect.Ext or copy -- Combobox
 

Thank you for your help

Regards alvin


"Tom Ogilvy" skrev:

Turn on the macro recoder

Open the workbook, copy the sheet, close the workbook

Turn off the macro recorder.

Put code like that in you workbook_open event. surround it with

application.ScreenUpdating = Fasle

'code you recorded

application.ScreenUpdating = True

--
Regards,
Tom Ogilvy


"Alvin Hansen" wrote in message
...
Okay thanks
But what about the code to copy the sheet, i'm not good to this

Alvin


"Tom Ogilvy" skrev:

Yes, you can put such code in the workbook_open event

http://www.cpearson.com/excel/events.htm
Chip Pearson's site with a page on events.

--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
Hi
I have try to use Inderect.ext diect in a combo box it dosn't work
so i belive i shall have a copy off the sheet where the data are
but this file are close.
Can't i i some way every time i open my file have a makro there take a
copy
off the sheet in the close file and replace it in my open file.
So i can use it with my combobox

alvin