Accessing Excel objects in Access VBA script

Hello there,
How's the day going?

Recently I've been creating Access modules that open Excel files and does some processing prior the importing shoots out.
The problem I am having is that Access does not really allow me to access Excel object library properly.

I am using this code:

Dim Excel_obj as Object
Set Excel_obj = CreateObject("Excel.Application")

This works fine as long as I don't try to access something like this:
Excel_obj.Range("A1").Pastespecial xlPasteFormats

But it works if I do this:
Excel_obj.Range("A1").PasteSpecial

Does anyone know, what cen be preventing me from accessing deeper?
Also I am receiving error if I try to declare this:
Dim Excel_obj as Excel.Application
Error: User-defined type not defined

Thanks a lot in advance!

Modestas

Hi...Have you enabled the Excel reference library?

It seems to me that you are missing a step. When opening a Word document from Excel, one must set an object to Word.Application and then one must open a Word document. In the code above, you set an object to Excel.Application, but where have you opened an Excel workbook?