excel - Error when setting workbook variable - 2147352565 -


i have simple code runs upon initialization of userform sets few workbook , worksheet variables can used throughout rest of modules, , references can changed in 1 place if file moves. migrated workbooks desktop separate server/drive, , accordingly updated file pathways; however, when try run code message:

"run-time error '-2147352565 (8002000b)': can't move focus control because invisible, not enabled, or of type not accept focus."

this error occurs on line

set reportwkbk = workbooks("n:\ rest of file pathway here\quart_template.xlsm")

is there can happening on server/drive causing issue? if so, there can fix it? work other excel workbooks saved in same location seem have no issue being referenced, though references in workbook itself, not through visual basic.

the subscript out of range error occurs because excel workbook being referenced not open (or opening) in the same instance of excel. can reproduce error creating 2 workbooks (name 1 workbook2.xlsx) , ensuring open in separate instances of excel. run code:

sub openwkbknames()     dim wbk workbook     each wbk in workbooks         debug.print wbk.name     next     'hmm. workbook 2 not listed, lets activate , see happens.     workbooks("workbook2.xlsx").activate end sub

you avoid issue looping through names of workbooks open in this instance of excel ensure available.

i've been researching run-time error '-2147352565 (8002000b)' , found this: https://msdn.microsoft.com/en-us/library/microsoft.visualstudio.vsconstants.disp_e_badindex.aspx

apparently, vs's way of saying subscript out of range too. suspect (but have no solid proof) since code worked locally issue appeared after file migrated shared drive windows taking long time open file opens in new instance of excel. essentially, excel gets impatient , decides move on while windows completes task. base assumption on detection logic added excel 2013 (https://blogs.office.com/2013/06/03/opening-workbooks-by-running-separate-instances-of-excel/).


Comments

Post a Comment

Popular posts from this blog

jOOQ update returning clause with Oracle -

according http://www.jooq.org/doc/3.8/manual/sql-building/sql-statements/update-statement/ jooq doesn't support returning clause in update statements databases except firebird , postgres. does know, still correct oracle jooq? according oracle's documentation, oracle db supports returning clase delete, insert, or update statements. incorrect manual you're right - manual wrong , should fixed: https://github.com/jooq/jooq/issues/5470 single row update returning jooq 3.8 added support single row update .. returning statements. internally, uses callablestatement , pl/sql block of form: begin update "my_table" set "my_table"."column" = 'xyz' "my_table"."id" = 1 returning "my_table"."id", "my_table"."column" ?, ?; ? := sql%rowcount; end; the relevant issue is: https://github.com/jooq/jooq/issues/5190 multi row update returning a...
Read more

java - Warning equals/hashCode on @Data annotation lombok with inheritance -

i have entity inherits other. on other hand, i'm using lombok project reduce boilerplate code, put @data annotation. annotation @data inheritance produces next warning: generating equals/hashcode implementation without call superclass, though class not extend java.lang.object. if intentional, add '@equalsandhashcode(callsuper=false)' type. is advisable add annotation @equalsandhashcode (callsuper = true) or @equalsandhashcode (callsuper = false) ? if not added, 1 callsuper=false or callsuper=true ? the default value false . 1 if don't specify , ignore warning. yes, recommended add @equalsandhashcode annotation on @data annotated classes extend else object. cannot tell if need true or false , depends on class hierarchy, , need examined on case-by-case basis. however, project or package, can configure in lombok.config call super methods if not direct subclass of object. lombok.equalsandhashcode.callsuper = call for configuration system ...
Read more

java - BasicPathUsageException: Cannot join to attribute of basic type -

i using java 8 jpa (hibernate 5.2.1). have clause works perfectly, until introduce clause make use foreign key table values too. i getting following error: basicpathusageexception: cannot join attribute of basic type i think problem related fact have join table, , not sure how create join using join table. employee - employee_category - category model (employee.java): @manytomany(cascade = cascadetype.all, fetch=fetchtype.eager) @jointable ( name="employee_category", joincolumns={ @joincolumn(name="emp_id", referencedcolumnname="id") }, inversejoincolumns={ @joincolumn(name="cat_id", referencedcolumnname="id") } ) private set<category> categories; model (category.java): @id private string id; jpa when introduce following code, fails error above (i think problem new piece of code): join<t, category> category = from.join("id"); predicates.add(criteriabuilder.like(category....
Read more