-
Open Excel Spreadsheet
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.
-
[vba]
Set xlApp = CreateObject("Excel.Application")
Set xlWB = xlApp.Workbooks.Open(cfsource)
'xlWB is now an Excel workbook object that you can manipulate
[/vba]