
Hello,
How Can I fix this error in a Great Plains .Package.
I try to load data from excel file.
Run-time error '424'; object required
yellow line : Grid.Height = 234
I attach a line with error.
We migrate GP from v10 to v18 after that We have this error.
When exactly do you get this error message? When attempting to export or import the package file with Dynamics GP 2018 or when?
From what I can find about 'Runtime error 424/object required', it is an error by Excel being unable to access to an 'object' referenced by VBA code. If you open the .package file with NotePad, do you still get the same message?
These 'objects' are anything from a variable, file, worksheet, class or module. If you still have the GP 10 environment, look in VB Editor at all the objects that are added/enabled and maybe do the same on the GP 2018 environment, before then trying to import the package file in.
My thoughts are you may have some VBA in the package file that isn't enabled on the GP 2018 environment, thus causing this type of error.
I would also recommend the following, if you haven't already seen it:
community.dynamics.com/.../dynamics-gp-and-vba-future-considerations
Thank you,