Search results

I have a report with a page header and page footer. The details section is simple. Part# Description QTY The three fields have a grid around it. My problem is if I only have 4 parts to report the details section shows only four lines and the report has a large blank...

I am looking for the VBA code that will let me open an excel workbook and run a macro in it then close the workbook. I am transfering in data from excel, but it needs manipulation first. Using Access 2007 and Excel 2007. Private Sub Command8_Click() On Error GoTo Err_Command8_Click Dim xlsApp...

I am trying to open a user chosen excel file from an access 2007 program. The code will open a excel file perform some data manipulation then save and close the excel program. At this time I am stuck with how to open the excel file. The following code does not open excel it just crashes then I...