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
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