It's hard to know what more you need Teja. Do you understand the concept of relative path? In this case I'm working on the principle that you want to open other workbooks (whose filenames you already know) from the same folder as that of the currently running workbook.
ThisWorkbook.Path supplies the part that you don't have. You can use this string value to create an absolute path pointing directly to the file you require (As illustrated in Smiley's post #4). If you require the path of the workbook currently being worked upon (usually the same but may be different from the one whose code is running) then you can use
ActiveWorkbook.Path instead.
An alternative would be to use the ChDir statement to set the current working directory and then open the file giving a relative name :
- ChDir ThisWorkbook.Path
-
Set Wkb2 = Workbooks.Open(Filename:="Manpower_Master_Forecast_10_BNPPISPL.xls")
-
Wkb2.Activate
This is unusual however, as it effects other things than simply the code, and the code has all the information it needs to provide the full reference anyway.