Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

run macro made in 2003 excel in excel 2007

Comment:

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

Name: Mike (by mmcconaghy)
Date: May 26, 2009 at 06:21:33 Pacific

Reply:

Look here: http://office.microsoft.com/en-us/e... MIKE http://www.skeptic.com/

0

Name: DerbyDad03
Date: May 26, 2009 at 07:49:18 Pacific

Reply:

It might be helpful if you gave us a little more detail than just "I can not run it in 2007".

0

Excel Problem

I have disabled items in ...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I am not able to right click in Excel 2007. When I do so, nothing happens. I can right click in other programs including Word 2007 ...

Summary: Your file could not be printed due to an error on HP Officejet Pro K5400 Series on Neo1.Can print successfully in Word 2007, Outlook 2007, and WinXP. What are the default Excel files for WinXP profile...

Summary: Please forgive me if this has already been answered, but I didn't find what I'm looking for. I'm trying to figure out why in excel 2007 when I record a macro that does simple things such as delete row...