Hi,
I have a mod. file that i would like to see aplied to multiple instances. Each instance I have is in the same excel file but it a diferent sheet.
For each instance there is information like the number of edges, and edge list, the number of nodes, etc.. So the dat. file for each sheet would't be exactly the same. For instance, for two diferent sheets the dat. files would be:
1.
ne from SheetRead(sheet, "'Lpr-a-02'!B10");
np from SheetRead(sheet, "'Lpr-a-02'!B11");
nv from SheetRead(sheet, "'Lpr-a-02'!B2");
e from SheetRead(sheet, "'Lpr-a-02'!N3:O93");
tolpar=0.05;
tolbal=0.1;
b from SheetRead(sheet, "'Lpr-a-02'!S3:U93");
d from SheetRead(sheet, "'Lpr-a-02'!R3:R93");
2.
SheetConnection sheet("V4.xlsm");
ne from SheetRead(sheet, "'Lpr-a-01'!B10");
np from SheetRead(sheet, "'Lpr-a-01'!B11");
nv from SheetRead(sheet, "'Lpr-a-01'!B2");
e from SheetRead(sheet, "'Lpr-a-01'!N3:O49");
tolpar=0.05;
tolbal=0.1;
b from SheetRead(sheet, "'Lpr-a-01'!S3:T49");
d from SheetRead(sheet, "'Lpr-a-01'!R3:R49");
I was wondering if there was a way i could do this without having to write the dat file to every single instance.
Thank you!
------------------------------
Beatriz Santos
------------------------------
#DecisionOptimization