vba - Error appears when sharing an Excel Add-in -


i´m beginner @ vba programming , i´m having difficulties regarding excel add-in. wrote macro helps solve problems have in work using solver. in machine works perfectly, when try share other computers ends closing excel. error shows refers use of solver. knows how work around that? thought needed send worksheet , add-in, hasn´t been enough now. help, below code add-in.

sub teste2() ' ' teste2 macro '  ' solverreset solverok setcell:="$k$11", maxminval:=3, valueof:=range("b3").value2, bychange:="$b$8:$e$8", _     engine:=1, enginedesc:="grg nonlinear" solveradd cellref:="$b$8", relation:=1, formulatext:="$b$8" solveradd cellref:="$b$8", relation:=2, formulatext:="$k$7" solveradd cellref:="$c$8", relation:=1, formulatext:="$c$8" solveradd cellref:="$c$8", relation:=2, formulatext:="$l$7" solveradd cellref:="$d$8", relation:=1, formulatext:="$d$8" solveradd cellref:="$d$8", relation:=3, formulatext:="$m$7" solveradd cellref:="$e$8", relation:=1, formulatext:="$e$8" solveradd cellref:="$e$8", relation:=3, formulatext:="$n$7" solveradd cellref:="$k$9", relation:=1, formulatext:="$l$9" solversolve userfinish:=true solverfinish keepfinal:=1 end sub

correction:

when try run add-in in computer, returns cannot find object , shuts down.

kindly ensure other user has enabled reference "solver" in vbe:

enter image description here

google turned first result "excel solver macro error":

http://peltiertech.com/excel/solvervba.html

this resource contains other information might helpful while working solver model in excel vba.


Comments

Post a Comment

Popular posts from this blog

c++ - CryptStringToBinary API behavior -

i seeing strange behavior cryptstringtobinary cryptography api. please see below code (config: x64 debug): #include "stdafx.h" #include <windows.h> #include <strsafe.h> #include <iostream> #include <exception> void main() { dword dwskip; dword dwflags; dword dwdatalen; //lpcwstr pszinput = l"jaaaaaecaaadzgaaakqaagdnnl1l56bwgfjdgr3rpxtqqqn6daw3usv2emkjym4t"; //this works fine lpcwstr pszinput = l"mytest"; //doesnt work, api returns false,error code 0x0000000d // determine size of byte array , allocate memory. if(! cryptstringtobinary( pszinput, _tcslen( pszinput ) + 1, crypt_string_base64, null, &dwdatalen, &dwskip, &dwflags ) ) { dword dw = getlasterror(); //0x0000000d: data invalid throw std::exception( "error computing byte length." ); } byte *pbytebyte = null; try { ...
Read more

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more

iphone - Three second countdown in cocos2d -

i trying have 3 second countdown display when level beat in game. did: -(void) gamesegmentbeat { [self pauseschedulerandactions]; // overlay game opaque background ccsprite *opaquebg = [ccsprite spritewithfile:@"background1.png"]; opaquebg.position = screencenter; [self addchild:opaquebg z:10000]; // these 3 labels 3 seconds cclabelttf *three = [cclabelttf labelwithstring:@"3" fontname:@"helvetica" fontsize:100]; three.position = ccp(screencenter.x, screencenter.y); cclabelttf *two = [cclabelttf labelwithstring:@"2" fontname:@"helvetica" fontsize:100]; two.position = ccp(screencenter.x, screencenter.y); cclabelttf *one = [cclabelttf labelwithstring:@"1" fontname:@"helvetica" fontsize:100]; one.position = ccp(screencenter.x, screencenter.y); // secondspast specified in update method secondspast = 0; if (secondspast == 1) { [self addchild:thr...
Read more