ChangeLink with variable new name

Hi,

I set up a userform that lists the content of a folder in a combobox.
I want to use the value selected by the user in the combobox as the name of the new file in a change link function.
I am getting an error Method ChangeLink of object workbook failed.

Here is the OK command in the form to trigger the ChangeLink:

Please Login or Register  to view this content.

I had declared the BBVariant as public as follows:

Please Login or Register  to view this content.

Here is the ChangeLinks sub

Please Login or Register  to view this content.

Of course, if I leave the on error resume next in, then I don't get the error message but the link is not updated.

Many thanks for your help.

Dee

I managed to get my code to work.

Instead of using the variable BBVariant, I used the following in the ChangeLink :

Please Login or Register  to view this content.

Why could not I store the result of the combobox selection as a variable and re-use it in the ChangeLink formulae ?

I would be SO grateful if somebody could explain this.

Dee