Thanks, but this macro is running me mad.
The code from the top is running only on one of my computers. Thats some kind of progress, but now it seems, that I have trouble with the rights on the file system. After managing this, I will try to customize the code to my needs and then I will compare...
Thanks to both of you.
the catalog login-data is stored, so that I only have to confirm the catalog dialog when opening a report manually. With the code above it has been working all the time. It was not necessary to confirm the dialog. It did not appear.
Now it seems, that the catalog will not...
Hello,
I got a piece of code, similar to the one above. Since we have merged from WinNT to WinXP and Impromptu 6 to Impromptu 7.1 the code does not work anymore.
Calling the "OpenReport" statement it stops with a runtime error 24634. Translated from German, the info is: "Input-Variable invalid...
Hello DoubleD,
thanks for the help. I'll try this out. But I would prefer a solution without editing the catalog, because it is delivered by a business-partner and I have to make the changes again everytime we get an update.
Regards,
ahstyx.
Hello everybody,
I am going to start my final year project at university and now I am searching for literature.
It is about analysing the legal and organizational requirements to the IT of an investment company in Germany. The result should be an evaluation of how the IT-Strategy of the company...
Hello,
I have to filter several reports to match a list of calendar data. I would like to store and edit the dates in a simple textfile.
Is it possible to set a filter in the Impromptu reports by using the textfile data. Maybe in an expression like IN("data_from_file"). But I don't want a...
Hello,
I have to create an Impromptu 6 report with a filter like this:
WKN IN (123456; 223457; 323458; ...)
Is there any maximum amount of items between the brackets?
I have to know, because I have not found any other way of filtering yet.
Thanks very much in advance,
Andreas (Cologne).
Hello,
because of older posts in this forum I try to save an Impromptu 6 report with formats (depending on the boolean variable format) using the following code:
Set bericht = impromp.OpenReport(pathImp)
If format = False Then
bericht.exportexcel (pathXls)
Else
SendKeys "%D", 10000...
Hello,
is it possible to get only the actual date ( today ) from a column of date specifications?
Without a prompt box, if possible.
A filter in a way like: columnA = today()
Regards,
ahstyx.
Hello,
I want to take the sum of a column of values in Impromptu 6.
The problem is, that the first two values in the column must not get into the sum.
Is there a way to exclude the two values from the sum, but to show them in the report? It is not necessary to show them on top of the list...
Hello,
I would like to bring some automation into my Impromptu reports.
Does anybody know where I can get some macro tutorials for Impromptu? Ideally for for beginners in macro programming! Perfectly in German!!
Regards,
ahstyx.
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.