Forum Discussion
Solved
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...
- Formula 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.
Thank you.
And how could I export all formulas into a text file?
It is a matter of VBA reading cell by cell and copying what has been typed, I guess.
Thank you.
Regards.
And how could I export all formulas into a text file?
It is a matter of VBA reading cell by cell and copying what has been typed, I guess.
Thank you.
Regards.
Formula 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.
- Great. Thank you so much, Rajesh-S.
I shall do so.
I have marked your answer as the best.
Have a good week!- Glad to help you,,, being a freelancer I'm also undertaking projects ,, basically for Data Analysis,, in case of any help please do write to me & keep asking ☺