Extract formula from excel file

Question

I am dotnet developer and need to extract the formula from the attached excel file which uses goalseek, XIRR and VBA. I struggled a lot to find the formula that calculates the value of the purchase price but not able to get any success.

File can be downloaded from this link : excel link

You can download and run on desktop MS-office application

Answer 1

sorry I can not download the file from dropbox.

do you want to run

solver? add-in which is a build-in .xla file made from micrsoft.

if you development with dotnet or c#,I am afraid you 'd better write the algorithm yourself rather than ran macro of VBA.

if possible upload your file here for my download.

https://wetransfer.com/upload

Answer 2

Dear Sohail_Dev,

Good day! 

Thanks for posting in Microsoft Community. 

We would love to help you on your query, considering our team mainly focuses on general and build-in query, for example, installation and activation issue of Office, and your query is about extract formula from Excel file which also involves VBA, we sincerely recommend you go to Stack Overflow Community along with any other relevant tags as there are also many experienced engineers and experts in the forums there. 

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites, or any support related to technology. 

At the same time, we will also keep this thread open, so other Community members and Experts can also share their suggestions and inputs. 

Thank you for your cooperation and understanding! Hope you keep safe and healthy always.

Sincerely,

Tina | Microsoft Community Moderator