Buck Beasom
asked on
Excel Object Errors
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.
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.
Does the user for whom it works have a different version of Excel/Office or Windows to the rest?
ArWkSheets is an array that's not declared.
You can just use Redim like that without an initial Dim statement.
What i meant to say is that the array was not instantiated.
Not sure what you mean? That line is just redimensioning the array (only objects need to be instantiated)
Which array?
ArWkSheets - isn't that what we were discussing?
Yes, and where is that array populated?
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?
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.
ASKER
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.
1) The versions are the same and
2) I still have no idea how to diagnose or fix this problem.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.