Assistance Needed Formatting Autocad to Excel Lisp Routine

Hello. Attached I have a code for an AutoCAD Lisp routine that takes Excel information and puts it into Autocad. I'm trying to format it so that I can actually use it but I've been at it an hour now and my coding abilities just flat out suck. I would greatly appreciate if anyone would be willing to help me with this. I know this is something that you do in 5 minutes (or maybe some of you do, idk). I'm kind of up a creek right now though. Code is attached and Path information is below if you're willing to help. Please and thank you.

Path: C:\Users\WilliaC2\Desktop\Excel\BuildMyBOM(test).xlsm
Sheet: BOM
Cell Range: C7:H7

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

Use concise, accurate thread titles.
Your post title should describe your problem, not your anticipated solution.
Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

When you have changed the title, please also give full details of the problem in the body of your post - nobody should have to open an attachment to find out what you want.

Also, to cut off further delay include the sample file.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Try compressing the CAD file and uploading it. Hopefully it will be readable, so we know what format you are trying to translate from / to.

Alas, I cannot decipher the format of the dwg file. Is there some sort of import / export format you are trying to match?

I took the liberty of doing a couple of things to your workbook based on my understanding of the requirement. I didn't change much so if I got it wrong, it should be easy to fix.

First I made a table out of the data on the BOM sheet. I also made a table out of your data and reset the source data to it. Excel tables have many benefits but the one that is most important here is that Excel Tables know how big they are. So as you clear data and copy and paste in new data, the pivot table will know exactly how much data it has to reference regardless of how many rows wind up in the table. A similar concept works for the BOM sheet: the table contains only as much data as it needs.

Here is more information on Excel Tables: http://www.utteraccess.com/wiki/Tables_in_Excel.

On the BOM sheet I changed the macro that the Reset Button runs. It empties the table (again, tables know how big they are).

On the BuildMyBOM sheet, I checked out the Reset Button. It appears to work. I noticed that the BOM button is assigned to a macro that doesn't exist. I changed the code behind the Add To BOM button. It takes the selected line on the BuildMyBOM worksheet and adds it to the BOM.

Which brings me back to the BOM sheet. I have several questions:
- BOM Line: the code copies over the BOM line from the BuildMyBOM sheet. Do you want this to be sequential instead, starting with 1?
- Apparently the requirement is to export the BOM sheet so it can be imported elsewhere. What format (XLSX, CSV, etc.) do you want this, and do you have a preference for a file name?
- Do you want the column headers to reflect what you sent in the PDF?

I changed the data sheet into a table as a matter of efficiency. There was no issue with it not being a table, but making it a table makes the application more maintainable.

I made a slight mod. The BOM now comes out numbered 1, 2, 3, etc. regardless of the number on the main form.

I'll finish up tomorrow. I'll assume that what you need is a comma-separated-variable file (CSV) - that's a very common format for import / export.

In the meantime, you can play with this version.

What is the name of the program you are working with? Maybe I can get some information about import formats on line.

This link: https://knowledge.autodesk.com/suppo...9-to-2012.html

Shows the type of files that can be imported into autocad. The only one I can support is PDF, so I will design to that. I know almost nothing about AutoCad, but I am assuming that it will import the PDF so it can be "attached" to a drawing.

I should have it shortly.

Here it is. I will explain in the next post when I can figure out what part of the text is causing the post to be rejected.

Click on the Build My BOM rectangle and you will be prompted for a file name. Filenames cannot have certain characters like slash or asterisk or colon and several others. I happen to have a routine on hand that cleans these out. You will be show the clean file name for confirmation. The PDF File will be created in the same directory as the workbook.

Judging from what I read in the AutoCad documentation, this will come in as a "picture" that can be added to a drawing. In this case, you probably do want the BOM table headers. That is what I programmed in. If it turns out that you just want the data (no headers),
Change

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

I had to put spaces between the code and the brackets to keep the censoring software from blocking this post. Type out what you see without the spaces or copy and paste and then remove the spaces.