Building a filename

[cullenb]

Hello
in my code i have the following line

Workbooks.Open Filename:= _
"G:\MyDocuments\excel\abigsheet\bigsheetJan.xls"

on my sheet i have a data validation list containing the months of the year.
I would like to select from this list and have the appropriate workbook
open. However i cannot find the correct method for concatenating the
selection with the filename.

eg
Workbooks.Open Filename:= _
"G:\MyDocuments\excel\abigsheet\bigsheet" +A3 ".xls"

Can anybody tell me what the correct syntax should be?
regards
Barrie

 

[Frank Kabel]

Hi
try
Workbooks.Open Filename:= _
"G:\MyDocuments\excel\abigsheet\bigsheet" _
& worksheets("sheet1").range("A3").value _
& ".xls"

 

[Smalltalk_vb]

try &

"He" & "lp" equals Help

 

[Guest]

Try something like....

Workbooks.Open Filename:= "G:\MyDocuments\excel\abigsheet\bigsheet" & A3 & ".xls

Make sure there is a space on either side of the

Martin

 

[cullenb]

Thanks for the responses, but still no joy
In both cases it t only returns bigsheet.xls without tagging the month on at
the end.
anymore suggestions are welcome
Barrie

 

[DMeade]

You probably need to set up a string variable to capture
the month.

Dim strMonth as string

strMonth = Range("A2")

Workbooks.Open Filename:= _

"G:\MyDocuments\excel\abigsheet\bigsheet" &

strMonth & ".xls"

 

[Paul D]

Note if A3 is referring to a cell reference, rather than a variable, either
use range("A3") or put brackets around it, i.e.

Workbooks.Open Filename:= "G:\MyDocuments\excel\abigsheet\bigsheet" & [A3] &
".xls"

Paul D

 

[cullenb]

Thanks to all those who responded.
finally have it working using the string variable method from Dmeade and
also
tried it using a suggestion from Paul D which also worked.
once again thanks
Barrie