Search results for query: *

ck1999, Thanks, I'll give that a shot. In the meantime, I created an xls template and am appending a tab into that, running the macro and calling "save as".

Progress, sort of... I had to open the workbook, record a macro, "testmacro" in this case. Inserted the code from personal.xls, saved and closed the workbook and finally, I actually call the macro. Here's the problem. This is a new workbook every I do the output. The code I want to use to...

Thanks for the input, there are several issues which result... 1. Using this code opens another, "read only instance" of the workbook. 2. The function "UpdateMatrix" is actually stored in the hidden Personal.xls file. When inserting the path to the Personal.xls in the .run method...

Stand by, I see why I didn't get and error. Now getting a syntax error.

Okay, I tried the following, got no errors, but the function didn't execute. This is after the output object is completed and the workbook is open. Dim objXL As Object, x On Error Resume Next Set objXL = GetObject("Excel.Application") With objXL.Application .Visible =...

I have a project in which I export a query to excel using the OutputTo method DoCmd.OutputTo acOutputQuery, stDocName, acFormatXLS, Filename, True Each time that I do this I create a new spreadsheet/workbook w/ a file name specific to the output. Once in Excel I run a module which formats the...