Hi All,
I have macro code which will pull excel file from a relative path specified in code shown below
Set Wkb2 = Workbooks.Open( Filename:=ThisW orkbook.Path & "\Input\Manpowe r_Master_Foreca st_10_BNPPISPL. xls")
Wkb2.Activate.
But i got requirment like when macro runs it has to ask input filename to be enter by user based on which it has to pull data from that file.
Please if any one haveing any idea or code share with me. Is it possible to give popup bot at file path.
Thanks in Advance
Teja
I have macro code which will pull excel file from a relative path specified in code shown below
Set Wkb2 = Workbooks.Open( Filename:=ThisW orkbook.Path & "\Input\Manpowe r_Master_Foreca st_10_BNPPISPL. xls")
Wkb2.Activate.
But i got requirment like when macro runs it has to ask input filename to be enter by user based on which it has to pull data from that file.
Please if any one haveing any idea or code share with me. Is it possible to give popup bot at file path.
Thanks in Advance
Teja