I am using Office 365 - 64 bit
I have a report in Microsoft Access that I wish to export to an excel sheet. This works fine.
Immediately after creating the excel workbook, I wish to modify the some things.
I am using the following code to open the workbook.
Public Function DeleteRowInExcel(ByVal MyFileName As String)
On Error GoTo Err_DeleteRowInExcel
Dim xlApp As Excel.Application
Dim wb As Excel.Workbook
Dim ws As Excel.Worksheet
Set xlApp = CreateObject("Excel.Application")
Set wb = xlApp.Workbooks.Open(MyFileName)
Set ws = wb.Sheets(1)
I would like to be able to select a range cells(4,1) to the last row / column containing data
and manipulate as required
By example, set all the cells in the range = 4. I am having trouble with selecting the range from Microsoft Access VBA.