Object reference not set to an instance - oCurrentNumber = oDoc.ActiveSheet

Object reference not set to an instance - oCurrentNumber = oDoc.ActiveSheet

andrew_canfield
Collaborator Collaborator
980 Views
3 Replies
Message 1 of 4

Object reference not set to an instance - oCurrentNumber = oDoc.ActiveSheet

andrew_canfield
Collaborator
Collaborator

I'm pretty sure this was working Friday afternoon - test again Monday morning & an error's appeared!

 

Object reference not set to an instance of an object.

 

The problem is this line: 

oCurrentNumber = oDoc.ActiveSheet

 

SyntaxEditor Code Snippet

ThisDrawing.ResourceFileName = "C:\Vault Views\PDM01\Templates\test1.idw"
ThisDrawing.KeepExtraResources = True

MessageBox.Show("Line 4", "Title")

Dim oDoc As DrawingDocument

MessageBox.Show("Line 8", "Title")

Dim oCurrentNumber  As Sheet

MessageBox.Show("Line 12", "Title")

oCurrentNumber = oDoc.ActiveSheet

MessageBox.Show("Line 16", "Title")

oCurrentNumber.Activate

 Regards

 

Andrew

0 Likes
Accepted solutions (1)
981 Views
3 Replies
Replies (3)
Message 2 of 4

bradeneuropeArthur
Mentor
Mentor
Accepted solution

oDoc is not set!!!

oDoc = thisapplication.activedocument maybe?

Regards,

Arthur Knoors

Autodesk Affiliations & Links:
blue LinkedIn LogoSquare Youtube Logo Isolated on White Background


Autodesk Software:Inventor Professional 2025 | Vault Professional 2024 | Autocad Mechanical 2024
Programming Skills:Vba | Vb.net (Add ins Vault / Inventor, Applications) | I-logic
Programming Examples:
Drawing List!|
Toggle Drawing Sheet!|
Workplane Resize!|
Drawing View Locker!|
Multi Sheet to Mono Sheet!|
Drawing Weld Symbols!|
Drawing View Label Align!|
Open From Balloon!|
Model State Lock!
Posts and Ideas:
My Ideas|
Dimension Component!|
Partlist Export!|
Derive I-properties!|
Vault Prompts Via API!|
Vault Handbook/Manual!|
Drawing Toggle Sheets!|
Vault Defer Update!

! For administrative reasons, please mark a "Solution as solved" when the issue is solved !


 


EESignature

0 Likes
Message 3 of 4

andrew_canfield
Collaborator
Collaborator

thanks

0 Likes
Message 4 of 4

bradeneuropeArthur
Mentor
Mentor

Hi,

 

Your thanks are appreciated.

 

have a nice day.

 

Regards,

Autodesk Software: Inventor Professional 2018 | Vault Professional 2018 | Autocad Mechanical 2018
Programming Skills: Vba | Vb.net (Add ins Vault / Inventor, Applications) | I-logic
Dimension Component! | Partlist Export! | Derive I-properties! | Vault Prompts Via API! | Vault Handbook/Manual!
Drawing Toggle Sheets! | Vault Defer Update!

! For administrative reasons, please mark a "Solution as solved" when the issue is solved !

Regards,

Arthur Knoors

Autodesk Affiliations & Links:
blue LinkedIn LogoSquare Youtube Logo Isolated on White Background


Autodesk Software:Inventor Professional 2025 | Vault Professional 2024 | Autocad Mechanical 2024
Programming Skills:Vba | Vb.net (Add ins Vault / Inventor, Applications) | I-logic
Programming Examples:
Drawing List!|
Toggle Drawing Sheet!|
Workplane Resize!|
Drawing View Locker!|
Multi Sheet to Mono Sheet!|
Drawing Weld Symbols!|
Drawing View Label Align!|
Open From Balloon!|
Model State Lock!
Posts and Ideas:
My Ideas|
Dimension Component!|
Partlist Export!|
Derive I-properties!|
Vault Prompts Via API!|
Vault Handbook/Manual!|
Drawing Toggle Sheets!|
Vault Defer Update!

! For administrative reasons, please mark a "Solution as solved" when the issue is solved !


 


EESignature

0 Likes