Thread: CREATING E-MAIL ATTACHMENT WITH 'BeforeSave Events' IN CODE
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Chuckles123[_108_] Chuckles123[_108_] is offline
external usenet poster
  
Posts: 1
Default CREATING E-MAIL ATTACHMENT WITH 'BeforeSave Events' IN CODE

Ron,

I hope you enjoyed the long weekend.

If I 'comment-out' my SaveAs stmt in the .xlT file, save it, and re-run
the main macro, everything works perfectly.

What do you think about the feasibility of renaming:
'ACCT ADJUST - TFI 09-02-05.xlS' as
'COMMENTS - TFI 09-02-05.xlS' within the .xlT file?
If renaming works, then it would not be necessary to pass the variable
'myDate' from the main macro (.xlA file) to the .xlT file.

Chuckles123

P.S.: JingleRock is another username that I sometimes use.


--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=400471

Reply With QuoteReply With Quote