Open Workbook from Input

[Bodie_D]

Hello. I'm an old-timer (retired) and am going to try and learn some programming.
Not sure that's possible for someone over 60 with no programming experience.
I have a beginners book coming from Amazon tomorrow.

I'm trying to open an Excel file on my desktop with VBA.

Here's my simple code which doesn't work.

Sub Test_Open()

Dim Team As String

Team = InputBox("enter team")

Workbooks.Open "C\Users\Bodie\Desktop\Team.xlsx"

End Sub

Appreciate any help. Thank you.......Bodie

 

[Candyman8019]

Assuming the name of the file is not "team.xlsx" and will be whatever the user entered.xlsx?
taking a stab in the dark here...Try:
Workbooks.Open "C\Users\Bodie\Desktop\" & Team & ".xlsx"

 

[Bodie_D]

The error box read 'file not found", but thanks for the respone, CM

The code you gave me seems logical.

 

[Candyman8019]

The file will need to exist in advance of opening it.

 

[Fluff]

Hi & welcome to MrExcel.
Whar is the name of the file & what exactly are you typing into the inputbox?

 

[Bodie_D]

Hey CM and Fluff.

The name of the file is atl.xlsx

Its on my desktop.

i'm typing atl into the input box.

I'm pretty sure I have my path correct.

Thanks.....Bodie

 

[Candyman8019]

I just noticed, you'll need a colon : after the C...ie c:\users...

 

[Bodie_D]

Hey good catch, CM.

I put the colon in and it worked!

Thank you and Fluff for your help.

Looking forward to getting my beginners book tomorrow.

 

[Fluff]

Glad we could help & thanks for the feedback.