I think it won't work as Office XP _requires_ the Object Library 11.0.0.0.
Quite a complex workaround would be to determine on startup, which Object Libraries from Excel are installed on the current machine and then load and use this library for excel interop.
.net 2.0 requires visual studio 2005 (or one of its express-versions like vb 2005 express).
with the 2003 version you can't use the new framework. i read about a quite dirty hack to get the new fw work with 2003 but am not sure if it works and i definitly would not suggest it.
you need not "create a workbook". after the new Workbook-Call you have a workbook. you only need to save it with the desired name.
for writing data in a cell, you have to access it via worksheet, e.g. wb.Sheets(1) is the first worksheet.
wb.Sheets(1).Range("A5").Value = "theName"
writes...
Found the reason! Our printer configuration was f***ed up and therefore impromptu was not able to create the preview and to export the result as excel with format!
Hello!
I got a problem with some Impromptu installations in my company.
When I open any report (no matter what kind, size, etc.) data is processed but the result is not shown in the impromtpu-window. The window is white and it seems like impromptu is hanging.
When I save the (invisible)...
Are you working with VS 2005 or VS.NET? In VS.NET there is no .Designer.cs but all the generated code is in the cs-file of your Form.
In fact you only have to search for the pattern in all you source-files
I once used the SplitContainer and a Button. When clicking the button ( || in my graph) the visibility of SC1 (SplitContainer.Panel1) changes. As extension you can also implement the mouse over-Event of the button so you need not click the button but only hover over it with the mouse to change...
Open the File which contains ".Designer.cs" and search for the pattern "List2.SelectedIndexChanged += "
In this line the EventHandler for List2 (if its the correct name) is assigned. Change it and everything should be fine
Hello!
You can quite easily access Cognos applications via automation. I haven't tried it with reportnet but with impromptu.
The only thing you have to reconsider is that you have to use Visual Basic as programming language for the Cognos-Auotmation (as VB is weak-typed while C# is...
I found the reason!
Setting for "Impromptu Data Path" is by default set to "WINDOWS\system32" but in that Directory I do not have permissions to write -> No temp-file could be created!
I changed the setting and everything works now!
Dim objImpAnw As Object
Dim impReport As Object
Set objImpAnw = CreateObject("CognosImpromptu.Application")
'objImpAnw.Visible True
Set impReport = objImpAnw.OpenReport("Z:\impReports\transactions.imr", "2006-09-26")
Call impReport.RetrieveAll
impReport.ExportText...
Hello!
I try to work with Impromptu via Automation (using either VB or VBA).
The problem is that when I call the OpenReport-Method it fails with error number 0 (internal error 61704).
I found out that this error occurs because Impromptu is still busy opening the report or retrieving the data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.