Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
cadman777
in reply to: WCrihfield

Your instructions are basically what I said above, but in different words.

But I still don't know how to construct the code for that.

 

1. I just tried your code and it threw this error:

'Error on Line 39: Variable 'oBOMRow' hides a variable in an enclosing block'.

Here's what MS says it means:

 

  • Another common source of this error is an attempt to access a local variable declared within a Try block in a separate Catch block. To correct this, declare the variable outside the Try...Catch...Finally structure.

Other Questions:

2. What is 'whatever' supposed to refer back to or forward to?

3. Dim oBOMRow As BOMRow is already declared above the 'For Each' line, so why duplicate it?

I'm guessing that's why that error pops up.

4.  If I Comment-out that duplicate declaration line, the code runs but does the same thing as the other code attempts: The MessageBox pops up and is empty, which tells me that code didn't access the file's iProperty.

 

Did you try your suggestion on this rule, and run on one of your assemblies to see if it works for you?

... Chris
Win 7 Pro 64 bit + IV 2010 Suite
ASUS X79 Deluxe
Intel i7 3820 4.4 O/C
64 Gig ADATA RAM
Nvidia Quadro M5000 8 Gig
3d Connexion Space Navigator