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