Good morning all,
The situation is that my company has recently made the change to using a laser to create some of our components rather than stamping them. The trouble comes with the creation of to scale, perfectly accurate parts, due to human error and time constraints its something that's left best to a program to do rather than a draftsman. I have 90 percent of the program working just fine but I have ran into an issue with the way we do indented bill of materials in our drawings. The program takes input from the user and calculates things such as strip width, weight, etc and pastes those values into a linked excel sheet. When those values paste into the sheet they do not automatically update, but if I open the sheet it will dump all of the values where they should be. I cant seem to figure out a way to either open the sheet with VBA and make it update or find a way to make the sheet update without opening it. The sheet is on a layer called Excel, the handle is 4536, and it is in paper space. I have tried to select the object and sent the openole command via the command line but the program stops and autocad prompts the user to select a second point so that doesn't seem to be the answer. Any help is very much appreciated and I hope everyone has a safe and enjoyable holiday.
