Solved

Excel Object Errors

Posted on 2013-05-10
14
321 Views
Last Modified: 2013-05-28
I'm trying to help out some folks who are using an Excel workbook with macros behind it that I cannot decypher. One of our users can run this but the rest of us can't.

At present, the code blows up on the last line of this code:

Dim InI As Integer
    Dim InJ As Integer
    Dim VaRecLayout_array As Variant
    Dim RnAnchorCell As Range
    Dim WkProgFile As Workbook
    Dim StSheetName As String
    Dim StrArray() As Variant
    Dim ArParse(1 To 2) As Integer
    Dim IntNoCols As Integer
    Dim StDataFilePath As String
    Dim StDataFileName As String
    Dim RnC As Range
    Dim VrResp As Variant
    Dim StFileDate As String
    Dim DblDbControlSum As Double
    Dim DblCrControlSum As Double
    Dim StTrailer As String
    Dim DblDbAmts As Double
    Dim DblCrAmts As Double
    Dim StOutputFile As String
    Dim StProcDate As String
    Dim WkbTRVLRS As Workbook
    Dim fso As New FileSystemObject
    Dim blTrailerFound As Boolean
   
    '----------------------------------------------------------|
    'Intitialize variables
    ReDim ArWkSheets(1)

When I comment out the row, the program blows up with the same error further down. The error is "Cannot load object because it does not exist on this machine."

Obviously there is something in either the Excel settings that needs to be modified, or there is something that needs to be loaded on the other computers that will allow this code to run.

Any suggestions will be appreciated.
0
Comment
Question by:Buck_Beasom
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
14 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39155075
Does the user for whom it works have a different version of Excel/Office or Windows to the rest?
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39155081
ArWkSheets is an array that's not declared.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39155095
You can just use Redim like that without an initial Dim statement.
0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 27

Expert Comment

by:MacroShadow
ID: 39155136
What i meant to say is that the array was not instantiated.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39155174
Not sure what you mean? That line is just redimensioning the array (only objects need to be instantiated)
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39155200
Which array?
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39155273
ArWkSheets - isn't that what we were discussing?
0
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39155300
Yes, and where is that array populated?
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39155325
Presumably somewhere later in the code. Not sure I see the relevance of the question as there hasn't been any attempt to use its members?
0
 
LVL 14

Expert Comment

by:Tommy Kinard
ID: 39156203
isn't ArWkSheets called an object by the compiler? I think this would mean that it may be an  add-in that is not on their machines? Either that or there is a reference that is missing which throws off the compiler.
0
 

Author Comment

by:Buck_Beasom
ID: 39165524
Well, it's nice that all of you are enjoying this discussion, but:

1) The versions are the same and

2) I still have no idea how to diagnose or fix this problem.
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39166319
I don't believe the error relates directly to your code-I think you have a control in use in the workbook that is not available on some machines.
0
 
LVL 27

Accepted Solution

by:
MacroShadow earned 500 total points
ID: 39169132
0
 
LVL 27

Assisted Solution

by:MacroShadow
MacroShadow earned 500 total points
ID: 39169146
Compare the references on their machine with those on yours.  If you see one on theirs which says “missing” you've found the culprit.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel VBA Workbook - Change hours 2 41
Excel - Active X Checkboxes Groups 45 35
Problem to macro 5 20
Zip Codes Excel Spreadsheet 4 24
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Outlook Free & Paid Tools
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question