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 TouchToneTommy 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: Ayato
  • Content: Threads
  • Order by date
  1. Ayato

    How to insert a variable in the name of the file ?

    Hello @ll, In Report Net, I have some processes running and automatically building and sending reports everynight with the performances of the previous day... Is it possible to insert a variable part in the name of the report when svaing it (like a string related to the date ?) e.g: all my...
  2. Ayato

    hh-mm-ss format problem ?

    Hello @ll, In Cognos report net, I need to format a amount of seconds to hh.mm.ss format. Any idea how to do that ? e.g: 120 = 00:02:00 regards, Ayato
  3. Ayato

    Saving to CSV

    Hello, I have an excel file with date (yymmdd) and I use a macro to save xls to csv, something like : ActiveWorkbook.SaveAs Filename:="C:\test.200", FileFormat:=xlCSV, CreateBackup:=False When I run the macro, the format of the dates in the csv are changing to "yyyymmdd&quot...
  4. Ayato

    Date format XL to CSV

    Hello @ll, I have an excel file with a date using the format yymmdd, when I save this file to .csv my date is now yyyymmdd How can keep the same date format when saving to .csv? Please advise, Thx Ayato
  5. Ayato

    XL to CSV export problem

    Hello, I have a databook saving itself to CSV, the databook is only 5 lines of datas. When I open the CSV file I have a lot of comma everywhere even if there no values (cells are completely empty execpt for those 5 lines) It looks like this...

Part and Inventory Search

Back
Top