Re: Learning VBA

Tech-Archive recommends: Fix windows errors by optimizing your registry


Jim Gordon ha escrito:

Excel modules sometimes get corrupt. Try copying the module code to some
other program (textedit, for example). Then delete the module. Then
make a new module and copy the text from the other program into the new
module.

Thanks JM and Jim,

I'm afraid I'd need step by step instructions to create the module.
I've never used Excel in my life and my wife won't know either. Which
module(s) where are they etc?

As for JM's questions, I've spoken to my brother-in-law who says all
the logic of the file is OK (it runs fine on Office 2003 for Windows
and my wife can still run it fine under Jaguar/Office v.X. It seems
there is something in our version of Office 2004 that's not working
correctly which is in line with Jim's suggestion.

If anybody is willing, my wife has no objection to sending the file to
someone to see if it runs OK on their Office 2004. It's around 500KB in
size.

I think re-creating the module would be the best first step however,
but how exactly do I do this?

Many thanks

.