AfterCalculate is missing in Excel.tli, version: Office 2003
-
I am working on Excel Automation. Application is MFC application without GUI. All callbacks work perfectly in machine where office version is 2007 but same is not working in 2003. When checking Excel.tli or tlh in both the machines, the size is different and AfterCalculate call back is missing in tli and tlh. What needs to be added to application, to make it work for both versions. This is how I imported: #import "libid:00020813-0000-0000-C000-000000000046" auto_search no_dual_interfaces \ rename("DialogBox", "excelDialogBox") \ rename("RGB", "excelRGB") \ rename("DocumentProperties", "excelDocumentProperties") \ rename("SearchPath", "excelSearchPath") \ rename("CopyFile", "excelCopyFile") \ rename("ReplaceText", "excelReplaceText") Please give me clue. Regards, KTTransfer.
-
I am working on Excel Automation. Application is MFC application without GUI. All callbacks work perfectly in machine where office version is 2007 but same is not working in 2003. When checking Excel.tli or tlh in both the machines, the size is different and AfterCalculate call back is missing in tli and tlh. What needs to be added to application, to make it work for both versions. This is how I imported: #import "libid:00020813-0000-0000-C000-000000000046" auto_search no_dual_interfaces \ rename("DialogBox", "excelDialogBox") \ rename("RGB", "excelRGB") \ rename("DocumentProperties", "excelDocumentProperties") \ rename("SearchPath", "excelSearchPath") \ rename("CopyFile", "excelCopyFile") \ rename("ReplaceText", "excelReplaceText") Please give me clue. Regards, KTTransfer.
try this one
#import \
".\MSO.DLL" \
rename("DocumentProperties","DocumentPropertiesXL") \
rename("RGB", "RGBXL")
// I changed OFFICE11 to OFFICE12, since I am using Excel 2007// Microsoft VBA Objects
#import \
".\VBE6EXT.OLB"// Excel Application Objects
#import ".\EXCEL.EXE" \
rename("DialogBox", "DialogBoxXL") rename("RGB", "RGBXL") \
rename("DocumentProperties", "DocumentPropertiesXL") \
rename("ReplaceText","ReplaceTextXL") \
rename("CopyFile","CopyFileXL") \
exclude("IFont","IPicture") no_dual_interfaces -
try this one
#import \
".\MSO.DLL" \
rename("DocumentProperties","DocumentPropertiesXL") \
rename("RGB", "RGBXL")
// I changed OFFICE11 to OFFICE12, since I am using Excel 2007// Microsoft VBA Objects
#import \
".\VBE6EXT.OLB"// Excel Application Objects
#import ".\EXCEL.EXE" \
rename("DialogBox", "DialogBoxXL") rename("RGB", "RGBXL") \
rename("DocumentProperties", "DocumentPropertiesXL") \
rename("ReplaceText","ReplaceTextXL") \
rename("CopyFile","CopyFileXL") \
exclude("IFont","IPicture") no_dual_interfacesNo its not working. AfterCalculate event is introduced in office 2007. So its not available in 2003. But is there any way to get it by including any thing in application which works for both the versions. If any idea.. . Thanks in advance. Regards, KTTransfer.
-
No its not working. AfterCalculate event is introduced in office 2007. So its not available in 2003. But is there any way to get it by including any thing in application which works for both the versions. If any idea.. . Thanks in advance. Regards, KTTransfer.