Hi
I got this code to get the information from different workbook and different path if enters ID.
Hi
I got this code to get the information from different workbook and different path if enters ID.
Last edited by N323100; 08-10-2017 at 11:07 AM.
which workbook does this sheet belong to?
Sheet1.Cells(rSource.Row, 4).Value
in which worksheet in which workbook is this?
TextBox2.Text
Last edited by kev_; 08-01-2017 at 09:43 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Thank you for your quick response. I'm getting an error with those lines
Please Login or Register to view this content.
which workbook does this sheet belong to? - Workload.xlsx (Sheet1)
Sheet1.Cells(rSource.Row, 4).Value
in which worksheet in which workbook is this? - USERForm (ActivityTracker)
TextBox2.Text
they are in different workbook.
Perhaps
Please Login or Register to view this content.
Jindon it works perfectly thank you!!!!
Is there a way or code that the source file no needs to be open to pull the information?
Some thing like
Please Login or Register to view this content.
Last edited by jindon; 08-11-2017 at 01:29 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks