tag:blogger.com,1999:blog-51564144489508017802024-03-12T17:20:17.493-07:00Free Excel Downloads With VBA MacrosFree Excel File Samples Downloads with useful and most popular task which could be solved by internal Visual Basic For Applications (VBA) macros and scripts.Unknownnoreply@blogger.comBlogger9125tag:blogger.com,1999:blog-5156414448950801780.post-46215008570889463322016-07-17T23:27:00.000-07:002016-07-22T08:28:11.643-07:00How to place text near line’s and polyline’s center with lengths of lines/polylines with Excel VBA Macro using NanoCAD Free/AutoCAD.If you draw in DWG files lines/polylines which means are cables, electrical, water, gas networks or their segment, next Excel Macro will place to the right side of line/polyline their sizes in automate mode and saves into another file with "_Length_Text" suffix. Our Macro will define all coordinates for lines and polylines on your drawings.<br />
To run our file with Macro use free version of NanoCAD or AutoCAD commercial software.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFVhYgCIPKbkdqulCWGSaYQ-IE-9qkGGaAcpkiGJRM4yyq_aX4jt0rWWU8q-uehiyi9ffjRi-fD59GSSkBw0xzhPd33Kv3jx5MWg1XaI5evO1t_mHbpYTOeGc-vjgiS9jgNjcig07H_Tk/s1600/Place_Line_Length_Text_DWG_Excel_Macro_Settings_Table.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="144" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFVhYgCIPKbkdqulCWGSaYQ-IE-9qkGGaAcpkiGJRM4yyq_aX4jt0rWWU8q-uehiyi9ffjRi-fD59GSSkBw0xzhPd33Kv3jx5MWg1XaI5evO1t_mHbpYTOeGc-vjgiS9jgNjcig07H_Tk/s640/Place_Line_Length_Text_DWG_Excel_Macro_Settings_Table.png" width="640" /></a></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: left;">
<u>NanoCAD users:</u><br />
1. Adjust settings for Microsoft VBA for NanoCAD<br />
<a href="http://free-excel-vba.blogspot.com/2016/07/settings-vba-excel-nanocad-autocad.html" target="_blank">http://free-excel-vba.blogspot.com/2016/07/settings-vba-excel-nanocad-autocad.html</a><br />
2. Download “<a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/Place_Line_Length_Text_DWG_Free-Excel-VBA.Blogspot.com.zip" target="_blank">Place_Line_Length_Text_DWG_NanoCAD.xlsm</a>” Excel file with Macro.<br />
3. Copy all DWG files to the same folder with Excel file. In these DWG files NanoCAD will find all lines and polylines are not in the blocks with “Polyline Color (Red, Green, Blue)”according to Data Table of “Place_Line_Length_Text_DWG_NanoCAD.xlsm” Excel file.<br />
4. Press “ALT+F8” to run “Place_Line_Length_Text_DWG_NanoCAD” macro.<br />
5. Macro will open NanoCAD application and place lines/polylines lengths near center points of them to the right side. Coordinates for all lines/polylines will are detected also, new DWG files with "_Length_Text" suffix will be saved.<br />
<br />
<u>AutoCAD users:</u><br />
1. Adjust settings for Microsoft VBA for AutoCAD<br />
<a href="http://free-excel-vba.blogspot.com/2016/07/settings-vba-excel-nanocad-autocad.html" target="_blank">http://free-excel-vba.blogspot.com/2016/07/settings-vba-excel-nanocad-autocad.html</a><br />
2. Download “<a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/Place_Line_Length_Text_DWG_Free-Excel-VBA.Blogspot.com.zip" target="_blank">Place_Line_Length_Text_DWG_AutoCAD.xlsm</a>” Excel file with Macro.<br />
3. Copy all DWG files to the same folder with Excel file. In these DWG files AutoCAD will find all lines and polylines are not in the blocks with “Polyline Color (Red, Green, Blue)”according to Data Table of “Place_Line_Length_Text_DWG_AutoCAD.xlsm” Excel file.<br />
4. Press “ALT+F8” to run “Place_Line_Length_Text_DWG_AutoCAD” macro.<br />
5. Macro will open AutoCAD application and place lines/polylines lengths near center points of them to the right side. Coordinates for all lines/polylines will are detected also, new DWG files with "_Length_Text" suffix will be saved.<br />
<br />
<u>Known features and limitations:</u><br />
a. Maximum DWG files – 1000.<br />
b. Maximum lines/polylines segments quantity could be found - 10000.<br />
c. Press “Select” button if you need to change color for the lines/polylines. Color codes – Red, Green, Blue, could be defined from your CAD application also.<br />
d. “Number of decimal places” will adjust decimal places for lines/polylines length and coordinates. Must be more or equal to zero.<br />
e. “Text Height” value must be more than zero. Please use “Number” format “Text Height” cell with decimal separator according to Excel/System settings.<br />
<a href="https://support.office.com/en-us/article/Change-the-character-used-to-separate-thousands-or-decimals-c093b545-71cb-4903-b205-aebb9837bd1e" target="_blank">https://support.office.com/en-us/article/Change-the-character-used-to-separate-thousands-or-decimals-c093b545-71cb-4903-b205-aebb9837bd1e</a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe width="848" height="480" src="https://www.youtube.com/embed/BmMTi2Bu-2U" frameborder="0" allowfullscreen></iframe>
</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5156414448950801780.post-57655879469699295462016-07-17T22:28:00.000-07:002016-07-17T22:28:49.543-07:00How to adjust settings for Microsoft Visual Basic for Application to run Excel files with Macros for NanoCAD Free/AutoCADFor NanoCAD Free/AutoCAD automation and Excel files with Macro running please adjust settings for Microsoft Visual Basic for Application please do these steps:<br />
<br />
<u>NanoCAD Free users:</u><br />
<br />
1. Open Excel file, press “ALT+F11” to open Microsoft Visual Basic for Application, then “Tools - References”, add:<br />“nanoCAD Type Library (NCAuto.dll)”<br />“OdaX Type Library (OdaX_csd.dll)”,<br />then press OK.<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEtQ_pJej9vYXXoyxP_Vl1QnLx-z7gtZ6xkGBnGFWPWlupr7bQrHKw7LfZy5iUj9F6Hq9QmQG6GmLQOKmgwLKUdX10-2-F1mp9iyROb3QVRudDioLhk3cH_cLIz4Bq9vk541BmY6IA69c/s1600/NanoCAD_VBA_References.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgEtQ_pJej9vYXXoyxP_Vl1QnLx-z7gtZ6xkGBnGFWPWlupr7bQrHKw7LfZy5iUj9F6Hq9QmQG6GmLQOKmgwLKUdX10-2-F1mp9iyROb3QVRudDioLhk3cH_cLIz4Bq9vk541BmY6IA69c/s1600/NanoCAD_VBA_References.png" /></a></div>
<br />2. Close Microsoft Visual Basic for Application editor.<br />3. Enable Macros in Excel<br /><a href="https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12" target="_blank">https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12</a><br />
<br />
If you need to download and install NanoCAD Free, please follow these steps:<br />
1. Download NanoCAD Free<br /><a href="http://nanocad.com/page/DownloadNanoCAD" target="_blank">http://nanocad.com/page/DownloadNanoCAD</a><br />2. Read official NanoCAD installation guide<br /><a href="http://nanocad.com/page/InstallationGuide" target="_blank">http://nanocad.com/page/InstallationGuide</a><br />In PDF format<br /><a href="http://nanocad.com/images/InstallGuide/InstallGuide.pdf" target="_blank">http://nanocad.com/images/InstallGuide/InstallGuide.pdf</a><br />Use video guide<br /><a href="http://nanocad.com/page/InstallationVideo" target="_blank">http://nanocad.com/page/InstallationVideo</a><br />3. Don’t forget to register and activate NanoCAD Free. <br />
<br />
<u>AutoCAD users:</u><br />
1. Open Excel file, press “ALT+F11” to open Microsoft Visual Basic for Application, then “Tools - References”, add:<br />“AutoCAD YYYY Type Library” file” (acaxXXenu.tlb),<br />where YYYY – YEAR of your AutoCAD Version, XX – 21, 20, 19,…(version number);<br />“AutoCAD Focus Control for VBA Type Library” (AcFocusCtrlXX.dll);<br />“AXDBLib” (axdbXXenu.tlb),<br />then press OK.<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6ipJphbqUh01AL3Ijzp35taie2hF-Afmu3NG8UBSnK4MT5qfI8VfVYr4d4nKxWfL0xaL_PFU9lqsESnCnsC_gn-PPZ-1e3swb_n-JL_snNxWvdRlJVFgOSMgY7B7T7bPttoPokxSUDfY/s1600/ACAD_VBA_References.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6ipJphbqUh01AL3Ijzp35taie2hF-Afmu3NG8UBSnK4MT5qfI8VfVYr4d4nKxWfL0xaL_PFU9lqsESnCnsC_gn-PPZ-1e3swb_n-JL_snNxWvdRlJVFgOSMgY7B7T7bPttoPokxSUDfY/s1600/ACAD_VBA_References.png" /></a></div>
<br /><br />2. Close Microsoft Visual Basic for Application editor.<br />3. Enable Macros in Excel<br /><a href="https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12" target="_blank">https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12</a><br />
<br />Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-5156414448950801780.post-39704516630621028462016-07-13T20:22:00.000-07:002016-07-16T10:06:01.686-07:00How to replace text in multiple blocks of DWG files with Excel VBA Macro using NanoCAD Free/AutoCAD.If your DWG files use blocks for the similar information such as Dates, titles, etc. and these text are placed in multiple places in your drawings, you can automate replacing their text content from the template DWG file to edition DWG file state. If your project DWG files contents 50-100, etc. blocks, manual text replace will take some time. Simply create one template DWG file once and next time change data you need to replace fast in our Excel file with Macro.<br />
For quick text replacement in multiple blocks of DWG files use free version of NanoCAD or AutoCAD commercial software.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXp8SbaDLCMxMBwNRKq55clndYk-kScNgBxXC1RtLNv7Q5BsaqrO9Cnkyo6hRFLAyF7fwwPna7jdeo8-2NAYkWTiwZrHF704mYTQPc8L1HD0CeVxBcgw_9cEr6GqUmNCy-f70GiQc-9OE/s1600/Replace_Text_In_Blocks_Excel_NanoCAD_AutoCAD.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXp8SbaDLCMxMBwNRKq55clndYk-kScNgBxXC1RtLNv7Q5BsaqrO9Cnkyo6hRFLAyF7fwwPna7jdeo8-2NAYkWTiwZrHF704mYTQPc8L1HD0CeVxBcgw_9cEr6GqUmNCy-f70GiQc-9OE/s1600/Replace_Text_In_Blocks_Excel_NanoCAD_AutoCAD.png" /></a></div>
<div style="text-align: center;">
<br /></div>
<br />
<br />
Use NanoCAD Free:<br />
1. Download NanoCAD Free<br />
<a href="http://nanocad.com/page/DownloadNanoCAD">http://nanocad.com/page/DownloadNanoCAD</a><br />
2. Read official NanoCAD installation guide<br />
<a href="http://nanocad.com/page/InstallationGuide">http://nanocad.com/page/InstallationGuide</a><br />
In PDF format<br />
<a href="http://nanocad.com/images/InstallGuide/InstallGuide.pdf">http://nanocad.com/images/InstallGuide/InstallGuide.pdf</a><br />
Use video guide<br />
<a href="http://nanocad.com/page/InstallationVideo">http://nanocad.com/page/InstallationVideo</a><br />
3. Don’t forget to register and activate NanoCAD Free.<br />
4. Download “<a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/Replace_Text_In_Blocks_Excel_Free-Excel-VBA.Blogspot.com.zip" target="_blank">Replace_Text_In_Blocks_Excel_NanoCAD.xlsm</a>” Excel file with Macro.<br />
5. Open Excel file, press “ALT+F11” to open Microsoft Visual Basic for Application, then “Tools - References”, add:<br />
“nanoCAD Type Library (NCAuto.dll)”<br />
“OdaX Type Library (OdaX_csd.dll)”,<br />
then press OK.<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiri0oh9BYv_xR76EUF7SxJx-cm0xnetdiR5K_e06_2e4LPk5jE4Csevbuq6Sg8VoNsQ1aSA7jrhLpdcBhlqU832yX5NTbCe3-HcZyaMySnHb3_2qauJwkOYebDwG1PGuetUUkyiFSuXzE/s1600/NanoCAD_VBA_References.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiri0oh9BYv_xR76EUF7SxJx-cm0xnetdiR5K_e06_2e4LPk5jE4Csevbuq6Sg8VoNsQ1aSA7jrhLpdcBhlqU832yX5NTbCe3-HcZyaMySnHb3_2qauJwkOYebDwG1PGuetUUkyiFSuXzE/s1600/NanoCAD_VBA_References.png" /></a></div>
<div style="text-align: center;">
<br /></div>
<br />
6. Close Microsoft Visual Basic for Application editor.<br />
7. Enable Macros in Excel<br />
<a href="https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12" target="_blank">https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12</a><br />
8. Copy all DWG files to the same folder with Excel file. In these DWG files NanoCAD will replace Text according to Data Table of “Replace_Text_In_Blocks_Excel_NanoCAD.xlsm” Excel file.<br />
9. Press “ALT+F8” to run “Replace_Text_In_Blocks_Excel_NanoCAD” macro.<br />
10. Macro will open NanoCAD application and replace all text in DWG blocks and close DWG files<br />
<br />
Use AutoCAD commercial version:<br />
1. Download “<a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/Replace_Text_In_Blocks_Excel_Free-Excel-VBA.Blogspot.com.zip" target="_blank">Replace_Text_In_Blocks_Excel_AutoCAD.xlsm</a>” Excel file with Macro.<br />
2. Open Excel file, press “ALT+F11” to open Microsoft Visual Basic for Application, then “Tools - References”, add:<br />
“AutoCAD YYYY Type Library” file” (acaxXXenu.tlb),<br />
where YYYY – YEAR of your AutoCAD Version, XX – 21, 20, 19,…(version number);<br />
“AutoCAD Focus Control for VBA Type Library” (AcFocusCtrlXX.dll);<br />
“AXDBLib” (axdbXXenu.tlb),<br />
then press OK.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgG9y2W7RRAgYqmpPFKnAxRymZ7v0yfxMK7JAmBA1_4iE_ADJZZITROO3DC28bHu87bhMjzhm2-3FrtIsnIeBO-iZRC_1SsOgieyZNHvExkJQUQUtlGv14kg7g_DHzw8cyhyMMShZ4ixbM/s1600/ACAD_VBA_References.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgG9y2W7RRAgYqmpPFKnAxRymZ7v0yfxMK7JAmBA1_4iE_ADJZZITROO3DC28bHu87bhMjzhm2-3FrtIsnIeBO-iZRC_1SsOgieyZNHvExkJQUQUtlGv14kg7g_DHzw8cyhyMMShZ4ixbM/s1600/ACAD_VBA_References.png" /></a></div>
<div style="text-align: center;">
<br /></div>
3. Close Microsoft Visual Basic for Application editor.<br />
4. Enable Macros in Excel<br />
<a href="https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12" target="_blank">https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12</a><br />
5 Copy all DWG files to the same folder with Excel file. In these DWG files AutoCAD will replace Text according to Data Table of “Replace_Text_In_Blocks_Excel_AutoCAD.xlsm” Excel file.<br />
6. Press “ALT+F8” to run “Replace_Text_In_Blocks_Excel_AutoCAD” macro.<br />
7. Macro will open AutoCAD application and replace all text in DWG blocks and close DWG files<br />
<br />
<u>Known features and limitations:</u><br />
a. Maximum DWG files – 1000.<br />
b. Maximum different blocks quantity to change/insert text - 65530.<br />
c. “Block Name” cell must contain DWG block name (for example, DATASHEET_TITLE, DATE, DESCRIPTION for “Stepping Motor SH4009l1206 Blocks.dwg” file in ZIP archive). “Block Name” could be A$C26677C24, etc.<br />
d. “Data Type” cell could be: “FullText” or “InternalText”.<br />
For «FullText» Type macro will replace text in blocks which consists of Text/MText DWG objects.<br />
For “InternalText” Type macro will replace text between “Text Before Insert” and “Text After Insert” words in blocks with Text. If you clear “Block Name” cell for “InternalText” Type row macro will insert text in all Text/MText objects that are not in blocks.<br />
e. “Value To Replace/Insert” cell must contains text to replace/insert in blocks or Text/MText DWG objects.<br />
f. “Font Height” cell data will change Text Height where macro replaces the text. Cell format for Font height is a Number with decimal separator according to Excel/System settings.<br />
<a href="https://support.office.com/en-us/article/Change-the-character-used-to-separate-thousands-or-decimals-c093b545-71cb-4903-b205-aebb9837bd1e" target="_blank">https://support.office.com/en-us/article/Change-the-character-used-to-separate-thousands-or-decimals-c093b545-71cb-4903-b205-aebb9837bd1e</a><br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe width="848" height="480" src="https://www.youtube.com/embed/DcEbVSXycUg" frameborder="0" allowfullscreen></iframe>
</div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5156414448950801780.post-42353280930015816492016-07-11T00:21:00.000-07:002016-07-14T08:49:29.113-07:00How to extract tables of lines, polylines and Text, MText from DWG files to Excel with NanoCAD Free/AutoCAD<div style="text-align: justify;">
<div style="text-align: justify;">
For all tables and datasheets which were made as tables of lines, polylines and Text, MText in DWG files you need to manually copy from Text, MText blocks and paste their content to Excel to use data from them. This long process could be automated with Excel file with Macro to create tables of lines, polylines and Text, MText from DWG files to Excel sheets.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
There are two options to extract tables of lines, polylines and Text, MText: use free version of NanoCAD or AutoCAD commercial software.</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Use NanoCAD Free:</div>
<div style="text-align: justify;">
1. Download NanoCAD Free</div>
<div style="text-align: justify;">
<a href="http://nanocad.com/page/DownloadNanoCAD" target="_blank">http://nanocad.com/page/DownloadNanoCAD</a></div>
<div style="text-align: justify;">
2. Read official NanoCAD installation guide</div>
<div style="text-align: justify;">
http://nanocad.com/page/InstallationGuide</div>
<div style="text-align: justify;">
In PDF format</div>
<div style="text-align: justify;">
<a href="http://nanocad.com/images/InstallGuide/InstallGuide.pdf" target="_blank">http://nanocad.com/images/InstallGuide/InstallGuide.pdf</a></div>
<div style="text-align: justify;">
Use video guide</div>
<div style="text-align: justify;">
<a href="http://nanocad.com/page/InstallationVideo" target="_blank">http://nanocad.com/page/InstallationVideo</a></div>
<div style="text-align: justify;">
3. Don’t forget to register and activate NanoCAD Free.</div>
<div style="text-align: justify;">
4. Download “<a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/Extract_Line_Tables_from_DWG_to_Excel_Free-Excel-VBA.Blogspot.com.zip" target="_blank">Extract_Line_Tables_from_DWG_to_Excel_NanoCAD.xlsm</a>” Excel file with Macro.</div>
<div style="text-align: justify;">
5. Open Excel file, press “ALT+F11” to open Microsoft Visual Basic for Application, then “Tools - References”, add:</div>
<div style="text-align: justify;">
“nanoCAD Type Library (NCAuto.dll)”</div>
<div style="text-align: justify;">
“OdaX Type Library (OdaX_csd.dll)”,</div>
<div style="text-align: justify;">
then press OK.</div>
<br /></div>
<div style="text-align: center;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjp1O5ncob-qC6JSAHEvlxWLcRBul7Yc5Ptg13fP-EP0oT2jEE_85wCtWVhuowDXTDqSJDsgn_ud4mWyTTeLzI-p8D84aoKJyVRL_dSbEjlAcq78RRUNAv3_0TWjglkGGDFrFfZ1kHoZok/s1600/NanoCAD_VBA_References.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjp1O5ncob-qC6JSAHEvlxWLcRBul7Yc5Ptg13fP-EP0oT2jEE_85wCtWVhuowDXTDqSJDsgn_ud4mWyTTeLzI-p8D84aoKJyVRL_dSbEjlAcq78RRUNAv3_0TWjglkGGDFrFfZ1kHoZok/s1600/NanoCAD_VBA_References.png" /></a></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjp1O5ncob-qC6JSAHEvlxWLcRBul7Yc5Ptg13fP-EP0oT2jEE_85wCtWVhuowDXTDqSJDsgn_ud4mWyTTeLzI-p8D84aoKJyVRL_dSbEjlAcq78RRUNAv3_0TWjglkGGDFrFfZ1kHoZok/s1600/NanoCAD_VBA_References.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br /></a></div>
<div style="text-align: justify;">
6. Close Microsoft Visual Basic for Application editor.<br />
7. Enable Macros in Excel<br />
<a href="https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12">https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12</a><br />
8. Copy all DWG files to the same folder with Excel file. From these DWG file all tables of lines, polylines and Text, MText will are created on Excel sheets.<br />
9. Press “ALT+F8” to run “Extract_Line_Tables_from_DWG_To_Excel_NanoCAD” macro.<br />
10. Macro will open NanoCAD application and scan all tables of lines, polylines and Text, MText in DWG files. Each created table from DWG file will be placed on a new Excel sheet.<br />
<br />
Use AutoCAD commercial version:<br />
1. Download “<a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/Extract_Line_Tables_from_DWG_to_Excel_Free-Excel-VBA.Blogspot.com.zip" target="_blank">Extract_Line_Tables_from_DWG_to_Excel_AutoCAD.xlsm</a>” Excel file with Macro.<br />
2. Open Excel file, press “ALT+F11” to open Microsoft Visual Basic for Application, then “Tools - References”, add:<br />
“AutoCAD YYYY Type Library” file” (acaxXXenu.tlb),<br />
where YYYY – YEAR of your AutoCAD Version, XX – 21, 20, 19,…(version number);<br />
“AutoCAD Focus Control for VBA Type Library” (AcFocusCtrlXX.dll);<br />
“AXDBLib” (axdbXXenu.tlb),<br />
then press OK.</div>
<div style="text-align: center;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidZyEv3WpPSwxeUUsln3YoSVRlERHDO7PP4bQoXLFPT10qAnYCjsB-JemJ61zBsTHDUHBcHJrsSOhfowFb8U0ueKJH8YCrza76AfPxi9wk1-s5c6qwiW9aAGlU7sou65wW2VHk12-5bGA/s1600/ACAD_VBA_References.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidZyEv3WpPSwxeUUsln3YoSVRlERHDO7PP4bQoXLFPT10qAnYCjsB-JemJ61zBsTHDUHBcHJrsSOhfowFb8U0ueKJH8YCrza76AfPxi9wk1-s5c6qwiW9aAGlU7sou65wW2VHk12-5bGA/s1600/ACAD_VBA_References.png" /></a></div>
</div>
<br />
<div style="text-align: justify;">
3. Close Microsoft Visual Basic for Application editor.<br />
4. Enable Macros in Excel<br />
<a href="https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12">https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12</a><br />
5 Copy all DWG files to the same folder with Excel file. From these DWG file all tables of lines, polylines and Text, MText will are created on Excel sheets.<br />
6. Press “ALT+F8” to run “Extract_Line_Tables_from_DWG_To_Excel_AutoCAD” macro.<br />
7. Macro will open AutoCAD application and and scan all tables of lines, polylines and Text, MText in DWG files. Each created table from DWG file will be placed on a new Excel sheet<br />
<br />
<u>Known features and limitations:</u><br />
a. Maximum DWG files – 1000.<br />
b. There are no limitations for table’s quantity for each DWG file or each layout.<br />
c. Each table contour (outline) must be closed.<br />
d. Each cell must be rectangular, not use “stairs” like cells.<br />
e. All text found in the DWG table cell will are placed in Excel cell by vertical order from top to bottom.<br />
f. Tables in DWG files must be draw with lines, old type polylines (2D polylines), Text and MText basic primitives.<br />
e. If your DWG tables are made of blocks with lines, polylines, please explode them all before running the Macro.<br />
f. If your DWG text are made of blocks with Text, MText, please explode them all before running the Macro also.<br />
g. “Extract_Line_Tables_from_DWG_To_Excel” Macro supports creating merged cells found in DWG files.<br />
h. Macro will extract data even there are no some additional SHX fonts installed for DWG file and the text in NanoCAD Free/AutoCAD is shown as “?????????”.<br />
i. All text from DWG files will be copied as “Text” with “Format Cells”<br />
j. All Fonts formatting – Bold, Italic, etc. will be unformatted according to these specifications:<br />
<a href="https://knowledge.autodesk.com/support/autocad/getting-started/caas/CloudHelp/cloudhelp/2016/ENU/AutoCAD-Core/files/GUID-7D8BB40F-5C4E-4AE5-BD75-9ED7112E5967-htm.html">https://knowledge.autodesk.com/support/autocad/getting-started/caas/CloudHelp/cloudhelp/2016/ENU/AutoCAD-Core/files/GUID-7D8BB40F-5C4E-4AE5-BD75-9ED7112E5967-htm.html</a></div>
<br />
<div style="text-align: center;">
<iframe width="848" height="480" src="https://www.youtube.com/embed/h-groyV4IG4" frameborder="0" allowfullscreen></iframe>
</div>
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-5156414448950801780.post-56524356626840298892016-06-30T07:34:00.000-07:002016-07-04T08:07:40.210-07:00How to extract tables from DWG files to Excel with NanoCAD Free/AutoCADHow to extract tables from DWG files to Excel with NanoCAD Free/AutoCAD<br />
Specialists and engineers are working with DWG files know, that you could not simply extract tables from DWG files and copy their content to Microsoft Excel using Clipboard. For this task please use special Excel file with Macro to import tables from DWG files to Excel sheets.<br />
There are two options to extract: use free version of NanoCAD or AutoCAD commercial software.<br />
Use NanoCAD Free:<br />
1. Download NanoCAD Free<br />
<a href="http://nanocad.com/page/DownloadNanoCAD" target="_blank">http://nanocad.com/page/DownloadNanoCAD</a><br />
2. Read official NanoCAD installation guide<br />
<a href="http://nanocad.com/page/InstallationGuide" target="_blank">http://nanocad.com/page/InstallationGuide</a><br />
In PDF format<br />
<a href="http://nanocad.com/images/InstallGuide/InstallGuide.pdf" target="_blank">http://nanocad.com/images/InstallGuide/InstallGuide.pdf</a><br />
Use video guide<br />
<a href="http://nanocad.com/page/InstallationVideo" target="_blank">http://nanocad.com/page/InstallationVideo</a><br />
3. Don’t forget to register and activate NanoCAD Free.<br />
4. Download “<a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/Extract_Tables_from_DWG_To_Excel_Free-Excel-VBA.Blogspot.com.zip" target="_blank">Extract_Tables_From_DWG_to_Excel_NanoCAD.xlsm</a>” Excel file with Macro or “<a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/Extract_Tables_from_DWG_To_Excel_Free-Excel-VBA.Blogspot.com.zip" target="_blank">Extract_Tables_From_DWG_to_Excel_97-2003_NanoCAD.xls</a>” for Excel 97-2003.<br />
5. Open Excel file, press “ALT+F11” to open Microsoft Visual Basic for Application, then “Tools - References”, add:<br />
“nanoCAD Type Library (NCAuto.dll)”<br />
“OdaX Type Library (OdaX_csd.dll)”,<br />
then press OK.<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfLybrnwB5R-XJORUesZDRE9QnbAuotlUlyv077QlF4abVwPcGL80maiUman4MvY9K8eFttyGfMl_d4dG_oXuzd0X7sIO0WMMroO3lwQAyPgU0jV-d-Arc7EZfVeiCkY3C-A2_aRelU7M/s1600/NanoCAD_VBA_References.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfLybrnwB5R-XJORUesZDRE9QnbAuotlUlyv077QlF4abVwPcGL80maiUman4MvY9K8eFttyGfMl_d4dG_oXuzd0X7sIO0WMMroO3lwQAyPgU0jV-d-Arc7EZfVeiCkY3C-A2_aRelU7M/s1600/NanoCAD_VBA_References.png" /></a></div>
<br />
<br />
<br />
<br />
6. Close Microsoft Visual Basic for Application editor.<br />
7. Enable Macros in Excel<br />
<a href="https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12" target="_blank">https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12</a><br />
8. Copy all DWG files to the same folder with Excel file. From these DWG file all tables will be extracted to Excel sheets.<br />
9. Press “ALT+F8” to run “Extract_Tables_from_DWG_To_Excel_NanoCAD” macro.<br />
10. Macro will open NanoCAD application and extract all tables in DWG files. Each table from DWG file will be placed on a new Excel sheet.<br />
<br />
Use AutoCAD commercial version:<br />
1. Download “<a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/Extract_Tables_from_DWG_To_Excel_Free-Excel-VBA.Blogspot.com.zip" target="_blank">Extract_Tables_from_DWG_to_Excel_AutoCAD.xlsm</a>” Excel file with Macro or “<a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/Extract_Tables_from_DWG_To_Excel_Free-Excel-VBA.Blogspot.com.zip" target="_blank">Extract_Tables_from_DWG_to_Excel_97-2003_AutoCAD.xls</a>” for Excel 97-2003.<br />
2. Open Excel file, press “ALT+F11” to open Microsoft Visual Basic for Application, then “Tools - References”, add:<br />
“AutoCAD YYYY Type Library” file” (acaxXXenu.tlb),<br />
where YYYY – YEAR of your AutoCAD Version, XX – 21, 20, 19,…(version number);<br />
“AutoCAD Focus Control for VBA Type Library” (AcFocusCtrlXX.dll);<br />
“AXDBLib” (axdbXXenu.tlb),<br />
then press OK.<br />
<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiktYS5xUfsJOquG6A5_3jamEXUne_ZwNfW38B_3kOsavtz2uh1qNZyM72DMcIDKNDkVlUN_UWcH8oH0EXJeXZBE3FxbEQPPhK35FaHj2lqOkwWQ4rNUXvWtaepxyvFklRCRsL7vtZmNOQ/s1600/ACAD_VBA_References.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiktYS5xUfsJOquG6A5_3jamEXUne_ZwNfW38B_3kOsavtz2uh1qNZyM72DMcIDKNDkVlUN_UWcH8oH0EXJeXZBE3FxbEQPPhK35FaHj2lqOkwWQ4rNUXvWtaepxyvFklRCRsL7vtZmNOQ/s1600/ACAD_VBA_References.png" /></a></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<br /></div>
3. Close Microsoft Visual Basic for Application editor.<br />
4. Enable Macros in Excel<br />
<a href="https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12" target="_blank">https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12</a><br />
5. Copy all DWG files to the same folder with Excel file. From these DWG file all tables will be extracted to Excel sheets.<br />
6. Press “ALT+F8” to run “Extract_Tables_from_DWG_To_Excel_AutoCAD” macro.<br />
7. Macro will open AutoCAD application and extract all tables in DWG files. Each table from DWG file will be placed on a new Excel sheet.<br />
<br />
<u>Known features and limitations:</u><br />
a. Maximum DWG files – 1000.<br />
b. There are no limitations for table’s quantity for each DWG file.<br />
c. All text from DWG files will be copied as “Text” with “Format Cells”<br />
d. Merged cells will be copied as Unmerged to Excel Cell – to the first left cell.<br />
e. All Fonts formatting – Bold, Italic, etc. will be unformatted according to these specifications:<br />
<a href="https://knowledge.autodesk.com/support/autocad/getting-started/caas/CloudHelp/cloudhelp/2016/ENU/AutoCAD-Core/files/GUID-7D8BB40F-5C4E-4AE5-BD75-9ED7112E5967-htm.html" target="_blank">https://knowledge.autodesk.com/support/autocad/getting-started/caas/CloudHelp/cloudhelp/2016/ENU/AutoCAD-Core/files/GUID-7D8BB40F-5C4E-4AE5-BD75-9ED7112E5967-htm.html</a><br />
<br />
<br />
<div style="text-align: center;">
<iframe allowfullscreen="" frameborder="0" height="480" src="https://www.youtube.com/embed/boZxB7lc6_Y" width="848"></iframe>
</div>
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5156414448950801780.post-15147701071393249842014-03-10T02:50:00.001-07:002014-03-11T07:55:07.401-07:00How to split Excel book with multiple sheets to single filesThis guide shows how to split Excel workbook with multiple sheets into single files. For most compatibility, for ".xls" files (Excel 97-2003) <a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/SplitSheetsToFiles_Free-Excel-VBA.Blogspot.com.zip" target="_blank"><b>SplitSheetsToFiles</b></a> macros will create single ".xls" files, containing only 1 sheet from source Excel book, the same macro's behavior will be for ".xlsx", ".xlsm", ".xlsb" files (Excel 2007, 2010, 2013).<br />
<br />
1. Please <a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/SplitSheetsToFiles_Free-Excel-VBA.Blogspot.com.zip" target="_blank"><b>download SplitSheetsToFiles archive</b></a> and unzip it to HDD.<br />
<br />
2. Import <b>SplitSheetsToFiles.bas</b> Module into your Excel book (<a href="http://free-excel-vba.blogspot.com/2014/03/how-to-import-and-run-excel-macros.html" target="_blank"><b>Read How-To</b></a>). In our <b>SplitSheetsToFiles.xlsm</b> sample workbook contains 3 sheets:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1yPq7wjh3LmRHD1aibWpbRFbctW_X3l2qrN8Z63fhyphenhyphen92Ad4kvyVioIcSVcxLKNkOIOY1L1M4rlCvyH00TXrBNdYEWQCGr5MokZkNE3J1LhvdD6usleeXdDqRTK-Xa-Xs6xQia-4WcSTs/s1600/SplitSheetsToFiles_01_3_Sheets.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="SplitSheetsToFiles_01_3_Sheets_Free-Excel-VBA.Blogspot.com" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1yPq7wjh3LmRHD1aibWpbRFbctW_X3l2qrN8Z63fhyphenhyphen92Ad4kvyVioIcSVcxLKNkOIOY1L1M4rlCvyH00TXrBNdYEWQCGr5MokZkNE3J1LhvdD6usleeXdDqRTK-Xa-Xs6xQia-4WcSTs/s1600/SplitSheetsToFiles_01_3_Sheets.png" title="SplitSheetsToFiles_01_3_Sheets_Free-Excel-VBA.Blogspot.com" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<br />
<br />
3. Please return to sheet in your Excel you need to split into single files.<br />
<br />
4. Please Save your file into HDD as Macro-Enabled Workbook (.xlsm), if you use Excel 2007, 2010, 2013, etc, or Excel 97-2003 Workbook (.xls).<br />
<br />
5. Press "ALT+F8", select "SplitSheetsToFiles" in
"Macro" window and press "Run" button.<br />
<br />
6. In a few moments all sheets from your source Excel workbook will are saved into single files at the same folder, which will contains only 1 sheet in each. Here the listing for our <b>SplitSheetsToFiles.xlsm</b> sample workbook<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijr1wmMPgLtSHQEMmC1XGn5Aw97qtB5gKtrU3M2YUDnx-eaSY6-wISo42p2bBYxmi_ayeuFSSUSvyh_Ic1KYUvhYQEV9SlriZ9NOJiECempGEapZ0uE8k2zW7wUExon1kIQrA0Op4Uogo/s1600/SplitSheetsToFiles_02_File_Listing_After_Splitting.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="SplitSheetsToFiles_02_File_Listing_After_Splitting_Free-Excel-VBA.Blogspot.com" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEijr1wmMPgLtSHQEMmC1XGn5Aw97qtB5gKtrU3M2YUDnx-eaSY6-wISo42p2bBYxmi_ayeuFSSUSvyh_Ic1KYUvhYQEV9SlriZ9NOJiECempGEapZ0uE8k2zW7wUExon1kIQrA0Op4Uogo/s1600/SplitSheetsToFiles_02_File_Listing_After_Splitting.png" title="SplitSheetsToFiles_02_File_Listing_After_Splitting_Free-Excel-VBA.Blogspot.com" /></a></div>
<br />
<b>SplitSheetsToFiles.bas </b>macros features, limitations and error-protections:<br />
a) <b>Macros will not work</b> until you save file into your HDD. If you open existing Excel workbook with "xlsx" extension, import <b>SplitSheetsToFiles.bas </b>and run it, <b>macros will work</b>.<br />
b) Macros creates single file's extension based on source file extension - for ".xlsx" will are created ".xlsx" files, for "xlsm" - "xlsm", for "xlsb" - "xlsb", for "xls" - "xls", even you use Excel 2007, 2010, 2013, etc.<br />
c) Macros <b>will not erase </b>existing workbook files with same names, it will auto-numerate them until a non-existing filename to save will be found. During auto-numeration <b>macros will not exceed</b> 31 symbols maximum length for sheet name.<br />
d) For Excel 2007, 2010, 2013 users in case of Run-time error '1004': "Excel cannot insert the sheets into the destination workbook, because it contains fewer rows and columns than the source workbook. To move or copy the data to the destination workbook, you can select the data, and then use Copy and Paste commands to insert it into the sheets of another workbook." please do: <br />
Select "<b>File</b>" tab, -> "<b>Options</b>" -> "<b>Save</b>" -> "<b>Save workbooks</b>" section -> "<b>Save files in this format:</b>" -> "<b>Excel Workbook (*.xlsx)</b>" or "<b>Excel Macro-Enabled Workbook (*.xlsm)</b>"<br />
Then Press OK button. Restart the Excel and repeat operation from step 2. Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5156414448950801780.post-48354358175650981042014-03-07T05:18:00.000-08:002014-03-07T05:18:10.833-08:00How to make multiple copies of Excel sheet in automatic modeIn this guide will be shown how to make multiple copies of Excel sheet in automatic mode. Two or three sheets could be copied manually very fast, but what about 15 or 50 sheets? Our <a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/AutoSheetsCopy_Free-Excel-VBA.Blogspot.com.zip" target="_blank"><b>AutoSheetsCopy</b></a> macros will make it easily and very fast. It works with any Excel books. Maximum sheets to be added in your book - 1024. <br />
<br />
1. Please <a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/AutoSheetsCopy_Free-Excel-VBA.Blogspot.com.zip" target="_blank"><b>download AutoSheetsCopy ZIP archive</b></a> and unzip it to HDD<b>.</b><br />
<br />
2. <b></b>Import <b>AutoSheetsCopyForm.frm </b>Form file into your Excel book (<a href="http://free-excel-vba.blogspot.com/2014/03/how-to-import-and-run-excel-macros.html" target="_blank"><b>Read How-To</b></a>)<br />
<br />
3. Import <b>AutoSheetsCopyModule.bas</b> Module file into your Excel book (<a href="http://free-excel-vba.blogspot.com/2014/03/how-to-import-and-run-excel-macros.html" target="_blank"><b>Read How-To</b></a>)<br />
<br />
4. Please return to sheet in your Excel you need to copy, press "ALT+F8", select "AutoSheetsCopy" in
"Macro" window and press "Run" button. Initial User Form with "Auto Sheets Copy" caption will appear.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIBqQXzJV6CaH3sJFnU0rkyfIZOGsBAwfDIhTD6FkvZ2uMxBDAwK5zfjPbkxENbMYpIyWISYo-C_wqFwQfkx65ugWBfBLfI_Pu3xjkEa5L3hkZuaBJkptjxXTPVoXI4dLeBDAGcWFY_oE/s1600/AutoSheetsCopy_01_Initial_Window_Free-Excel-VBA.Blogspot.com.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="AutoSheetsCopy_01_Initial_Window_Free-Excel-VBA.Blogspot.com" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIBqQXzJV6CaH3sJFnU0rkyfIZOGsBAwfDIhTD6FkvZ2uMxBDAwK5zfjPbkxENbMYpIyWISYo-C_wqFwQfkx65ugWBfBLfI_Pu3xjkEa5L3hkZuaBJkptjxXTPVoXI4dLeBDAGcWFY_oE/s1600/AutoSheetsCopy_01_Initial_Window_Free-Excel-VBA.Blogspot.com.png" title="AutoSheetsCopy_01_Initial_Window_Free-Excel-VBA.Blogspot.com" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: left;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgn2RQXKa9LO2q_KZAjgX2HDYsM6UxuS-xE8XZmG74zw6yqiVNe3w8TKM7G4xRv8OPDmVUhVhUMjpMTgkG0UJRB2BepzSwsyhnrU0D6I3jtH1oKkKkwieHPEuhLKBFwXY-ejlnSkPeBFBk/s1600/AutoSheetsCopy_02_Select_Copies_Free-Excel-VBA.Blogspot.com.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br /></a></div>
<div class="separator" style="clear: both; text-align: left;">
5. Select (up to 1024) number of copies, then press "Copy" button</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXJGvO1k2msMXDgNq7-Z87Rd8Eb4h2o31EsmVLQfib-g0Pq4S1zHWtVkiO9oUFpuNYitPtjxUYO9mI9ZnkL_Xy4m1Mjpi_LC_VydVzQpo4ycx30qVzJPQrf-JVWepyeZthSdrcSi8OzoM/s1600/AutoSheetsCopy_02_Select_Copies_Free-Excel-VBA.Blogspot.com.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="AutoSheetsCopy_02_Select_Copies_Free-Excel-VBA.Blogspot.com" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXJGvO1k2msMXDgNq7-Z87Rd8Eb4h2o31EsmVLQfib-g0Pq4S1zHWtVkiO9oUFpuNYitPtjxUYO9mI9ZnkL_Xy4m1Mjpi_LC_VydVzQpo4ycx30qVzJPQrf-JVWepyeZthSdrcSi8OzoM/s1600/AutoSheetsCopy_02_Select_Copies_Free-Excel-VBA.Blogspot.com.png" title="AutoSheetsCopy_02_Select_Copies_Free-Excel-VBA.Blogspot.com" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<br />6. In a few moments the sheet you have selected will be copied. By default, new sheets will be named as "Sheet1_2", "Sheet1_3", etc. Maximum length of Excel sheet's name is 31.</div>
<div class="separator" style="clear: both; text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT3BPuBRNCYG8qGmCIcS5gK9Ublr9gCAAXuxmetSz3CqSYwS7kSV61s-EkBoBSlMZiGkshjFlXqFtQ07FCwH_dc4V0ufg6Zwa1W7qs-2bxYSs8YwT6RDi4PyKAkrhVjJyaP36TE6PjBsM/s1600/AutoSheetsCopy_03_Sheet_Copied_Free-Excel-VBA.Blogspot.com.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="AutoSheetsCopy_03_Sheet_Copied_Free-Excel-VBA.Blogspot.com" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT3BPuBRNCYG8qGmCIcS5gK9Ublr9gCAAXuxmetSz3CqSYwS7kSV61s-EkBoBSlMZiGkshjFlXqFtQ07FCwH_dc4V0ufg6Zwa1W7qs-2bxYSs8YwT6RDi4PyKAkrhVjJyaP36TE6PjBsM/s1600/AutoSheetsCopy_03_Sheet_Copied_Free-Excel-VBA.Blogspot.com.png" title="AutoSheetsCopy_03_Sheet_Copied_Free-Excel-VBA.Blogspot.com" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihPuluF53gZZ7PHiL97ZD_ArLsjYf66VimVfxDhF1vX_o6RMtcNdz-k_jX7GKYwDlQRoC1q-S5_2sWfemmlZVYTNZBjwlsy6YQbuLXCP1PGn7F7zb1RBTlKLicwLFVrwlSUi6D8LER7u4/s1600/AutoSheetsCopy_03_Sheet_Copied_Free-Excel-VBA.Blogspot.com.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><br /></a></div>
<br />
<br />Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5156414448950801780.post-20735068382869389942014-03-04T04:21:00.000-08:002014-03-15T09:35:56.243-07:00How to import and run Excel Macros in .bas formatThis guides describes how to import and run Excel Macros in .bas format. Macros importing will work with open Workbook.<br />
1. Please press "ALT+F11" key combination. Microsoft Visual Basic for Applications window will appear.<br />
2. Select from "File" menu - "Import File... (CTRL+M)".<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_-rkC77KI2IfoWzLpuj7iZ5ovOCzjIBV9XeaIW9Bp0yF-4PSy3oxuzmfHK_0OpqeGg_crNCiI-JuPRX2aJJ-IHp6VSWv9goYrqRYCfwSkj6sknuAuEcKtv37S6EdM6HSW6cENo49yv8o/s1600/Import_Module_01_Free-Excel-VBA.Blogspot.com.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Import_Module_01_Free-Excel-VBA.Blogspot.com" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_-rkC77KI2IfoWzLpuj7iZ5ovOCzjIBV9XeaIW9Bp0yF-4PSy3oxuzmfHK_0OpqeGg_crNCiI-JuPRX2aJJ-IHp6VSWv9goYrqRYCfwSkj6sknuAuEcKtv37S6EdM6HSW6cENo49yv8o/s1600/Import_Module_01_Free-Excel-VBA.Blogspot.com.png" title="Import_Module_01_Free-Excel-VBA.Blogspot.com" /></a></div>
<br />
3. Select <a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/TestModule_Free-Excel-VBA.Blogspot.com.bas" target="_blank"><b>TestModule.bas</b> </a>from your hard drive and press "Open" button. New "Module1" will be shown in VBAProject window<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhm5ebMwOVdOLnsKAOdLoS6QkoZyndhuSkPCEj18IEqCTx8NZTVjaeM4Mocg0Qmg-MIrOo_8xGwtyeo_f4R2mTFyddkODqCDcLGnhyGyRzbzqsowTVYNVwEd3yOqM9rEy5mvN0p5rucVKc/s1600/Import_Module_02_View_Code_F7_Key_Free-Excel-VBA.Blogspot.com.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Import_Module_02_View_Code_F7_Key_Free-Excel-VBA.Blogspot.com" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhm5ebMwOVdOLnsKAOdLoS6QkoZyndhuSkPCEj18IEqCTx8NZTVjaeM4Mocg0Qmg-MIrOo_8xGwtyeo_f4R2mTFyddkODqCDcLGnhyGyRzbzqsowTVYNVwEd3yOqM9rEy5mvN0p5rucVKc/s1600/Import_Module_02_View_Code_F7_Key_Free-Excel-VBA.Blogspot.com.png" title="Import_Module_02_View_Code_F7_Key_Free-Excel-VBA.Blogspot.com" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
4. To View Macros code right click and select "View Code". "TestModule" VBA macros code will be shown<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYqJbIQxjMFzWUK9BftIi5ASmJVNHMejTN98WmOM14RhXzZcJzgal2KW1JhSHmuRXMMPPKfu2ajsjUMyPCYTbgrtJJ7ii9MYz-8fQN3VQVwwRwEegcVp7bQywJM-qXcEdZN3TUfncV5Vs/s1600/Import_Module_03_View_Code_Window_Free-Excel-VBA.Blogspot.com.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Import_Module_03_View_Code_Window_Free-Excel-VBA.Blogspot.com" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYqJbIQxjMFzWUK9BftIi5ASmJVNHMejTN98WmOM14RhXzZcJzgal2KW1JhSHmuRXMMPPKfu2ajsjUMyPCYTbgrtJJ7ii9MYz-8fQN3VQVwwRwEegcVp7bQywJM-qXcEdZN3TUfncV5Vs/s1600/Import_Module_03_View_Code_Window_Free-Excel-VBA.Blogspot.com.png" title="Import_Module_03_View_Code_Window_Free-Excel-VBA.Blogspot.com" /></a></div>
<br />
<br />
5. Please return to Sheet1 window, press "ALT+F8", select "TestModule" in "Macro" window and press "Run" button.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbDzetgdCgYmuB189r4oNoDJio1p53DoN4-ZdjV-E55nPHZI75VEgn_AMLWA9xBcYA3fcuTbTU_nx8ncuZCLsOJlXpnVCic5HHSs7jnWQxV0l8uyf98moNFeSYCbV404SYOmCiyugrcJo/s1600/ALT_F8_Eng_Free-Excel-VBA.Blogspot.com.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="ALT_F8_Eng_Free-Excel-VBA.Blogspot.com" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbDzetgdCgYmuB189r4oNoDJio1p53DoN4-ZdjV-E55nPHZI75VEgn_AMLWA9xBcYA3fcuTbTU_nx8ncuZCLsOJlXpnVCic5HHSs7jnWQxV0l8uyf98moNFeSYCbV404SYOmCiyugrcJo/s1600/ALT_F8_Eng_Free-Excel-VBA.Blogspot.com.png" title="ALT_F8_Eng_Free-Excel-VBA.Blogspot.com" /></a></div>
<br />
<br />
Your VBA macros in .bas format will be executed. These are results of <b><a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/TestModule_Free-Excel-VBA.Blogspot.com.bas" target="_blank">TestModule.bas</a></b> macros running. You can <b><a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/Book1_With_TestModule_Free-Excel-VBA.Blogspot.com.xls" target="_blank">download Book1 XLS file with TestModule</a></b>.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTfMpHEumFTLXr67Jfm20ZCxZiQgi67rfBfxDY05IBp99waECGizjZ1Ju7BTDY7W4uD7u5fQCHTVlGzMBfvt0QVyEn72hyfhzWhs9lOeoT-uDeFg9JvYpPzpNwhNbhqgJACoI7nl94ohI/s1600/Import_Module_04_Macros_Result_Free-Excel-VBA.Blogspot.com.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Import_Module_04_Macros_Result_Free-Excel-VBA.Blogspot.com" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTfMpHEumFTLXr67Jfm20ZCxZiQgi67rfBfxDY05IBp99waECGizjZ1Ju7BTDY7W4uD7u5fQCHTVlGzMBfvt0QVyEn72hyfhzWhs9lOeoT-uDeFg9JvYpPzpNwhNbhqgJACoI7nl94ohI/s1600/Import_Module_04_Macros_Result_Free-Excel-VBA.Blogspot.com.png" title="Import_Module_04_Macros_Result_Free-Excel-VBA.Blogspot.com" /></a></div>
<br />
<br />
Video guide:<br />
<br />
<iframe width="853" height="480" src="//www.youtube.com/embed/Z6Z-gKxyH3U?rel=0" frameborder="0" allowfullscreen></iframe>
<br />
<br />
Unknownnoreply@blogger.comtag:blogger.com,1999:blog-5156414448950801780.post-30713007309507740992014-02-26T05:03:00.003-08:002014-03-14T23:08:00.748-07:00Passwords GeneratorFor some purposes IT specialists, for example, could be needed to obtain base with passwords to use them in their networks, domains, work groups, etc. So, we present Excel based password generator powered by VBA macro.<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlYyo4dlzjrTz_Nr_nNFAE10IDN-RPRyImaPPzjX0XAcPlhVfMAEqe9fQmv5eu-i6tB-jaFqkVHc2aR1PeVEXG0BrVGFfluYbFcz37jO8ORycMhooEHpOmeozQzyuVhZ97ZJvzA-VIo58/s1600/Passwords_Generator_Free-Excel-VBA.Blogspot.com.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlYyo4dlzjrTz_Nr_nNFAE10IDN-RPRyImaPPzjX0XAcPlhVfMAEqe9fQmv5eu-i6tB-jaFqkVHc2aR1PeVEXG0BrVGFfluYbFcz37jO8ORycMhooEHpOmeozQzyuVhZ97ZJvzA-VIo58/s1600/Passwords_Generator_Free-Excel-VBA.Blogspot.com.png" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Passwords Generator Free-Excel-VBA.Blogspot.com</td></tr>
</tbody></table>
<br />
Password Generator user need to change quantity (15 as shown in a screen), password length (from 1 to 255), and symbols to use in your passwords listings. Then Press "Alt+F8", select "Passwords_Generator" macro and then press "Run" button. Maximum passwords: 65530, maximum password length: 255 symbols. Default symbols:<br />
!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~<br />
You can change, add, modify symbols string - your passwords will be generated with them only.<br />
If there will are some errors, macro will generate 25 passwords with 8 symbols in each.<br />
For blank symbols string macro will use "0123456789" string.<br />
There are no hidden activities, such as password "stealing", sending, accumulating. You can view source code by pressing "Alt+F11" to check it. <br />
Macro compatibility: MS Excel 97, 2000, 2003, 2007, 2010, 2013<br />
<br />
<a href="http://beginwithsoftware.com/free-vba-excel-scripts-downloads/samples/Passwords_Generator_Free-Excel-VBA.Blogspot.com.xls"><b>Download Excel Passwords Generator [41 KBytes]</b></a><br />
<br />
Video tutorial:<br />
<br />
<iframe width="853" height="480" src="//www.youtube.com/embed/uufsGtETAyQ?rel=0" frameborder="0" allowfullscreen></iframe>
<br />
<br />Unknownnoreply@blogger.com