mfc >> Excel programming

by Doug McGill » Thu, 04 Dec 2003 00:37:42 GMT

Hello I have not used visual C++ in a while. I am creating a program that
will interact with excel and word. I have two questions. 1) any good book
recommendations. 2) Where can I find the files such as excel8.h?
Thanks Doug




Similar Threads

1. closing one excel program closes all open excel programs

2. merging excel program with tdc finance program

how can i merge our excel worksheets with out tdc finance program?

3. Linking Excel columns in two different excel programs - Excel

4. Open Excel file in IE without Excel program

Does anyone know if there is a plugin available or some method to open an
Excel file in Internet Explorer on a computer that does not have an Excel
program loaded on it?



5. Losing Excel program when saving and closing different Excel docum - Excel

6. Help with calling an Excel program in a Excel cell

I wrote a function to sum up numbers I entered in Excel cell "A1" .
The program continuously sums up the numbers and clears cell "A1".
Cell "B1" is to store this summation .
I tried making the formular of cell "B1" to be the result of this
function that is making cell "B1" call this function.
See below :
Function SUMMM(A1)
Private SUM_UP
SUM_UP = A1 + SUM_UP
SUMMM(A1) = SUM_UP
Range ("A1").value = ""
End Function
 I made the formular of cell "B1" to be  : = SUMMM(A1) . It is giving
error message :#name

7. Excel Programming and Pocket Excel - Excel

8. Version of Ms Excel - using excel programming via vb 6

Hello everybody,
 
I formatted my notebook because it had problems.
Before I had Win2000 and Office 2000, now I have Win XP and Office 2003.
 
The problem is that I have various projects in which I used following VB 6 
code to open dinamically Excel and write in.
 
"..
  'I try open excel
    Set XlsApp = GetObject(, "Excel.Application") 'look for a running copy 
of Excel
    
    If Err.Number <> 0 Then 'If Excel is not running then
        Set XlsApp = CreateObject("Excel.Application") 'run it
    End If
    Err.Clear   ' Clear Err object in case error occurred.

On Error GoTo Error_Excel_Mng
  
..."
 
I have seen that recompiling (make Exe) and releasing the software on 
customer's pc having Win 2000 and especially Office 2000 my program no more 
work correctly. 
I think because the vb reference is 'Microsoft Excel 11.0 Object Library'.
 
Our helpline says that I can't install Office 2000 after  Office 2003.
 
I ask you which is the better solution that I can use.
I prefer not to return to have my laptop with previous  versions vecchie or 
to need another old pc.
 
Thank you very much.
 
Andy