dcsimg
Results 1 to 3 of 3

Thread: I've no idea what I'm doing, could someone please help?

  1. #1

    Thread Starter
    New Member
    Join Date
    Dec 2019
    Posts
    1

    I've no idea what I'm doing, could someone please help?

    So long story short, I'm using an excel (passed down from someone else) to collect testing data from something hooked up to an arduino. But when I run it on my laptop, I get a "VBA Project 438 object doesn't support this property or method" error.
    Here's the code, which has the error on line "Public mySerial As...."



    Code:
    Option Explicit
    
    Private nTimer As Date
    Private outputCount As Integer
    
    Public mySerial As ArduinoExcel.ArduinoExcel
    Public product As String
    Public version As String
    
    
    
    'Arduino Excel launch
    'activated pressing [CTRL][a]
    Sub CommanderRun()
    
        product = "ArduinoExcel"
        version = "2.1"
        
        'the program control jumps to the form
        'error 438 here should mean "unregistred dll"
        FormConnect.Show
    
    End Sub
    
    
    Public Sub RunInterrupt()
    
    Dim str As String
    Dim ret As Integer
    
        nTimer = DateAdd("s", 1, Now())
        Application.OnTime nTimer, "RunInterrupt"
    
        'add code here
      
    End Sub
    
    
    Public Sub StopInterrupt()
        
        Application.OnTime nTimer, "RunInterrupt", , False
    
    End Sub
    I have no idea what to change ArduinoExcel.ArduinoExcel to for this to work. I've only learned code in C++ and MATLab =/
    I appreciate any help!

  2. #2
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    103,749

    Re: I've no idea what I'm doing, could someone please help?

    Excel is not a database. If you want help with Excel VBA then you should post in the Office Development forum. I have asked the mods to move this thread. Please don't create a duplicate thread in the mean time.

  3. #3
    PowerPoster
    Join Date
    Oct 2008
    Location
    Midwest Region, United States
    Posts
    3,564

    Re: I've no idea what I'm doing, could someone please help?

    Do you have a reference to "ArduinoExcel?"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width