ExcelBanter - setting a file with variables

well, i was close!
:)
susan

John Bundy (remove) wrote:
You need to take quotes out of this
FName = "MyPath&MyFile"
like
FName = MyPath & MyFile
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.

"timmulla" wrote:

Can anyone help me with the following code. I'm having trouble setting the
FName variable using two other variables (MyPath and MyFile.

MyPath variable
"C:\Documents and Settings\tmullady\Desktop\"

MyFile Variable
contents in cell B3 in my spreadsheet

The end result should be the FName variable should create the proper file
path.

Public Sub Testing()

Dim MyFile As String
MyFile = Cells(3, 2).Text
Dim MyPath As String
MyPath = "C:\Documents and Settings\tmullady\Desktop\"

Dim FName As String
Dim FNum As Integer
Dim Rng As Range
FName = "MyPath&MyFile"
FNum = FreeFile
Open FName For Output Access Write As #FNum
Print #FNum, Range("B3").Text
For Each Rng In Range("B5:B10")
Print #FNum, Rng.Text
Next Rng
Close #FNum

End Sub

Any help would be appreciated
--
Regards,

timmulla