|
|
#6
03-10-2017, 03:50 PM
|
|||
|
|||
Afraid I don't know what you mean the function macro opens.
If you are referring to the debug dialogue... The only way I get the macro to error on that line is by using the wrong file path and then the debug dialogue tells me what the problem is Run-time error 1004 "J:\Manual POs\Manual PO Log\Manual PO Log2.xlsx" could not be found. When I use the file path to the file on my own computer, which I know is right, there is no error. My only guess is your file path is not right. 
|
| Tags |
| closed workbook, excel vba, object variable error |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Object Variable or With block variable not set | Raza | Excel Programming | 8 | 01-15-2015 12:19 AM |
| Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge | Berryblue | Mail Merge | 1 | 11-13-2014 05:36 PM |
 Run-time error 91 object variable or with block variable not set
|
JUST ME | Word VBA | 4 | 03-25-2014 06:56 AM |
|
Run-time error '91': Object variable or With block variable not set
|
tinfanide | Excel Programming | 2 | 06-10-2012 10:17 AM |
| XML parsing & Object variable not set (Error 91) | tinfanide | Excel Programming | 0 | 12-29-2011 08:43 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode