Thread: Macro Issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TimWal TimWal is offline
external usenet poster
 
Posts: 1
Default Macro Issue

Hey guys,

I am having an issue with a macro from Excel 2002 in Excel 2003. Under
2002 it works just fine, but errors out in 2003.

Can anyone tell what is wrong with it, any help would be greatly
appreciated -

Sub Save_to_History()

Dim BackupFileName As String

BackupFileName = Range("openfile")

If MsgBox("Are you sure you want to save to history?", vbYesNo +
vbCritical, "WARNING!") = vbYes Then

ActiveWorkbook.Save
ActiveWorkbook.SaveCopyAs ("C:\data\forms\history\" & Range("o3"))

End If


End Sub