Solved

Excel Object Errors

Posted on 2013-05-10
14
317 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
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

828 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