Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dalex17
  • Order by date
  1. dalex17

    delete (Kill) statement

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

    Scheduler Macro Excel Format export

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

    Saving Impromptu Report in Excel with format

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

    Save 'with format' when using Cognos script editor

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

    saving a text file from one path to another with timestamp

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

    saving a text file from one path to another with timestamp

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

    saving a text file from one path to another with timestamp

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

    saving a text file from one path to another with timestamp

    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!
  9. dalex17

    saving a text file from one path to another with timestamp

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

    shell command to open an .xls file does not work

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

    shell command to open an .xls file does not work

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

    Can Cognos Script Editor run a .bat file

    Navshiv, Thank you. This is very helpful! Dalex
  13. dalex17

    Can Cognos Script Editor run a .bat file

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

    Save 'with format' when using Cognos script editor

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

    Can Cognos Script Editor run a .bat file

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

    Can Cognos Script Editor run a .bat file

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

    Can Cognos Script Editor run a .bat file

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

    Hello, My code is below. I wa

    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 =...
  19. dalex17

    Save 'with format' when using Cognos script editor

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

    If file name = 'abc', then run macro1

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

Part and Inventory Search

Back
Top