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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,214,838
Messages
6,121,885
Members
449,057
Latest member
Moo4247

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
Back
Top