| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple lookup?
Thanks you've been a great help.
"Mike H." wrote: The error will NOT come up if the file is already active in memory. The code has the isopenwb() function called before you got to the activate statement. The error is because the file is not in memory. I am not sure why that would be because the isopenwb() function should have it loaded. "Kip" wrote: Windows("vendor" & x).Activate error message!! is giving me "subscript out of range" "Mike H." wrote: This command will allow you to turn the path into a variable. Have you initial file open and then add this line instead of the one below: Use this: let FilePath=ThisWorkbook.Path Instead of this one: let Filepath="c:\temp\" 'you need to put your path here! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup across multiple columns within multiple sheets | Excel Discussion (Misc queries) | |||
| Multiple lookup values and adding multiple rates across together | Excel Worksheet Functions | |||
| Lookup using multiple sheets and multiple criteria, sorry if 2 pos | Excel Worksheet Functions | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| Lookup multiple values on multiple sheets | Excel Programming | |||
Threaded Mode
