Working with eCabinets cut list in excel

Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Scott G Vaal

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Mon, Jul 18 2016, 9:46AM

Scott Marshburn wrote:Hi. Guys. I just finished the first video on making a time tracking application in excel.
https://www.youtube.com/playlist?list=P ... A2cYsbVtvA
In my previous post, I gave you guys a workbook that I started on. In the intro video, I asked for any suggestions and/ or feedback. One suggestion was to make it look and act like an actual application. So I am starting a completely new program. You can download that workbook here. https://dl.orangedox.com/H2fsbMP7mMSixNaqY9Then click on the video link and follow along. Please let me know what you think.

My Bad. The link to the workbook seems to be not working. so please try this one. https://dl.orangedox.com/urUWU9BgvFQXUB8fEz
Also here is the link to the video again. Just in case I screwed it up too. https://www.youtube.com/watch?v=KcWStIq ... vA&index=1
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Mon, Jul 18 2016, 9:46AM

Scott Marshburn wrote:Hi. Guys. I just finished the first video on making a time tracking application in excel.
https://www.youtube.com/playlist?list=P ... A2cYsbVtvA
In my previous post, I gave you guys a workbook that I started on. In the intro video, I asked for any suggestions and/ or feedback. One suggestion was to make it look and act like an actual application. So I am starting a completely new program. You can download that workbook here. https://dl.orangedox.com/H2fsbMP7mMSixNaqY9Then click on the video link and follow along. Please let me know what you think.

My Bad. The link to the workbook seems to be not working. so please try this one. https://dl.orangedox.com/urUWU9BgvFQXUB8fEz
Also here is the link to the video again. Just in case I screwed it up too. https://www.youtube.com/watch?v=KcWStIq ... vA&index=1
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Sun, Jul 24 2016, 6:29PM

Hi. Here is my latest video on making a time tracking application with excel. Just in case anyone is interested.
You can check it out herehttps://www.youtube.com/watch?v=AGR ... A2cYsbVtvA
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Sat, Sep 03 2016, 2:54PM

Here is my latest video.
Making a time tracking application with excel part3
https://www.youtube.com/watch?v=ODhZY3p ... _w&index=4
In this video, I will show you how to add a toolbar and scroll bars to the application's interface and more. be sure to watch the entire video
You can download this workbook and follow along here.
https://dl.orangedox.com/b8YsbkQYNzs0224YmV

Be sure to like share and comment

Subscribe → https://www.youtube.com/user/ecabinetst ... irmation=1
You can also follow me on:
Facebook→ https://www.facebook.com/ecabinetstipsandtricks
Twitter→ https://twitter.com/eCabinetstips
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Sat, Sep 24 2016, 4:05PM

Hi guys. Check out my latest video on making a time tracking application in excel. https://www.youtube.com/watch?v=kKErw2d ... &index=1In this video, I will show you how you can make a restore down icon and place it on the application's toolbar. To do this I will be using MS Word and a free photo editing software called Gimp. if you want to download the workbook and follow along you can download it here https://dl.orangedox.com/eClaE1RwYP0yz808Fw

Be sure to like share and comment

Subscribe → https://www.youtube.com/user/ecabinetst ... irmation=1
You can also follow me on:
Facebook→ https://www.facebook.com/ecabinetstipsandtricks
Twitter→ https://twitter.com/eCabinetstips
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Wed, Oct 12 2016, 8:30AM

Making a time tracking application in excel part 5.
In this video, I will be adding the rest of the Restore buttons to the toolbar. I will be using a frame control that will allow all three images to be grouped together. You can watch it here.
https://www.youtube.com/watch?v=xznPCog ... A2cYsbVtvA

Be sure to like share and comment

Subscribe → https://www.youtube.com/user/ecabinetst ... irmation=1
You can also follow me on:
Facebook→ https://www.facebook.com/ecabinetstipsandtricks
Twitter→ https://twitter.com/eCabinetstips
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Mon, Oct 31 2016, 12:44PM

Here is my latest video on making a time tracking application in excel
Making a time tracking application in excel vba part6
https://www.youtube.com/watch?v=cQTWMSW ... ICSCEeDQ_w
In this video I will show you how to use the mouse move event to program the restore buttons to make them change colors when you hover over them.
Please like and share this video if it helps you.
Make sure to subscribe to my channel so you can get all of my latest tips and tricks
https://www.youtube.com/user/ecabinetst ... irmation=1
You can also follow me on
Facebook
https://www.facebook.com/ecabinetstipsandtricks
Twitter
https://twitter.com/eCabinetstips
download this workbook here
https://www.dropbox.com/s/2qb35zxipmuqo ... .xlsb?dl=0
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Wed, Oct 25 2017, 11:50AM

Hey Guys.
I have started a new video series where I demonstrate how to build an excel workbook to export Items into the batch area. If you use the batch area often you may find this very useful. I will show how to use excel power query AKA get and transform to create a dynamic link to the ecabinets folder in your user data path that can easily be updated when you add a new library or a new cabinet to an existing library.
here is a link to part1 if you are interested. https://www.youtube.com/watch?v=id6tBZK ... vA&index=1
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Stuart Douglas
Junior Member
Posts: 72
Joined: Fri, Apr 10 2015, 7:57AM
Company Name: Bergman Custom Casework LLC
Country: UNITED STATES

Re: Working with eCabinets cut list in excel

Postby Stuart Douglas » Wed, Oct 25 2017, 12:35PM

Scott Marshburn wrote:Hey Guys.
I have started a new video series where I demonstrate how to build an excel workbook to export Items into the batch area. If you use the batch area often you may find this very useful. I will show how to use excel power query AKA get and transform to create a dynamic link to the ecabinets folder in your user data path that can easily be updated when you add a new library or a new cabinet to an existing library.
here is a link to part1 if you are interested. https://www.youtube.com/watch?v=id6tBZK ... vA&index=1


Scott, Have you had trouble with the latest windows updates destroying the functionality of the export function? I have been unable to uninstall the updates that Win 10 automatically performs, and have had to revert to doing manual cutlists again. Just wondering if there are any workarounds for this yet that you know of.

I love your vids, keep up the good work, they make many processes quicker and easier!

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Wed, Oct 25 2017, 1:25PM

Scott, Have you had trouble with the latest windows updates destroying the functionality of the export function? I have been unable to uninstall the updates that Win 10 automatically performs, and have had to revert to doing manual cutlists again. Just wondering if there are any workarounds for this yet that you know of.

I love your vids, keep up the good work, they make many processes quicker and easier!


Thank you very much.I am running windows8. I found the update that was causing the issue and uninstalled it. then in order to prevent the update from installing again, I turned off auto-updates. and chose the option to download updates but let me choose the ones I wanted to install. However, from my reasurch I have currently have not found a way to turn off auto updates in windows 10. Maby one of the programmers will chime in and help with this.
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Mon, Oct 30 2017, 8:42AM

Here is video number2 on how to create an excel workbook to Add data to eCabinets Batch Using excel spreadsheets
In this video, you will Learn how you can use power query extract the Item names, Types, and directories from eCabinets into the excel batch export workbook. click the link below to check it out.
https://www.youtube.com/watch?v=X4EoDHo ... vA&index=1
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Wed, Nov 01 2017, 11:00AM

Here is video number3 on how to create an excel workbook to Add data to eCabinets Batch Using excel spreadsheets Click the link below to check it out
https://www.youtube.com/watch?v=vVfujSR ... A2cYsbVtvA
In this video, you will learn how to create a pivot table and slicers to summarize and filter the data that was imported into the batch export workbook.
Be sure to check out parts 1 and 2
Add Data To eCabinets Batch using Excel Spreadsheets Part1→ https://www.youtube.com/watch?v=id6tBZK ... vA&index=2
Add Data To eCabinets Batch using Excel Spreadsheets Part2→ https://www.youtube.com/watch?v=X4EoDHo ... vA&index=1


Subscribe here→ https://goo.gl/xaqyej
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Wed, Nov 08 2017, 4:20PM

Here is video number4 on how to create an excel workbook to Add data to eCabinets Batch Using excel spreadsheets Click the link below to check it out
https://www.youtube.com/playlist?list=P ... smZNENKphk

In this video, You will learn how to make a dynamic named range as well as static named ranges.Then I will show you how to create the data validation dropdown list that will allow you to select the Item name, directory, and type.

If you have not watched Parts 1,2 or 3 you can check them out here


To get all of my latest tips and tricks Subscribe here https://goo.gl/xaqyej
Be sure to check out parts 1,2 and 3
Add Data To eCabinets Batch using Excel Spreadsheets Part1→ https://www.youtube.com/watch?v=id6tBZK ... vA&index=2
Add Data To eCabinets Batch using Excel Spreadsheets Part2→ https://www.youtube.com/watch?v=X4EoDHo ... vA&index=1
Add Data To eCabinets Batch using Excel Spreadsheets Part3→ https://www.youtube.com/watch?v=vVfujSR ... hk&index=3

Subscribe here→ https://goo.gl/xaqyej
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: Working with eCabinets cut list in excel

Postby Scott Marshburn » Tue, Nov 14 2017, 6:57AM

Add data to eCabinets Batch Using excel spreadsheets Part5
https://www.youtube.com/watch?v=OK2EFTH ... hk&index=5
In this video, you will learn how to add a new library to the cabinets folder. Then I will show you how to refresh the query that will update the new data that was added to eCabinets. Also I will show you how to import your data into eCabinets Batch.
If you have not watched the previous videos in this series be sure to check them out here→ https://www.youtube.com/playlist?list=P ... smZNENKphk
Subscribe here https://goo.gl/xaqyej

-- Scott Marshburn,https://www.youtube.com/user/ecabinetstips, FaceBook, https://www.facebook.com/ecabinetstipsandtricks, Twitter, https://twitter.com/eCabinetstips
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips


Return to “eCabinet Systems Software”

Who is online

Users browsing this forum: No registered users and 4 guests