Excel Automation
There are three initial requirements for this project:
1. use visual studio 2022 with a dialog based app using vc++2. use visual studio 2022 with a dialog based app using vc++3. use visual studio 2022 with a dialog based app using vc++
Do the following through the use of code (ie no manual entry via key board):
4. Have the app open excel (desktop not 365)5. Add a worksheet to the workbook6. Enter the following in the first work sheet:a. 1 in cell b2b. 11 in cell c37. Enter the following in the second work sheet:a. 2 in cell e2b. 22 in cell e3c. 222 in cell e48. Save the workbook to c:\demo.xlsx9. Close excel
All this must be done without using any third party libraries.
Or do what is outlined in article below
https://learn.microsoft.com/en-us/previous-versions/office/troubleshoot/office-developer/automate-excel-from-mfc-fill-data
pls no offers at this point - have a single developer in mind.
Success story sharing