Hi
I would like to start a macro which open another excelfile, by clicking a
commandbutton.
Thanks for your help
KentÄ

drag a commandbutton to the worksheet.

double click on it

Private Sub Commandbutton1_click()
Workbooks.Open "C:\Myfolder\MyFile.xls"
End Sub

return to Excel

take the sheet out of design mode by clicking on the icon in the upper left
corner of the Control Toolbox Toolbar (which should appear depressed since
the sheet is in design mode)

--
Regards,
Tom Ogilvy


"KentÄ" wrote in message
...
Hi
I would like to start a macro which open another excelfile, by clicking a
commandbutton.
Thanks for your help
KentÄ

Thank's Tom
Sorry, but I want to run a macro (in Module StartUp) by clicking at the
Command Button.
The macro will open the file and execute futher commands.
Thank's for help in advance
Regards
KentÄ

"Tom Ogilvy" wrote:

drag a commandbutton to the worksheet.

double click on it

Private Sub Commandbutton1_click()
Workbooks.Open "C:\Myfolder\MyFile.xls"
End Sub

return to Excel

take the sheet out of design mode by clicking on the icon in the upper left
corner of the Control Toolbox Toolbar (which should appear depressed since
the sheet is in design mode)

--
Regards,
Tom Ogilvy


"KentÄ" wrote in message
...
Hi
I would like to start a macro which open another excelfile, by clicking a
commandbutton.
Thanks for your help
KentÄ

Private Sub Commandbutton1_click()
Startup.OpenBook
End Sub

in a module named Startup

Sub OpenBook()
Workbooks.Open "C:\Myfolder\MyFile.xls"
End sub


in the workbook that will be opend (MyFile.xls), use the Workbook_Open event

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

--
Regards,
Tom Ogilvy


"KentÄ" wrote in message
...
Thank's Tom
Sorry, but I want to run a macro (in Module StartUp) by clicking at the
Command Button.
The macro will open the file and execute futher commands.
Thank's for help in advance
Regards
KentÄ

"Tom Ogilvy" wrote:

drag a commandbutton to the worksheet.

double click on it

Private Sub Commandbutton1_click()
Workbooks.Open "C:\Myfolder\MyFile.xls"
End Sub

return to Excel

take the sheet out of design mode by clicking on the icon in the upper
left
corner of the Control Toolbox Toolbar (which should appear depressed
since
the sheet is in design mode)

--
Regards,
Tom Ogilvy


"KentÄ" wrote in message
...
Hi
I would like to start a macro which open another excelfile, by
clicking a
commandbutton.
Thanks for your help
KentÄ

Thank's Tom!
It works perfect
Regards KentÄ

"Tom Ogilvy" skrev:

Private Sub Commandbutton1_click()
Startup.OpenBook
End Sub

in a module named Startup

Sub OpenBook()
Workbooks.Open "C:\Myfolder\MyFile.xls"
End sub


in the workbook that will be opend (MyFile.xls), use the Workbook_Open event

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

--
Regards,
Tom Ogilvy


"KentÄ" wrote in message
...
Thank's Tom
Sorry, but I want to run a macro (in Module StartUp) by clicking at the
Command Button.
The macro will open the file and execute futher commands.
Thank's for help in advance
Regards
KentÄ

"Tom Ogilvy" wrote:

drag a commandbutton to the worksheet.

double click on it

Private Sub Commandbutton1_click()
Workbooks.Open "C:\Myfolder\MyFile.xls"
End Sub

return to Excel

take the sheet out of design mode by clicking on the icon in the upper
left
corner of the Control Toolbox Toolbar (which should appear depressed
since
the sheet is in design mode)

--
Regards,
Tom Ogilvy


"KentÄ" wrote in message
...
Hi
I would like to start a macro which open another excelfile, by
clicking a
commandbutton.
Thanks for your help
KentÄ