macro can't find macro

Ludovico

Board Regular
Joined
Apr 3, 2002
Messages
71
Following macro is designed to open a file (unless it is already open) called "Easy Access Dwight" and then to run an existing macro from within that file named "FITBStockQuote". Error message says "The macro "EASY ACCESS DWIGHT.XLS!FITBStockQuote" cannot be found".

I know its there and I've proofed it all pretty carefully.
Can someone help?
Thanks, Ludovico

Sub ScorecardEasyAccessDwight()
'
' ScorecardEasyAccessDwight Macro
' Macro recorded 2/4/02
'

Dim n As String, myBk As Workbook
n = "Easy Access Dwight.xls" ' file name here
On Error GoTo 1
Set myBk = Workbooks(n)
On Error GoTo 0
2: Application.Goto Workbooks(n).Sheets("Easy Access Buttons").Range("i1")
Application.Run "EASY ACCESS DWIGHT.XLS!FITBStockQuote"
Exit Sub
1: Workbooks.Open Filename:="L:CommScorecard Easy Access" & n
Application.Run "EASY ACCESS DWIGHT.XLS!FITBStockQuote"

GoTo 2
End Sub
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,144,510
Messages
5,724,782
Members
422,578
Latest member
annsalinas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top