Excel VBA "Dim frmReverify As ReVerifyNow" errorSolved

Probably a simple answer...

In the "Using TurboActivate with Visual Basic for Applications (VBA)" example, my Office 365 Excel VBA Compiler is throwing a "User-defined type not defined" error for the following line:

"Dim frmReverify As ReVerifyNow"

Any help would be appreciated.

Thanks

You need to include the frmReverifyNow included in example app.

Thanks. I forgot to import the forms in the API folder!

Actually, now that I look closely, you included "ReVerifyNow.vb" sample source code in the "API/vb.net" folder but did not include "ReVerifyNow.cls" or similar source code in the API/VBA folder, just the "frmReVerifyNow.frm" form. I will try to adapt "ReVerifyNow.vb" to a VBA class unless I am missing something and you have the class defined in VBA somewhere...(the class is not defined in the "TurboActivate.cls" class module you supplied)

I hope I am making sense and thank you in advance.

I also changed the following VBA source code to get the workbook path in Office 365 Excel for Windows to work correctly

GetTADirectory = Application.ActiveWorkbook.Path

Add the frm / frx file in a modern version of VBA and it works. Or open the example xlam file and you'll see it working.

Thank you Wyatt.I now see the code is embedded in the frmMain file and it compiles fine. I was trying to go by your instructions/examples and copy/paste the code into my module as you gave the examples, not realizing it was already coded into the form examples. I should have loaded the xlam file first, you may have mentioned that and I missed it.

Reply
Discard post