It’s never been easier to get into the Stock Market – and actually do well – with the right tools.
James Pieri, Supply Chain Specialist, Systems & Solution Architect
by JamesCanCode
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
Visit website
Excel VBA: Add and Rename a New Sheet to Workbook
James Pieri, Supply Chain Specialist, Systems & Solution Architect
by JamesCanCode
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
Visit website
Outlook Automation: How can I save attachments from an email into a folder on my computer?
James Pieri, Supply Chain Specialist, Systems & Solution Architect
by JamesCanCode
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
Visit website
Excel Automation: How to Automatically Save a Worksheet as a Separate Workbook
James Pieri, Supply Chain Specialist, Systems & Solution Architect
by JamesCanCode
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
Visit website
How Can I Run a VBA Script From Outlook?
James Pieri, Supply Chain Specialist, Systems & Solution Architect
by JamesCanCode
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
Visit website
Excel Automation: How to Email a Worksheet Using VBA
James Pieri, Supply Chain Specialist, Systems & Solution Architect
by JamesCanCode
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
Visit website
I Don’t Lie on My Resume, and Why You Shouldn’t Either
James Pieri, Supply Chain Specialist, Systems & Solution Architect
by JamesCanCode
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
Visit website
4 Words, The Best Career Advice I’ve Ever Been Given
James Pieri, Supply Chain Specialist, Systems & Solution Architect
by JamesCanCode
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
Visit website
Locking Cell References in Microsoft Excel Formulas
James Pieri, Supply Chain Specialist, Systems & Solution Architect
by JamesCanCode
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
Visit website
Protected: SECRET STASH: How to Control SAP from Microsoft Excel
James Pieri, Supply Chain Specialist, Systems & Solution Architect
by JamesCanCode
5y ago
This post is password protected. You must visit the website and enter the password to continue reading ..read more
Visit website

Follow James Pieri, Supply Chain Specialist, Systems & Solution Architect on FeedSpot

Continue with Google
Continue with Apple
OR