sebas1102
06-19-2006, 08:26 PM
Hi all,
I have a number "3059-006" in cell A1 , "Q5/1.2" in cell B1.
I need to sift out "3059-" form A1 and "Q5" from B1 so that i can assign
ExcelFileName= 3059-Q5.
Workbook = "ExcelFileName.xls"
If Not WorkbookOpen(Workbook) Then
Workbooks.Open "c:\project\" & Workbook
End If
Is it Possible? Thanks in Advance!
I have a number "3059-006" in cell A1 , "Q5/1.2" in cell B1.
I need to sift out "3059-" form A1 and "Q5" from B1 so that i can assign
ExcelFileName= 3059-Q5.
Workbook = "ExcelFileName.xls"
If Not WorkbookOpen(Workbook) Then
Workbooks.Open "c:\project\" & Workbook
End If
Is it Possible? Thanks in Advance!