VBA File location & File Name

[help_for_excel]

Hi,

My question is:
Log is range in excel, where user comes and pastes file location in excel with file name and extension then below code runs perfectly
Open (Range("log")) For Output As #iFileNo

but I want to user to only mention location and I want to provide file name and extension from vba then below line of code does run as above
Open (Range("log" & "& error.txt")) For Output As #iFileNo

can any one tell me, how to merge file location provided by user and file name and extension from vba.

 

[jonhaus]

Try This. I looks like it was probably getting confused because string was included within the range function.

Open (Range("log") & "error.txt") For Output As #iFileNo

-jonhaus
Click here for more help with Excel and VBA

 

[help_for_excel]

thank you so much, it worked