Defining excel object...

Working with excel from Access environment, for example, I use:

Dim xl As Excel.Application
Dim wb As Excel.Workbook
Dim ws As Excel.Worksheet

This time, I am working within a workbook itself.

Q: What is a proper (and easy way) of defining these objects to work with?

Thank you.
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

FlysterConnect With a Mentor Commented:
Just delete Excel. :

Dim xl As Application
Dim wb As Workbook
Dim ws As Worksheet

Patrick MatthewsConnect With a Mentor Commented:
Actually, there is nothing wrong with leaving it as it is.  Fully qualifying the object class by mentioning which library it's from won't harm anything...
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.