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