Results 1 to 4 of 4

Thread: MBS (Metal Building Software) Excel Shipper
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2018
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    Default MBS (Metal Building Software) Excel Shipper

    Hello all,

    I'm doing some research on creating a custom spreadsheet to receive data from MBS (Metal Building Software).
    I know very little of where to even start. From what I can tell, it's mainly pulling in text from MBS's shipper and
    applying it to a spreadsheet.

    Does anyone have any experience with something like this or similar?

    Not looking for a walkthrough. Just kind of where to start.

    I know it's not a lot of information to go on but any advice would be much appreciated.


  2. #2
    Board Regular
    Join Date
    Apr 2009
    Northeast PA, USA
    Post Thanks / Like
    15 Post(s)
    8 Thread(s)

    Default Re: MBS (Metal Building Software) Excel Shipper


    Welcome to the MrExcel forum.

    There is a lot of information/links available on the web if you do a search for Metal Building Software.
    Have a great day,

    Windows 10, Excel 2007, on a PC.

  3. #3
    New Member
    Join Date
    May 2018
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    Default Re: MBS (Metal Building Software) Excel Shipper

    Thanks. I've done a bit of searching but I may have been wording some things wrong.

    I have a lot to learn with excel as well but I love it.

  4. #4
    Board Regular
    Join Date
    Apr 2009
    Northeast PA, USA
    Post Thanks / Like
    15 Post(s)
    8 Thread(s)

    Default Re: MBS (Metal Building Software) Excel Shipper

    I have a lot to learn with excel

    See if something, in the below link(s), of my most up to date list will help you:
    Training / Books / Sites as of 5/30/2018

    What Is VBA?

    MrExcel's Products: Books, CDs, Podcasts Discuss topics related to Holy Macro! Products: Learn Excel from MrExcel, VBA and Macros for Microsoft Excel,Holy Macro! It's 2500 VBA Examples CD, Guerilla Data Analysis Using Microsoft Excel and Excel Knowledge Base CD and the MrExcel Podcasts.

    There are over 1800 Excel videos/tutorials here:

    Getting Started with VBA.

    If you are serious about learning VBA try

    Excel Tutorials and Tips - VBA - macros - training

    Free Excel exercises

    MrExcel's Excel Tutorial Listing

    Online Courses

    [VBA] Difference between OLEFormat and ControlFormat?
    For references purposes and excellent explanations, see

    Excel VBA MACRO Kick-start Course for absolute beginner

    How to insert and run VBA code in Excel - tutorial for beginners

    Free VBA Course

    Excel 2007 VBA materials to learn here:

    The macro recorder actually is your friend but look here:

    Introduction to Variables, Constants and Data Types

    Declaring Variables

    Here's a good primer on the scope of variables.
    Variable Scope in Excel VBA - EASY Excel Macros
    Understanding Scope

    Using Variables in Excel VBA Macro Code

    See David McRitchie's site if you just started with VBA

    What is a VBA Module and How is a VBA Module Used?

    Events And Event Procedures In VBA

    Here is a good introductory tutorial using a VBA Class:

    There's a chapter on classes in VBA Developer's Handbook which is also good.

    Ron's Excel Tips

    Ron de Bruin's Mail from Excel and make/mail PDF files (Windows)

    How do I create and use a PERSONAL file for my VBA code

    Anthony's Excel VBA Page - Excel Application - Excel Consultant - Excel Consulting (see 3 tutorials in Excel VBA Basic Tutorial Series)

    BET: Microsoft Excel Visual Basic

    Debugging VBA

    Debug Excel VBA Macro Code

    TechBookReport - Debugging Excel VBA Code

    Here are some general links on performance improvement:
    Optimize Slow VBA Code. Speed Up Efficient VBA Code/Macros
    Excel VBA Performance Coding Best Practices - Office Blogs

    Start at the beginning...

    Creating An XLA Add-In For Excel, Writing User Defined Functions In VBA

    Build an Excel Add-In

    Creating custom functions

    Writing Your First VBA Function in Excel

    VBA for Excel (Macros)

    Excel Macros Tutorial

    Excel Macros & Programming

    VBA Lesson 11: VBA Code General Tips and General Vocabulary

    Excel VBA -- Adding Code to a Workbook

    Beyond Excel's recorder

    Helpful as a simple concise reference for the basics, and, using the macro recorder is endlessly powerful.

    Learn to debug:

    How To: Assign a Macro to a Button or Shape

    User Form Creation

    Build a UserForm for Excel

    When To Use a UserForm & What to Use a UserForm For

    UserForms in Excel VBA - UserForm Basics; Add Controls dynamically at run-time using the Add Method; UserForm Controls (A Snapshot)

    VBA add UserForm on the fly

    Excel VBA how to Personalise the Ribbon

    Excel Tutorials / Video Tutorials - Functions

    How to insert Buttons, radio buttons and check boxes in Excel

    INDEX MATCH - Excel Index Function and Excel Match Function

    Multi or two way vlook up and index match tutorial

    Excel Data Validation

    Excel -- Data Validation -- Create Dependent Lists

    Your Quick Reference to Microsoft Excel Solutions

    New! Excel Recorded Webinars

    MS Excel: VBA Functions - Listed by Category
    MS Excel: ALL Formulas/Functions - Listed by Category

    Fuzzy Matching - new version plus explanation

    Programming The VBA Editor - Created by Chip Pearson at Pearson Software Consulting LLC
    This page describes how to write code that modifies or reads other VBA code.

    VBA and Macros for Microsoft Excel, by Bill Jelen "Mr.Excel" and Tracy Syrstad

    Excel Hacks 100 Industrial-Strength Tips & Tools, by David & Traina Hawley

    VBA and Macros for Microsoft Excel 2007, by Bill Jelen "Mr.Excel" and Tracy Syrstad

    John Walkenbach's power programming with Excel books.

    Excel 2010 Power Programming with VBA, Mr. Spreadsheet's Bookshelf

    by Stephen/ Bovey, Rob/ Green, John Bullen (Paperback - Feb 11, 2005)
    Professional Excel Development

    by Rob Bovey, Stephen Bullen, John Green, and Robert Rosenberg (Paperback - Sep 26, 2001)
    Excel 2002 VBA: Programmers Reference

    Professional Excel Development by Rob Bovey, Dennis Wallentin, Stephen Bullen, & John Green

    DonkeyOte: My Recommended Reading, Volatility

    A list of Reference Books


    Need to understand error handling

    Excel file error message
    How to diagnose Excel file corruption and repair workbooks

    If a file cannot be repaired, consider recovering an earlier version from your file history


    Array Dimensions in Visual Basic - Working with Dimensions (code and graphics)

    Visual Basic Array Tutorial written by Adam Wehmann

    Shortcut Keys in Excel 2000 through 2007

    Pivot Intro
    Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis) - YouTube
    Getting Started with Pivot Tables
    Overview of PivotTable and PivotChart reports
    Build a Pivot Table in Excel VBA

    Excel 2013 PowerPivot Basics #01: Introduction To PowerPivot for Excel 2013 - YouTube

    Conditional Formatting

    Count cells based on Conditional Formatting color?

    Email from XL - VBA

    Outlook VBA
    Exporting Email Body Text to excel (using outlook 2010) VBA
    Exporting text from body of outlook email to excel
    Quickly export Outlook e-mail items to Excel - TechRepublic

    Mail a message to each person in a range

    Excel VBA Dictionary – A Complete Guide

    Excel Function Dictionary by Peter Noneley

    Function Translations

    Dynamic Named Ranges

    Vba to create waterfall charts

    How to create Excel Dashboards

    To create my Dashboard I use this small ebook: Create a Dashboard using PivotTable - Roger F. Silva

    Excel Dashboard / Scorecard Ebook

    Free dashboard training materials

    Excel Dashboard School

    Mike Alexander from Data Pig Technologies


    Round Robin Tournament Generator

    Financial Model Template

    Microsoft Excel Cascading Listboxes Tutorial

    Date & Time stamping:

    Get Formula / Formats thru custom functions:

    A nice informative MS article "Improving Performance in Excel 2007"

    Progress Meters

    How to convert text to numbers in Excel

    How to parse data from the web - Brett Fret has a video in YouTube

    Excel VBA MAC shortcuts

    Excel VLOOKUP Multiple Sheets • My Online Training Hub

    Wise Owl Tutorials
    Merging Data from Multiple Workbooks into a Summary Workbook in Excel
    Merge data from all workbooks in a folder
    Merging a Range from Selected Workbooks
    Merging a Range from Multiple Workbooks by Column
    Merging a Range from Multiple Workbooks in a Folder with a Filter

    Filtering Horizontally, or both

    You could do a Google search with “You Tube” and use the foollowing names, and/or, links:

    Some other Threads where VBA learning was discussed:
    Basics of Excel VBA and Code writting
    Excel VBA

    Sending mail from Excel with CDO

    And, as your skills increase, try answering threads on sites like:

    If you are willing to spend money for the training, then something here should work for you...

    Advanced Excel Training - Online Excel Course

    Learn VBA Fast, Vol. I: Excel function design course, with practice exercises (The VBA Function Design Course Book 1)

    Excel VBA Programmer Interview - Excel Test for interview

    Excel tests

    Here is another Function translator that is extremely popular:
    It will also translate Formulas as well

    Here a couple of good blogs on the R1C1 Style Notation

    Top ten ways to clean your data

    Analytical reasoning test of Excel aptitude

    RegEX question - Alpha only upper case only.
    Regex Tutorial—From Regex 101 to Advanced Regex
    Regular Expression Tutorial - Learn How to Use Regular Expressions

    The VBA Guide To ListObject Excel Tables

    Hiding Macros

    Excel keyboard shortcuts
    A nearly complete Microsoft list, from thisoldman:
    This has some that aren't listed on the MS page:
    And this one:
    Microsoft changed some shortcuts between 2003 and 2007 versions and they continue to change them.
    Menu shortcuts, get changed too.
    If you have a newer version of Excel, type Alt+d and a message will pop up: "Continue typing the menu key sequence ..."
    My favorite little known key sequences are the context menu shortcuts.
    If you're on Windows with a keyboard that has a menu key, copy a range of cells, then select a destination.
    Press the menu key (between Rt-Alt and Rt-Ctrl) then press V to paste values only, or R to paste formats only, or T to transpose+paste.

    Distance between Zip Codes - Excel on a PC
    Have a great day,

    Windows 10, Excel 2007, on a PC.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts