Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Grabbing a value from another workbook
Thanks for the quick response, Skip. Unfortunately, it still didn't work. To be honest, I didn't even mean to put .xls at the end of my worksheet name. As I understand it, Cells is a property, not an object; does .Value still work? That's why I originally tried to use ValueRange as an...- jernigan
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Grabbing a value from another workbook
I'm convinced I'm screwing up something really basic, but I'm trying to take a value from a cell in another workbook based on a variable range. This is a macro for a worksheet called "Gholson" in a workbook called "DataMine". I know this isn't the simplest code, but I just...- jernigan
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Importing data from an open program into excel
I have a program with spreadsheet-style data about mutual funds, but it does not have export capabilities. I'd like to distill some of the info, but I cannot create any kind of file that Excel can read. With ExcelXP, is there any way to import data from this program, similar perhaps to the...- jernigan
- Thread
- Replies: 0
- Forum: Microsoft: Office
