I need to copy a number of sheets from other workbooks into one workbook.
For ease of identification I name each worksheet by its workbook.name
property.
Thus the copied sheets appear as "name.xls".
I would like to get rid off the .xls in the name.
I am able to do this by the following function
Do Until Mid(t, j, 1) = "."
y = y + Mid(t, j, 1)
j = j + 1
Loop
Since the workbook name changes as many times as I copy sheets.
I need to assign variable t = workbook.name property
I don't know what type of variable I need to declare.
I have tried variant etc but nothing works.
I have also tried to put [workbook.name]
Most of the time i get an error message that says that i require an object.
Am I on the right track? Can someone help?