Hey, I've been researching ways to code in C++ and manipulate excel files (i.e. read and write data). Right now I've written macros in VBA that output a .csv file that is read by my C++ program. It all works, but I'm still wondering if I can just write all my code in C++.
My question is concerning some code that I found that claims to allow manipulation of Excel using C++. The problem with the code (as far as I can tell) is that the program tries to open a .dll file and rename variables in the .dll file. From what I've read, .dll's are binary and can't be edited like a simple text file.
The full code start on page 62 of this pdf: http://www.maths.manchester.ac.uk/~ahazel/EXCEL_C++.pdf
I think the code is flawed in trying to rename variables in the .dll, which it can't do since .dll's are in binary. I don't really know, though. Here's the code that won't compile:
#import \
"C:\Program Files\Common Files\Microsoft Shared\OFFICE11\mso.dll" \
rename("DocumentProperties", "DocumentPropertiesXL") \
rename("RGB", "RBGXL")
Any ideas? Thanks.