I'm looking for how can I use the SendKeys command in a macro file in order to export a cognos report to a excel file with format.
Could anyone please give me an example of that ?
Are you trying to save using a format other than that which the script editor recognises as an excel file?
In my experience of using sendkeys, I have found a consistency rate of around 95%. That is, the keys sent do not always arrive intact. A filename of 'hello' sent could arrive as 'lo'.
I have found this is particularly bad when trying to use menu functions.
If possible, I would suggest using the standard excel save as with the script editor.
Kevin **************************************************************
The difference between fiction and reality is that fiction has to make sense.
**************************************************************
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.