Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by bigalmcintyre
-
Sending active workbook as email
Hi, I am trying to develop an application that will set up an email to send the active workbook. I am using the following code but it sends the email straight away, whereas I want to review the email and possible add to it before it is sent. Is there a way for me to set the email up but not...- bigalmcintyre
- Thread
- Replies: 0
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to copy excel workbook without the macro's
Thanks for the advice. Am I going about this the wrong way? Would it be easier to save the open workbook under a different filename but without the macro's being saved on the newly saved version? Does anyone have any code suggestions for this?- bigalmcintyre
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to copy excel workbook without the macro's
Can anyone suggest a routine that makes a copy of an entire workbook (differing numbers of sheets open) without copying the macro's or VBA to the new workbook. My application is a fairly basic routine that sorts and reconciles data and the macro's are currently public (saved within the main...- bigalmcintyre
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
