<div>
Even better, a few good web sites that have tutorials on this kind of thing, and the layout of the Excel object model. &nbsp;Then I could help myself in the future.<br />
<br />
Thanks!
</div>


Even better, a few good web sites that have tutorials on this kind of thing, and the layout of the Excel object model.  Then I could help myself in the future.

Thanks!

<div>
Something like this: (Make sure your excel library is referenced in your VB editor)<br />
<br />
Dim xlapp As Object<br />
<br />
Set xlapp = CreateObject(&quot;Excel.Applic<wbr />ation&quot;)<br />
<br />
Workbooks(&quot;c:\BOOK1.XLS&quot;).<wbr />Worksheets<wbr />(&quot;Sheet1&quot;)<wbr />.Activate<br />
With ActiveWindow<br />
&nbsp; &nbsp; .SplitColumn = 1<br />
&nbsp; &nbsp; .SplitRow = 2<br />
&nbsp; &nbsp; .Freezepanes = true<br />
End With<br />
<br />
Thanks<br />
<br />
Jell<br />
<br />

</div>


Something like this: (Make sure your excel library is referenced in your VB editor)

Dim xlapp As Object

Set xlapp = CreateObject("Excel.Application")

Workbooks("c:\BOOK1.XLS").Worksheets("Sheet1").Activate
With ActiveWindow
    .SplitColumn = 1
    .SplitRow = 2
    .Freezepanes = true
End With

Thanks

Jell



<div>
I ended up creating the macro.
</div>


<div>
 &nbsp; &nbsp;Dim objExcel As New Excel.Application<br />
<br />
&nbsp; &nbsp; objExcel.ActiveWorkbook.Sa<wbr />ve<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; objExcel.Workbooks.Open strXLSName<br />
<br />
&nbsp; &nbsp; objExcel.Quit<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; 'DOES NOT CLOSE EXCEL!!!<br />
&nbsp; &nbsp; Set objExcel = Nothing
</div>


   Dim objExcel As New Excel.Application

    objExcel.ActiveWorkbook.Save
   
    objExcel.Workbooks.Open strXLSName

    objExcel.Quit
   
     
    'DOES NOT CLOSE EXCEL!!!
    Set objExcel = Nothing

<div>
<div class="content wysiwyg-content">
I know how to export a query out to Excel in VBA.<br />
<br />
After the spreadsheet is created, I want to programmatically do the following:<br />
<br />
1) &nbsp;Create a &quot;Split&quot; (panes) in the spreadsheet. &nbsp;Coordinates would be at cell A4.<br />
<br />
2) &nbsp;Freeze the panes.<br />
<br />
This would be the equivalent of choosing Window |Split in Excel, positioning the split to cell A4, then choosing Window | Freeze Panes.
</div>
</div>


I know how to export a query out to Excel in VBA.

After the spreadsheet is created, I want to programmatically do the following:

1)  Create a "Split" (panes) in the spreadsheet.  Coordinates would be at cell A4.

2)  Freeze the panes.

This would be the equivalent of choosing Window |Split in Excel, positioning the split to cell A4, then choosing Window | Freeze Panes.

Work with Excel Spreadsheet from within Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.