Save Current Workbook
 

I would like to create a macro to save my current workbook.

Please help me complete this task.

Thanks,

Save Current Workbook
 

Sub savit()
ActiveWorkbook.Save
End Sub

--
Gary''s Student - gsnu200751


"Joe K." wrote:


I would like to create a macro to save my current workbook.

Please help me complete this task.

Thanks,

Save Current Workbook
 

One way:

Public Sub SaveCurrentWorkbook()
ActiveWorkbook.Save
End Sub

In article ,
Joe K. <Joe wrote:

I would like to create a macro to save my current workbook.

Please help me complete this task.

Thanks,

Save Current Workbook
 

Hi Joe

For the workbook with the code

ThisWorkbook.Save

Or for the activeworkbook
ActiveWorkbook.Save



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Joe K." <Joe wrote in message ...

I would like to create a macro to save my current workbook.

Please help me complete this task.

Thanks,