James Pieri, Supply Chain Specialist, Systems & Solution Architect
0 FOLLOWERS
James Pieri is a supply chain management specialist with fifteen years experience in operations, planning, project management and implementation of digital projects for major multicultural organizations.
James Pieri, Supply Chain Specialist, Systems & Solution Architect
3y ago
What Happened?
COVID-19 changed a lot of things for me in 2020, as I’m sure it did with a lot of you. For starters, I was home a LOT more. Not really by choice, but there was just nowhere to go with things being closed. The supermarkets were insane, lines were wrapped around Target, and for some reason – people who ate nothing but toilet paper revealed themselves by securing their food supply immediately.
Before COVID, a lot of people had the ability to work from home, but did it just one or two days a week as needed. But now, most people who could do their job from home, began working from ho ..read more
James Pieri, Supply Chain Specialist, Systems & Solution Architect
5y ago
This is a quick one, but a great snippet of code to have. This will add a new worksheet to your workbook and rename it to whatever you set. It’s only two lines, and very easy to place anywhere you need it.
'This line of code creates the new sheet
Set NewSheet = Sheets.Add(After:=Sheets(Worksheets.Count), _
Count:=1, Type:=xlWorksheet)
'This line of code will rename it
NewSheet.Name = "Purchase_Orders"
It’s that simple. Just enter this line anywhere you need a new worksheet ..read more
James Pieri, Supply Chain Specialist, Systems & Solution Architect
5y ago
I worked on a project once where a bot connected to a production line would send status emails with attachments on production rates to an email address we had setup. This was great, except, the bot sent an email every hour, and the attachments piled up. We could create a rule to take the email and file it in a specific folder, but what about the attachment?
Well, don’t fret, because there’s a way you can run that Outlook rule and have a simple VBA script execute to save the attachment from the email in a specific folder on your machine.
If you go to create a rule in Outlook and don’t s ..read more
James Pieri, Supply Chain Specialist, Systems & Solution Architect
5y ago
Let’s say you’re working on automating a workbook and after formatting and manipulating the data, you want to save a specific worksheet to it’s own workbook by itself somewhere for use in some other application or to share.
You can easily do that.
This block of code can do a few different things, but I will run through the different scenarios and show you what you can do, why you would do it, and what the differences in code means.
Scenario 1: Saving a Worksheet in One Place
This first block of code simply takes the active worksheet and saves it in a location you specify ..read more
James Pieri, Supply Chain Specialist, Systems & Solution Architect
5y ago
I was asked today how I was able to do something for a previous project that involved executing a VBA script everytime an outlook rule ran, and it sparked the thought that I should include it on here to be able to share it with anyone else who may be interested.
BUT, the problem with running a script in Outlook is that most organizations have disabled outlook scripts from executing as a security threat. So the image above may not reflect what you see in your rules. The ‘run a script’ option, may not be listed at all.
The good news is, you can edit the registry to have that ‘run a script ..read more
James Pieri, Supply Chain Specialist, Systems & Solution Architect
5y ago
Using Excel to email worksheets and workbooks has been one of the best functions I have found Excel useful for. It’s enabled me to create all sorts of automated processes such as creating and sending dashboards and KPIs, as well as emailing parsed out data meant for a certain supplier.
This block of VBA code is easy to use, easy to understand – and extremely effective.
Sub EmailSheet()
'This sub procedure will email a section of a worksheet
'Written by JamesCanCode
'www.jamescancode.com
Declare Variables
Dim OutApp As Object
Dim OutMail As Object
Set Variables
Set OutApp = Create ..read more
James Pieri, Supply Chain Specialist, Systems & Solution Architect
5y ago
A story on why I don’t lie on my resume, and how I made three interviews very uncomfortable for candidates who did.
My resume is a lot of things – well, it’s only two pages, but I was able to fit a lot on those two pages – but one thing it’s not, is a lie.
Everything on my resume is the complete truth. The good, and the bad.
Yeah, I have some things on my resume that may raise a red flag, or cause a recruiter or hiring manager to question my abilities. But the effects of revealing those negative aspects of my life and being honest about them far outweigh the impacts I would fac ..read more
James Pieri, Supply Chain Specialist, Systems & Solution Architect
5y ago
When you start your career, lots of people tell you tons of things. The majority of it is good, some of it is pure crap, but then a small percentage, about five percent, is solid gold.
This is about the four words, one sentence, that one of my first managers had ever given me as advice – and I gotta tell you – it’s been the basis for almost my entire career.
“Work Smarter, Not Harder”
These four words changed the way I worked ever since hearing them. It’s not some marvelous revelation that’s never been thought of before, but it made me reflect on how I had been working, and made me ..read more
James Pieri, Supply Chain Specialist, Systems & Solution Architect
5y ago
=VLOOKUP(A2,$B1:D$90,2,FALSE)
You may have seen some formulas in another person’s workbook with funny symbols that look like this, $A:$V or $A1:B1. The ‘dollar-sign’ in this case locks the cell reference, and it’s placement is important.
You can either add the symbols manually using the SHIFT+4 key on your keyboard, or using the function key F4 on your keyboard. Hitting F4 multiple times will toggle through the locking scenarios.
For the example of using columns, locking the cell reference is simple – either ‘Off’ (A:V) or ‘On’ ($A:$V). But for specific ranges (A1:B1), you have ..read more
James Pieri, Supply Chain Specialist, Systems & Solution Architect
5y ago
This post is password protected. You must visit the website and enter the password to continue reading ..read more