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!

  • Congratulations strongm 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: *

  1. KimberlyBarkman

    Exporting to excel worksheets

    I currently export data, on the data row, to csv files, which our users open in excel. I need to export data to multiple sheets within a single excel file. Is there a way to do this? Can the worksheets be named within actuate?
  2. KimberlyBarkman

    Finding Files

    Thanks for the tip! Unfortunately, I can't kill all csv files, only those that are older than a specific date. My plan was this. 1. look in the specified dir for *.csv and return the full path of the first file. VB's DIR() method does this, but i cannot find an Actuate Basic equivalent. 2...
  3. KimberlyBarkman

    Finding Files

    I need to search a folder for all csv files older than a specific date and delete/kill those files. The problem is, all the actuate file functions I see require the full directory and file name. I don't know the file names. Are there any file functions that support wildcard characters? In...
  4. KimberlyBarkman

    Using Actuate to Update the Database

    Try updating on the start method of the report section instead of the Query Editor. I've never updated, but do insert and delete in several reports. Here's an example with two delete statements. Sub Start( ) Dim conn As AcDBConnection Dim DeleteText As String Dim CommitText As String Dim...

Part and Inventory Search

Back
Top