All,
I am a total access newbie and have a quick question. I found the following reply to a post and was hoping someone could elaborate on this a little more for me.
I have written my macro in excel that formats my exported access form how my client wants it to look. I just don't know where to copy my VBA?
Here is the event that exports my form:
Private Sub Command288_Click()
On Error GoTo Err_Command288_Click
Dim stDocName As String
stDocName = "FormG037GMth"
DoCmd.OutputTo acForm, stDocName, acFormatXLS
End Sub
I appreciate any guidance you can give me.
Thank You,
Steve
I am a total access newbie and have a quick question. I found the following reply to a post and was hoping someone could elaborate on this a little more for me.
"Since I am not all that comfortable with the Excel object model, I would start with an Excel sheet that contains the data only. I would then turn the macro recorder on and try to produce the necessary subtotals. I would then copy the VBA generated by the macro recorder and paste it into an Access procedure."
I have written my macro in excel that formats my exported access form how my client wants it to look. I just don't know where to copy my VBA?
Here is the event that exports my form:
Private Sub Command288_Click()
On Error GoTo Err_Command288_Click
Dim stDocName As String
stDocName = "FormG037GMth"
DoCmd.OutputTo acForm, stDocName, acFormatXLS
End Sub
I appreciate any guidance you can give me.
Thank You,
Steve
