VBA open Link error

[jakobt]

The following code is part of a bigger code. Gets an error when it tries to open the link?

sub openfile()

dim wb1 as workbook
dim wb2 as workbook

dim myvalue as variant
myvalue = inputbox("Example: 0219", Which period should TB be run for")

range("Z5000").value = myvalue

workbooks.open filename:""S:\JT\Report" & Myvalue & "Actuals.xlsx""

end sub

 

[igold]

Hi,

Beside the fact that this has syntax errors:

[COLOR=#333333]myvalue = inputbox("Example: 0219", Which period should TB be run for")[/COLOR]

To answer your question on the link, you are missing an equals sign "=" and have too many quotes. See if this works...

Workbooks.Open Filename:="S:\JT\Report" & myvalue & "Actuals.xlsx"