sub report in Excel

D

David

Hello all,
I posted this question in Excel.Programming. I am hoping I can execute this
VBA code on the Excel doc within Access somehow since they both use VBA.
Question:
I am exporting data from Access 2002 to Excel. Unfortunately, I am
exporting a sub report that produces blank cells in columns A thru M for the
sub report data. For example my ONE relationship of Customer is on row 1,
columns a thru M.
The many relationship ORDERS is on rows 2 thru 5, but the data on rows 2 thru
5 doesn't start until column N.

Answer:
On Error Resume Next
ActiveSheet.Columns("A:p").Cells.SpecialCells(xlCellTypeBlanks).Delete _
shift:=xlToLeft
On Error GoTo 0

Things I've considered.
Linking the excel doc on the user's computer to my Front End, but Access
2002 can not edit values in this linked excel doc (I really hope they fix
this).
Instead of exporting the Report and child sub report, export a query.
However I don't want rows 2-5, columns a-m to have repeated values and just
rows 2-5 column n be different.

Is there something I am missing? Can I execute the Excel VBA code within
Access VBA?

You would think since Excel and Access are both Microsoft products, they
would play nicer with each other.
 
Top