Recent content by dalex17

Hello, I am using Cognos script Editor to save an excel report with format. I am accomplishing this by using SendKeys. However, I find that sometimes the use of Sendkeys does not copy over any existing occurences of the excel file I'd like to copy over. So I read somewhere in this forum that...

DrLex, I used your send key reccomendation, but I am experiencing an issue where sometimes it saves over the document and sometimes it does not. Is there a way to work around this. In other dialogs, D. Griffin suggests a 'Kill stmt" ....would you be able to give me an example of a kill...

Dave, Could you please give me an example of code that will search and kill the existence of a file?? Thank you, dalex

DRLX, Is the export with format command as you write it above (i.e. exportwithformat), or does it look different in syntax? Thanks, Dalex

Could you point to where Projects->references is located? I do not see it in Projects Explorer...

Thank you BB, however it now does not like: fso As New filesystemobject dalex

BB, This is what I have. I get an error on the second part below beggining with Set ts Also, whay did you write ".exe file I am currently running" My objective to copy a text file to anther location. Thanks again. Dim fso As New filesystemobject Dim ts As textstring Dim...

Thanks Bigger brother, Could you clarify where my new path should be typed in your second statement beggining with set ts (after the first ts close). Thank you!

Good afternoon, I need assistance with a VB code that will copy a .txt file from one location to another. The catch is, however, that I need the copied .txt (that is, the new .txt file that copied into another location), to end with a time stamp. Here is an example of what I mean...

drlex, I appreciate your response. I would like to try to call excel as an object. Could you show me pointeres on how to get this started? Thank you dalex

Hello, At the very end of my cognos script, I have a command which should open an excel file: Shell ("C:\Program files\Microsoft Office\Office10\excel.exe /Y Y:\Standard Reports\Acc dept\test.xls") The problem I am having is that it cannot read the file pathname 'Standard Reports'...

Navshiv, Thank you. This is very helpful! Dalex

You guys are terrific! Thanks for your assistance. P.S. Is there anything "cool" that can be done with Cognos script editor? I mean like a progress bar or something? Really anything that might add a cherry on top. It's no big deal because I have everything working; just thought...

thanks drlex for your help! p.s. Kludge? Never heard of that word. I'm guessing it must mean something similiar to concoction... :)

Flex, I figured it out. The reason why it didn't work properly was because the macro didn't like the file name 'New Folder'. In particular, it did not like the space between 'New' and 'Folder' for some reason. I know this because when I changed the name of that folder to just 'folder' 9one...