Search results for query: *

Hello hello, I went to run a macro to produce a csv file like normal and I got a "Bad File name or number" error, and the file was only created with the headers. the macro is as follows: Option Explicit Sub ProbToCSV() Dim today as string today = format$(Date$, "medium date") Dim Filename...

Hello all! (RS V4.2, ADP SQLBase) I have a simple Macro-Derived Field to format termination dates into the "Medium Date" format. The code is as follows: Sub TermDate2() Dim TermDt TermDt = Field("TERMINATIONDATEROE") Dim TermDt2 as string TermDt2 = Format$(TermDt, "Medium Date") DerivedField...

The SaveReport command doesn't include Headers when it saves the report. Is there a way to include the headers, like it does when you save as excel to the Catalog? Thank you!

I want a macro to save the report as an excel file but when i test the macro, it tells me there's a syntax error on the SaveReport line. My macro script is as follows: Sub saveasexcel() Dim Sitenm as string Dim Filename as String Dim Num as variant Sitenm = Field("site") Filename =...

I have two derived fields which return strings containing the date three days prior to the current date and three days after the current date. they are strings in the format that the Selection criteria uses when it's in SQL. I have linked the macros to Before the report opens, but I still get...

SO I'm writing a report that needs to list all my terminated employees,(selected FOR in the selections) and tell me whether they have any thing accumulated in a couple of accumulators. I notice that the link: V_EMPLOYEE.FILE# = V_YTD_ACCUMULATOR.FILE# Causes those employees with nothing in...