run macro made in 2003 excel in excel 2007

May 25, 2009 at 23:58:31
Specs: Windows XP
i have macro made in 2003 and I can not run it in 2007 excel bellow is the macro please advice,
wbn = ActiveWorkbook.Name 'Workbookname
srv_loc = Workbooks(wbn).Worksheets("SETTINGS").Range("B1")
src_rpt_name = Workbooks(wbn).Worksheets("SETTINGS").Range("B9")
Workbooks.Open Filename:=srv_loc & src_rpt_name

See More: run macro made in 2003 excel in excel 2007

Report •


#1
Report •

#2
May 26, 2009 at 07:49:18
It might be helpful if you gave us a little more detail than just "I can not run it in 2007".

Report •

Related Solutions


Ask Question