PDA

View Full Version : Excel Vba for Macros...



Mr_Bharatg
08-12-2009, 01:39 AM
Hello,
I Want's to use macro for excel, Problem is ,when i use macro in Excel for sent Excel File as attachment for another recipient , then i want delete all macro in attached excel file, but macro remain in base Excel file.
please help me for this problem.


Thanks

GTO
08-12-2009, 03:03 AM
Greetings Mr_Bharatg,

Firstly - welcome to VBA Express :-) I have sure learned a lot here, and I'm sure it will become your favorite site as well.

As to your question, I take it that you are sending the entire file/ workbook as the attachment. Presuming that to be correct, I think that the things to consider are:

Is there code in any of the sheet module(s)?
Are there named ranges?
Are there formulas/worksheet functions included; particularly those that source other workbooks?

Finally - are we looking to send them a workbook that still "works" (formula/worksheet function-wise), or do we want to send a fascimile of the workbook (ie - values etc)?

Hopefully my questions seem sensible,

Mark

Bob Phillips
08-12-2009, 05:13 AM
Try creating addin that works on another workbook, that other workbook will then not need any code.