VBA from Input Box select file

[jamescooper]

Hello,

I'd like to select the file from the value I have already inputted into my input box previously, this codes doesn't seem to work.

Workbooks.(" & myValue & ".xlsx").Select

Can anyone help please?

Many thanks.

 

[gallen]

not much to go on but 2 mistakes, doesn't need the period or the inverted commas:

[COLOR=#333333]Workbooks[/COLOR][COLOR=#ff0000][B].[/B][/COLOR][COLOR=#333333]([/COLOR][B][COLOR=#ff0000]" &[/COLOR][/B][COLOR=#333333] myValue & ".xlsx").Select[/COLOR]

leaving:

[COLOR=#333333]Workbooks[/COLOR][COLOR=#333333]([/COLOR][COLOR=#333333]myValue & ".xlsx").Select[/COLOR]

 

[gallen]

Also you can't use 'Select' I assume you mean Activate?

 

[jamescooper]

Also you can't use 'Select' I assume you mean Activate?

Yes, activate works thanks a lot.