Open Excel Spreadsheet

[Bert]

Hi I have defined a filepath in a userform.

currently set as "cfsource"

I am now trying to use this to open the relating excel spreadsheet to copy info over.

I have tried many variations but none seem to launch excel or the spreadsheet which I have also tried as its path "C:\..."

Any help would be much appreciated.

[Bob Phillips]

Set xlApp = CreateObject("Excel.Application")
Set xlWB = xlApp.Workbooks.Open(cfsource)

'xlWB is now an Excel workbook object that you can manipulate