What's the Compile command inside the Debug menu used for
in the VBA IDE?

--
Jim Carlock
http://www.microcosmotalk.com
Feel free to post back to the newsgroup!

to compile the code in that activeworkbook. It is basically a debugging
technique. It forces the runtime error checking to be performed.

--
Regards,
Tom Ogilvy


Jim Carlock wrote in message
...
What's the Compile command inside the Debug menu used for
in the VBA IDE?

--
Jim Carlock
http://www.microcosmotalk.com
Feel free to post back to the newsgroup!

Ahhh, that explains it. I seem to get syntax errors and object
mismatches or missing variables or routines. I kept looking to
see if the size of the file changed, as if it actually was compiling
but that kept throwing me off. However, I did notice that file
is considerably larger when saved in an Excel 95/97 format.

--
Jim Carlock
http://www.microcosmotalk.com
Feel free to post back to the newsgroup!


"Tom Ogilvy" wrote in message
...
to compile the code in that activeworkbook. It is basically a debugging
technique. It forces the runtime error checking to be performed.

--
Regards,
Tom Ogilvy


Jim Carlock wrote in message
...
What's the Compile command inside the Debug menu used for
in the VBA IDE?

--
Jim Carlock
http://www.microcosmotalk.com
Feel free to post back to the newsgroup!

Saving in 95/97 format creates two copies of the file both embedded in the
same file. One copy is in xl95 format and one is in xl97 format. Thus the
large size. I have seen very little utility to using this format.

--
Regards,
Tom Ogilvy


"Jim Carlock" wrote in message
...
Ahhh, that explains it. I seem to get syntax errors and object
mismatches or missing variables or routines. I kept looking to
see if the size of the file changed, as if it actually was compiling
but that kept throwing me off. However, I did notice that file
is considerably larger when saved in an Excel 95/97 format.

--
Jim Carlock
http://www.microcosmotalk.com
Feel free to post back to the newsgroup!


"Tom Ogilvy" wrote in message
...
to compile the code in that activeworkbook. It is basically a debugging
technique. It forces the runtime error checking to be performed.

--
Regards,
Tom Ogilvy


Jim Carlock wrote in message
...
What's the Compile command inside the Debug menu used for
in the VBA IDE?

--
Jim Carlock
http://www.microcosmotalk.com
Feel free to post back to the newsgroup!