Using Access to modify and Excel FIle...

[Shawn12]

I use Access to open a workbook from a Simple Form. What I want to know is can I add code or a macro of some kind that will select Range("A:A") and Delete that column after the workbook is opened w/ the Command Button in Access. This is kinda an extension of a problem I had earlier...

Here is what I use to open the Excel file:
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click

Dim thedirectory As String
Dim stAppName As String
'Dim xlBook As Excel.Workbooks
'Dim xlSheet As Excel.Worksheets
'Dim ExcelWorksheet

stAppName = "Excel.exe ""N:\OPS\COMMON\OpsResearch\Contact Center\DI CCL Reporting dB\Apps by Agent.xls"""
Call Shell(stAppName, 1)

Set ExcelWorksheet = GetObject("Apps by Agent")

Exit_Command0_Click:
Exit Sub

Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click

End Sub

If I were using VBA in Excel all I would have to do is this normally:

Workbooks("Apps by Agent").Worksheets("Apps by Agent").Range("A:A").Delete

My question is..Is there a way to add this line or something similar to my Command Button code to do this within Access. I have tried a few thing and got various errors..Object errors and such.. Im kinda new to doing code in Access so please bear with me. Thanks.

 

[Shawn12]

THis line is not supposed to be there I was trying stuff:

Set ExcelWorksheet = GetObject("Apps by Agent")

 

[SkipVought]

Hi,

Set a reference to the Microsoft Excel n.m Object Library in the VB Editor - Tools/references...

Check out help on GetObject Function Example

Skip,

_[red][/red]