Recent content by dinfinity

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

Yes the excel files are correct and I have been checking for other processes running. I guess all I can do is see if the program will work on a computer I have full rights too and know what security is in place.

Nothing in task manager. Same automation error. Did notice after that an excel application stays open in task manger even though nothing is open. I did a end process and tried again same automation error.

Here it is. I am wondering if their is some sort of security setup on this computer that might be causing the problem. After running the code and it errors, I try to open the excel file manually and excel reports a problem then needs to restart excel. After the excel shut-down and restart...

Same error with or without brackets.

Ok now I get an error - Automation error The server threw an exception The error happens at this line: Set xlswkb = xlsApp.Workbooks.Open([myfile])

Now I get an error message that says object needed

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

Here are the details of the excel crash Problem signature: Problem Event Name: APPCRASH Application Name: EXCEL.EXE Application Version: 12.0.6545.5000 Application Timestamp: 4c654035 Fault Module Name: StackHash_23c5 Fault Module Version: 6.0.6002.18327 Fault Module Timestamp...

I do not have admin rights to this computer and I am starting to wonder if that is my issue. I have tried all kinds of diffrent code combinations and continue to run into various excel crashes. OS Vista

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