Search results for query: *

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...

Flex, Thanks for the snippet. It almost works for me. I mean, excel opens, but then I get an error message saying that the file cannot be found. this is what I have and I can verify that the file names and location are accurate. Any thoughts? DIM XLApp as Object shell ("C:\Program...

Hello, Does anyone know the question as to whether the Cognos script editor can run a batch file? If not, then can you tell me if there is Cognos Script Editor syntax that can open an excel file? Dalex

Hello, My code is below. I want to add to this code something that will remove any rows that have the value 0 (zero). Any thoughts will be much appreciated! Dalex Private Sub Workbook_Open() Application.EnableEvents = True Dim FileNum As Long, i As Long Dim y As Variant FileNum =...

Hello, Does anyone know of a way to save an .xls file with format using the Cognos script editor? I'm trying to automate a process where I click on a macro button developed through Cognos script editor to save an Impromptu report as either excel or text WITH FORMAT. Thank you, dalex

Hi, Is it possible to execute a specific macro depending on a file name? In other words, I have created macro1, macro2, and macro3, and would like for macro3 to run every time the file name abc.xls is opened. Any replies would be much appreciated. Please note that macro1, macro2 & macro3 are...