vbtu
asked on
excel 5.0 VBA
Hi:
I have GUI in one Excel workbook. In one sheet there is button. Users can click button to open a xls file, hide it and come BACK to this sheet. I do not know the name of xls file , so OPEN methode can NOT be used.
In Office 97 it is easy question. But now I have to use Excel 5.0. Any good ideas?
I have GUI in one Excel workbook. In one sheet there is button. Users can click button to open a xls file, hide it and come BACK to this sheet. I do not know the name of xls file , so OPEN methode can NOT be used.
In Office 97 it is easy question. But now I have to use Excel 5.0. Any good ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This is how you access the sheet you want to pass as parameter...
ActiveWorkbook.Worksheets(