Search results for query: *

I've been using Cognos macros and scripts to run reports, save to excel or pdfs and then e-mail via lotus notes. However, I have several reports where I have to manually cut and paste a range of cells in excel into the body of the lotus notes email. Here is a sample of the code that I normally...

I am running various reports and saving as excel files with format. Those excel files are linked to a summary workbook which does further calcs, etc. I now need to copy the values from one of the workbook pages into other workbooks. Problem is when I open the workbook with links, I get a...

Thanks for catching my mistake! I did a cut and paste of your input into my macro to avoid more typos. Unfortunately, I continue to get the same error? Any other ideas of where I should look next is welcome...

I'm using Impromptu version 7.1.340.109 and am having problems using this. Here's a snipet from script: Set objImpRep = objImpApp.ActiveDocument objImpRep.SpecialCopyToClipboard (0) I encounter error number 91 with this last line noted as the error line. Any help is greatly...

Previous posts have been extremely helpful on how to open and format data in excel file from Impromptu script editor!! I need your expertise to determine appropriate scripting to do a "find" for a value and/or insert a footer into the file. Any help is greatly appreciated!! Thank you in...

Dave Griffin, I realize this is a huge delay in posting a response to this topic, but just am a new user of Cognos & new to Tek-tips.... I see in your part of the response you referred to reading in data from a text file. I have been in search of sample code of how to do this. I'm a total...