Disable Macros while 'save-as'?

[bjoydeep]

Hi!

I am a newbie to VBA macros. So dont know if its a silly question to ask!
I am open an excel workbook, read data from a csv into it (by a Autpen) then do some formatting and then saving it as another xl sheet (original xl sheet is untouched) through a Auto_Close macro.
Now while saving the worksheet-as, I would want it to saved without any of the macros.
Is it possible at all?

This is code for autoclose:
Public Sub Auto_Close()
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:= _
"c:test_jb.xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
' Closes workbook
'Application.Quit
ActiveWorkbook.Close
End Sub

Would appreciate if you could help me in anyway.

Thanks
Joydeep

 

[bjoydeep]

Hi Nate,

This is awsome man!

I got all the help I wanted and am setup to rock and roll.

Joydeep