Writing cell reference to external workbook with VBA

[knutfh]

I need to reference some cells in other workbooks, to build a trend of some values that change.
To do this, I would like to use vba to write a simle reference formula to a given cell.

I've come to the point where i use this code:

Please Login or Register  to view this content.

To get the following (example) result in the destination cell: C:\Users\konhenknu\Desktop\SPOC_log_dev\SPOC_log\[SPOC_log_2013_3.xlsm]Stopp Pr dag!$U$34

Now all I need is to get this to become: (notice the characters highlighted in red)
='C:\Users\konhenknu\Desktop\SPOC_log_dev\SPOC_log\[SPOC_log_2013_3.xlsm]Stopp Pr dag'!$U$34

I manage to get the last single quote in, but not the start of the formula.

Here is the whole sub, in context:

Please Login or Register  to view this content.

Any help would be immensely appreciated!

Best regards,
Knut

[knutfh]

I found a solution after redoing my approach.

Please Login or Register  to view this content.