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
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