Search results for query: *

Hi Lex, using FormulaR1C1 worked like a charm, thanks for your great help Regards Paul

Hi Lex, I am still runing in a small problem perhaps you know what to do. In the excel file I want to check if a cell is empty (a2) if it is it should run another macro if not it should not do anyhting. For testing purpose I just put in a msgbox. But no mather wat is in cell A2 it thinks...

Hi Lex, Just found an earlier reply from you in a thread which said that you can use almost any Excel VBA command in Cognos. Tryed a little and I am almost there, just have to put in some actions in an if then statement. Thanks for your help, Regards Paul

Hi Lex, I did try the getdatavalue but we have null values in the report so it won't work (like you said). I am looking at the export excel option at this time, but in this case, can Cognos script check excel as well or do we have to write a VBA macro in Excel? Thanks for your help so far...

Hi Lex, Thanks for your quick reply, I will try it out and let you know. Regards, Paul

Sorry, forgot to mention that. We are using Cognos ImpromptU version 7.1.529.0 Regards Paul

Hi All, Maybe just a simple question, is it possible to check values in a cognos report through a macro. We want to schedule a report to run weekly and export the data to eg. Excel. But it should only do this when specific values are in the report. Thanks. Paul

Hello, I am in need of some help with writing a macro. We want to create a macro to merge an excel file in a word document. Normaly this is not a problem if the name of the excel file is always the same. This however is not the case. Is it possible to let a macro prompt to browse to the excel...

I have got a weird problem with MS Photoeditor (Office 97). The photoeditor will not use the default printer set in Windows, it seems like it uses the first printer installed on the computer as a default. I can't find where to change the default printer from photoeditor. Can anybody help? can...

thnx, it's working fine now..