Use a button to open a specific workbook

[kevinboo]

Hi Guys.... hows things?

Can anyone help please?

I would like to place a button on a worksheet, that when pressed, finds and opens a specific workbook from my drive.

If possible I would like this button to 'float' i.e always be in view on the said worksheet no matter where I am or move to on the sheet.

Please bear in mind when answering, I am a relative novice on X/L and do not know how to associate buttons with actions or make them 'float' (If this is possible) so please be gentle with me.....Anybody?

 

[Krishnakumar]

Hi,

Here is an Add-In

 

[kevinboo]

Khrisnakumar

ManyThanks.. I can use this at home, but unfotuantley not at work. I cannot donwload it through the company server or install it by any other means as my workstation has no drives only my connection to the company server.

Any more help out there please ???? ????

 

[ellin00ra]

Workbooks.Open FileName:="D:\Test\CarlR.xls"

 

[Krishnakumar]

Hi,

I would like to place a button on a worksheet, that when pressed, finds and opens a specific workbook from my drive.

as my workstation has no drives

???????

Anyway, I can't help you more.

 

[kevinboo]

Kris

It should have read 'from a specific folder located on a specific drive.

This folder being my personal folder on the company drive which is physically located in the U.S.A as you can see I am in the U.K.

Thanks anyway, as I said I can use it at home..

Regrads... Kevin

 

[kevinboo]

Workbooks.Open FileName:="D:\Test\CarlR.xls"

Ellin..

Can you elaborate on this please ??? ???

Regards : Kevin