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

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Forum statistics

Threads
1,214,911
Messages
6,122,194
Members
449,072
Latest member
DW Draft

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