Veda2.0 Released!


Poll: Do you use VBA code in Veda input files?
You do not have permission to vote in this poll.
No.
71.43%
5 71.43%
Yes, but it does not interact with FILL tag output.
28.57%
2 28.57%
Yes, and VBA interacts with FILL tag output.
0%
0 0%
Total 7 vote(s) 100%
* You voted for this item. [Show Results]

VBA code in Veda input files
#1
Question 
Dear users,

Veda has been using functions from the local Excel installation to work with the files. This creates some vulnerability due to the increasingly wide variety of Excel installations. We are considering using an alternative, which is much faster and doesn't rely on the local Excel application. The only downside is that this library doesn't support VBA code. So, Veda will not be able to refresh files that have any VBA code.

The only case where this really makes a difference is when these files also have FILL tags, because Veda refreshes Excel files only after writing FILL tags (and for parameteric scenarios). If the VBA code does not interact with the output of FILL tags then it would be possible for users to reconfigure the data declarations and tolerate this limitation. But this approach will not work if the VBA code interacts with the output of FILL tags.

I have used VBA code in several cases but always for text processing. I do not have a single case where it interacts with FILL tag output.

We would like to know the kind of role VBA plays in Veda input files for other users. Please respond to this poll, so that we can take an informed decision. We will make a beta version available for testing very soon.

Thanks,
Amit
Reply
#2
> If the VBA code does not interact with the output of FILL tags then it would be possible for users to reconfigure the data declarations and tolerate this limitation.

Could you elaborate on this?  How extensive would be the tasks that would be required for users to reconfigure the data declarations (which according to the above, would seemingly be needed for tolerating the limitation when VBA code does not interact with the output of FILL tags)?
Reply
#3
The FILL tag and related tables would need to be moved to a file without VBA.
Reply
#4
Ahh so, I see, thanks.
In other words, the whole Excel file becomes unreadable for the library, if it includes any VBA?
Would *.xlsm files with Fill tables (without VBA) still be readable for the library?
Reply
#5
There is no problem reading files that have VBA. Basically, this library cannot *run* VBA. So, files with VBA cannot be recalculated with this library. Veda2.0 recalculates files only after writing in them, which is only for FILL tags (apart from parametric scenarios).
Reply
#6
But I think you said that even VBA that is not used for calculating anything that needs to recalculated when processing FILL tables would not work, and any such file would no longer work, even if there is no VBA interaction?  Sorry for being slow understanding why that is so...
Reply
#7
You are not slow Smile This is a good point. The thing is that once we instruct this library to recalculate, it reports errors in the cells that call VBA code. We have written to the developers to see if they can leave the VBA cells alone while recalculating.
Reply
#8
Beta version will be available later today
Reply
#9
Here is a Beta version for testing: Dropbox link (download)
Reply
#10
Personally I like the idea. I've just tested the beta version on TIM (https://github.com/esma-cgep/TIM/tree/7e...b090d8feb6). I have not noticed any processing speed improvements, but can confirm that this issue (https://github.com/kanors-emr/Veda2.0-In.../issues/22) is gone.
Reply
#11
Big Grin 
I've just tested a bit the latest version (3.0.2) and I can definitely see performance improvement for the Excel file reading.
Thus far this looks good, congrats!  Cool
Reply
#12
Thanks Antti Smile

Not using the locally installed Excel libraries is also a huge improvement. Excel installation is no longer a prerequisite for Veda. We have removed Excel from Veda online servers.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Is there a way to adjust to the VTrun.cmd file generated when pressing solve in Veda? kristofferand 24 8,119 22-05-2024, 09:20 AM
Last Post: AKanudia
  TFM_UPD could not be input xiao.li8@mcgill.ca 5 475 07-05-2024, 11:07 PM
Last Post: xiao.li8@mcgill.ca
  GDX diff fails to find GAMS in VEDA vincedh 2 300 19-04-2024, 06:41 PM
Last Post: vincedh
  Batteries input capacity constraint juan.correalaguna@vito.be 5 722 05-04-2024, 06:00 PM
Last Post: Antti-L
  Veda online not solving. Getting veda 2.0? frangb99 0 171 17-03-2024, 11:52 PM
Last Post: frangb99
  VEDA Run Manager Module UgurHalden 1 379 21-02-2024, 05:14 PM
Last Post: Ravinder
  Optimization problem: TIMES code caicedoeng 1 344 12-02-2024, 11:32 AM
Last Post: Ravinder
Photo Installing VEDA in a server without internet acess sergio.vargas.cbba 1 270 06-02-2024, 04:24 PM
Last Post: Ravinder
  Run Manager - Base files Dmytror 5 930 31-01-2024, 03:58 PM
Last Post: Ravinder
  Constraining input shares LucasD 3 776 04-01-2024, 09:33 PM
Last Post: LucasD

Forum Jump:


Users browsing this thread: 1 Guest(s)