Date in VBA Code Printout
 

Is there any way to get a date into the print of VBA Code?

--
Bill @ UAMS

Date in VBA Code Printout
 

Do you mean myDate = #8/6/05# , where the pound signs indicate a date?

"BillCPA" <Bill @ UAMS wrote in message
...
Is there any way to get a date into the print of VBA Code?

--
Bill @ UAMS

Date in VBA Code Printout
 

If you mean when you print the code:

No, except to type it in the module. No header/footer options.

--
Regards,
Tom Ogilvy

"BillCPA" <Bill @ UAMS wrote in message
...
Is there any way to get a date into the print of VBA Code?

--
Bill @ UAMS

Date in VBA Code Printout
 

Bill,

You could manually enter the date at the top of a Module (be sure to use the
asterik '
' 8/5/05
or ' Aug 5, 2005

Or you could set up a separate code module to input the date into a Module
and than print the module. For this you'll need code to write to a code
module.

--
steveB

Remove "AYN" from email to respond
"BillCPA" <Bill @ UAMS wrote in message
...
Is there any way to get a date into the print of VBA Code?

--
Bill @ UAMS

Date in VBA Code Printout
 

This is what I'm looking for. Where might I find some examples of code to
write to a code module?

--
Bill @ UAMS


"STEVE BELL" wrote:

Bill,

You could manually enter the date at the top of a Module (be sure to use the
asterik '
' 8/5/05
or ' Aug 5, 2005

Or you could set up a separate code module to input the date into a Module
and than print the module. For this you'll need code to write to a code
module.

--
steveB

Remove "AYN" from email to respond
"BillCPA" <Bill @ UAMS wrote in message
...
Is there any way to get a date into the print of VBA Code?

--
Bill @ UAMS

Date in VBA Code Printout
 

Chip Pearson's page

http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy

"BillCPA" <Bill @ UAMS wrote in message
...
This is what I'm looking for. Where might I find some examples of code to
write to a code module?

--
Bill @ UAMS


"STEVE BELL" wrote:

Bill,

You could manually enter the date at the top of a Module (be sure to use
the
asterik '
' 8/5/05
or ' Aug 5, 2005

Or you could set up a separate code module to input the date into a
Module
and than print the module. For this you'll need code to write to a code
module.

--
steveB

Remove "AYN" from email to respond
"BillCPA" <Bill @ UAMS wrote in message
...
Is there any way to get a date into the print of VBA Code?

--
Bill @ UAMS

Date in VBA Code Printout
 

Also, another example ...

http://www.vbaexpress.com/kb/getarticle.php?kb_id=250

HTH


--
Regards,
Zack Barresse, aka firefytr


"BillCPA" <Bill @ UAMS wrote in message
...
This is what I'm looking for. Where might I find some examples of code to
write to a code module?

--
Bill @ UAMS


"STEVE BELL" wrote:

Bill,

You could manually enter the date at the top of a Module (be sure to use
the
asterik '
' 8/5/05
or ' Aug 5, 2005

Or you could set up a separate code module to input the date into a
Module
and than print the module. For this you'll need code to write to a code
module.

--
steveB

Remove "AYN" from email to respond
"BillCPA" <Bill @ UAMS wrote in message
...
Is there any way to get a date into the print of VBA Code?

--
Bill @ UAMS

Date in VBA Code Printout
 

Thanks, guys!
--
Bill @ UAMS


"BillCPA" wrote:

This is what I'm looking for. Where might I find some examples of code to
write to a code module?

--
Bill @ UAMS


"STEVE BELL" wrote:

Bill,

You could manually enter the date at the top of a Module (be sure to use the
asterik '
' 8/5/05
or ' Aug 5, 2005

Or you could set up a separate code module to input the date into a Module
and than print the module. For this you'll need code to write to a code
module.

--
steveB

Remove "AYN" from email to respond
"BillCPA" <Bill @ UAMS wrote in message
...
Is there any way to get a date into the print of VBA Code?

--
Bill @ UAMS