Run time Error 53 running macro

aj17x55

New Member
Joined
Dec 11, 2019
Messages
2
Office Version
  1. 365
Platform
  1. Windows
So on Excel 97-2003 this file will run macros with no issue. If I try and run the same macro in the same file in Office 365 Excel, it gives me the file not found error. It is a DLL file. Anybody have a good solution to this>
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Welcome to the board!

You could put the macro, and indicate on which line you receive the error. So 365 experts can help you.

Don't forget to put the macro inside code tags
 
Upvote 0
Hi and thank you. I have copied the start of the code down to where error lies. I made the text red.


Option Explicit
Global i As Integer ' generic counter
Global sp As SCANPARM ' one and only scanparm instance
Global numpixels As Integer
Global channum As Integer
Global XLVersion As Single
Global first, second, intercept, third As Single
Global coef As USB2000CONSTANTS
Function DoScan(sp As SCANPARM) As Integer
DoScan = OOI_DoScan(sp)
End Function
Sub Config(ByVal spec As Integer, ByVal adc As Integer, ByVal irq As Integer, ByVal base As Integer)
Call OOI_Config(spec, adc, irq, base)
End Sub
Sub SetNLCoefs(ByVal chan As Integer, coefs As Single)
Call OOI_SetNLCoefs(chan, coefs)
End Sub
Sub SetSLCoef(ByVal chan As Integer, ByVal coef As Single)
Call OOI_SetSLCoef(chan, coef)
End Sub
Sub EnableNLCorrection(ByVal chan As Integer, ByVal ena As Integer)
Call OOI_EnableNLCorrection(chan, ena)
End Sub
Sub EnableSLCorrection(ByVal chan As Integer, ByVal ena As Integer)
Call OOI_EnableSLCorrection(chan, ena)
End Sub
Sub ConfigEx(ByVal spec As Integer, ByVal adc As Integer, ByVal irq As Integer, ByVal base As Integer, ByVal port As Integer, ByVal NIDAQ As Integer)
Call OOI_ConfigEx(spec, adc, irq, base, port, NIDAQ)
End Sub
Function GetSpectrometerType() As Integer
GetSpectrometerType = OOI_GetSpectrometerType() <
End Function
 
Upvote 0

Forum statistics

Threads
1,215,059
Messages
6,122,918
Members
449,093
Latest member
dbomb1414

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