Improvement for office

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I always work a lot with the same file. Excel and Word. Its possible to put a
option that every time I save the file it includes a information about the
file. It can be version, date, etc.

Example

I haves this file = cashflow.xls or .doc

I want with and option to put information on the file that I save =

cashflow-01.xls

and so on

cashflow-01.xls
cashflow-02.xls
cashflow-03.xls
cashflow-03.xls

Another Example

I haves this file = cashflow.xls

Every time I save the file I what to put info Example "date and version"

cashflow-30-06-06-ver-1.xls
cashflow-30-06-06-ver-2.xls
cashflow-30-06-06-ver-3.xls
cashflow-30-06-06-ver-4.xls
 
try changing this to suit your needs. Place in the ThisWorkbook module by
right click the excel icon just to the left of file on the bar.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
With Sheets("sheet25")
mlr = .Cells(Rows.Count, "b").End(xlUp).Row + 1
Cells(mlr, "b") = ActiveWorkbook.Name
End With
End Sub

--
Don Guillett
SalesAid Software
(e-mail address removed)
"Robert Adams, from Argentina" <Robert Adams, from
(e-mail address removed)> wrote in message
news:[email protected]...
 
add a dot before
Cells(mlr, "b") = ActiveWorkbook.Name
..Cells(mlr, "b") = ActiveWorkbook.Name
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top