0

I found many tutorials for How to save text from Excel sheet but unfortunately, nothing is exactly suitable for me.

I do a soil modeling in C++ so I have a script. In the script there are soil properties for certain soil type (example in picture number 1)

Script of soil properties

So I have two Excel files that contain values for the script.

file1 file2

So basically what I need is generate to text (script) file automatically based on cell values from Excel files in this way:

enter image description here

Do you have any suggestions or some tutorials that would help me, please?

Thanks

Improve this question
3
  • Possible duplicate of Create and Write to a text file using an excel macro and VBA and stackoverflow.com/questions/11503174/… Commented Nov 22, 2019 at 9:18
  • The first one looks the same but it does not solve my situation with 2 files. I am lost. Commented Nov 22, 2019 at 11:16
  • Your question is too broad for us to help you with. You can use different workbooks like Set wb1 = Workbooks("someworkbook.xlsx") and then use it like wb1.sheets("Sheet1").range("A1").value Commented Nov 22, 2019 at 11:24
Related questions
2
How to get Excel cell value in C++
1
open excel sheet pull the value from a cell and store it as a string in vb.net
1
VBA Excel work with strings
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.