07-07-2020
05:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
07-07-2020
05:52 AM
At first glance; Public Dim PartPropertiesFileAddr As String = "04_Part_iProperties.xlsm"
looks suspicious is this the correct file you want to use? Also when you are assigning objects to variables it is good to check for null before using them. this will help with debugging or you can use try/catch blocks with a messageBox for these assignment to know exactly where it is failing
Was my reply Helpful ? send a Kudos or accept as solution