Visual Basic/Excel problem

OK, I have been working on this all day, and it's a program that I inherated.

We do a time reporting database in Excel that translates to, when you push a macro button, to Access. I don't understand why, it just happens.

I'm setting a new person up in the excel database. I am follwing the directions that my predicessor left, but I get to where I need to edit the VB file, and when I open it, nothing is there.

Anybody have a frigen clue? I'm at a loss

You're over my head, but try asking your question on a site like this..........

http://www.webmasterworld.com/webmaster/3327001.htm

It's probably a Macro, which would be embedded somewhere in Excel. VBA (Visual Basic for Applications) has the capability to use other Microsoft Office program (including Access) to export data to.

I'm a programmer and work with VB, but I'm not too familiar with Excel Macros. There should be a menu item that would give you access to them. Hopefully the former employee didn't put a password on it!

If you can't figure it out, I'd be glad to help further - just PM me.