MS Office and Vista

  pj123 16:15 23 Feb 2008

My friend has MS Office 2000.

I made an Invoice using Excel 2000 for his business.

It has a Macro which increases the Invoice Number by 1 using Ctrl + i.

For the last couple of years it has been working fine with Win XP SP2.

He has now bought a new PC that has Vista as the O/S.

He called me today to tell me that the Macro doesn’t seem to work anymore and he is having to number his invoices manually.

I know the reason why it doesn’t work, so it needs to be changed.

But when he opens an existing invoice in Excel 2000 where does Macros reside in the Menu system.

In XP it was in Tools, Macros. He told me he doesn’t have that option in Vista?

  VoG II 16:28 23 Feb 2008

Are you sure he hasn't updated to Excel 2007?

  Sea Urchin 17:27 23 Feb 2008

If so then this is how

click here

  pj123 17:36 23 Feb 2008

VoG™, he has not updated to Excel 2007.

He is still running MS Office 2000.

The reason it doesn't work is because the .txt files were saved on a different hard disk drive.

I need to know where the original macro is so that I can tell him how to change the macro.

This is a copy of the macro:

Sub Invnumber()
On Error Resume Next
Open "f:\invnumbers\invoice.txt" For Input As #1
Input #1, currentnumber
Close #1
nextnumber = currentnumber + 1
ActiveCell.FormulaR1C1 = nextnumber
Open "f:\invnumbers\invoice.txt" For Output As #1
Write #1, nextnumber
Close #1

End Sub

He doesn't have an F drive anymore. So I need to know where the macro is.

  VoG II 17:52 23 Feb 2008

Press ALT+F11 to open the Visual Basic Editor.

  pj123 15:56 24 Feb 2008

Thanks VoG™. Have left a message on his ansafone to ring me.

Will post when all is done.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?