Forum Discussion
Enrique_Garcia_Franco
Apr 06, 2021Copper Contributor
Exporting mathematical model in Excel into a script
Dear Community: I have been using Excel for modelling Chemical Process Engineering since a while ago. I find it convenient, as it is visual, easily portable and easily accessible. I was wond...
- Apr 13, 2021Formula from Excel to text file is possible to be exported/copied using VBA macro. VBA works like other programming languages,, has enough capacity also. You need to work in either way ,, read value from sheet or input through User Form,,, ultimately it needs values to be calculated.
Rajesh_Sinha
Apr 06, 2021Iron Contributor
If possible the share some sample data with us along with a few formula you have tried so far,,, & expected output ,, as TABLE & GRAPH/DASHBOARD,,, EXCEL VBA can be used to execute formula on the data in Sheets !!
Enrique_Garcia_Franco
Apr 10, 2021Copper Contributor
Sorry for my late reply.
Here follows an example on what I meant.
My goal would be to export this simple model into a text script.
Thank you.
Regards.