For the past few days I've been trying to figure a way to customize code which retrieves data from closed workbooks. The example code applies to 2 rows and I need it to apply to many more (the 2 rows are working correctly). This is the first time using Visual Basic and as much I've researched I can't understand how to fix my problem.The code is as follows and was from the getvalue file located athttp://www.interactiveds.com.au/software.html. The code currently retrieves 13 columns and 2 rows of data, I need to be able to change the rows to any number I need. It'd also be helpful to know how to changes the column number, though I am currently ok with the 13. Can anyone please assist? My current code is as follows:
Bookmarks