Printing out the VBA code to a file or printer

You can declare a global variable at the top of a module with the format

Please Login or Register  to view this content.

A variable declared at the top of a module is global to that module, and if Public is used it is global everywhere.

You can print your code by right-clicking on the project name (i.e., file name) in the VBA development environment and selecting Print. You can print to paper, or print to a PDF if you have a PDF print driver installed (I think Windows comes with one). I do not know of a way to dump all the code to a single plain text file, but maybe there is a way. You can also export individual modules, which are .bas files but these are plain text files with a one-line header.

P.S. My first job was FORTRAN programming in 1979

Originally Posted by Garish

OK. I tried using the "Public VariableName As DataType" but I keep getting Compiler Error: Invalid Attribute or Sub Function.

Hopefully you did not type that in just like that. It is just a model to show the syntax. The Public keyword was the important part. An actual declaration would look like

Please Login or Register  to view this content.

It must appear before the first Sub or Function. If you use Option Explicit it must occur after that.

Now the variable FileName can be referenced anywhere in the project.