Hi,
Thanks all. I have created a macro which does calculation steps and create
some pivots upto this its working fine. I am looking for a code where I need
to Saveas the file where I need to remove all the modules in the new
workbook. Hope this is clear than previous mail.
*Note: I am using Excel
You can also save your file in xlsx format if you dont want to save your
Code in Workbook..
On Mon, Jul 11, 2011 at 7:30 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> I need to SaveAs workbook without VBA code in it.
>
> Thanks,
>
> Chandra Shekar
>
> --
>
>
Hi,
I think following code will answer your question. This is in VB Script.
Set objFileSystemObject = CreateObject("Scripting.FileSystemObject")
strResultFilePath='Enter the File Path Here.
If Not objFileSystemObject.FileExists(strResultFilePath) Then
Set objResultExcel =
CreateObject("Excel
Hi Chandra Shekar,
I assume your query is incomplete. However I will try to answer..
If you want to save a macro free (no vba code in it) workbook, you should
save it as ".xlsx". Remember there will be no macros in this file.
I hope you know the shortcut key for Save As (F12).
If you want a cod
Hi,
I need to SaveAs workbook without VBA code in it.
Thanks,
Chandra Shekar
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
