I'm using Excel to make a small spreadsheet that I then paste in to my dwg file. I'm trying to get excel to autoscale the table based on the dwg scale that I'm using. It worked great on the small scale drawings but when I'm getting to our larger drawing scales (like 1:64) the font I need in excel to match the drawing scale exceeds the maximum font size excel allows (size 409).
My next idea was to convert the spreadsheet to a jpeg and then scale that jpeg appropriately to match the dwg scale. However, when I paste these jpegs into autocad they are scaled by the current view I'm at. To clarify, the size of the jpg is the same relative to my window size no matter how far I'm zoomed in to the drawing. If I'm at full size and paste the jpeg in, it takes up a 3" x 5" area of my screen. If I zoom in on a tiny detail, the jpeg pastes in as a 3" x 5" area of my screen.
Is there any way I can lock this scaling and prevent it from happening?
Model space is exclusively used at our company.
And the purpose of the spreadsheet document and created table is to quickly make a unique table for each drawing. I'd like to not have to resize each element as it's pasted into model space.
I do understand the Table Element and feel it wont give me the level of automation I need. Thank you for your time.
What level of automation do you need?
Is it all singing, all dancing or just "Stick this table here"?
Howard Walker
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
I'm making a userform in excel where you can check boxes for the different processes that need to occur for an item (cut to length, mitered, etc.). The number of rows in this table, contents of the table, and the size of the font all vary drawing to drawing. These are all generated by a userform and saved temporarily in the program excel sheet.
When the drawing scale was small enough, pasting excel tables in the drawing worked perfectly. However, on the larger scale drawings I was limited by excel's maximum font size of 409. It was suggested to try converting these to jpegs and inserting and that is when I ran in to my current problem.
Howard Walker
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.