I'm trying to link in data from a particular source...here's my code in my macro:

Sub test()

Dim test As String
test = "='I:\MANAGEMENT\Lucent Reporting\04\04-01\[04-01.xls]322'!F2"

Sheets("Sheet1").Select
Range("A1").Select
ActiveCell.FormulaR1C1 = test

'
End Sub

But when I run the macro, cell A1 has an error and the contents are:

='I:\MANAGEMENT\Lucent Reporting\04\04-01\[04-01.xls]322'!'F2'

As you can see, there are tick marks around the cell reference ('F2') and when I take out the tick marks, the thing works fine.

Any help is appreciated!