How To Create Exe File For Excel Macro

Tools & Downloads. This wikiHow will teach you you how to create a basic EXE file on a Windows computer, as well as how to create a container for that file that will install it on another computer. If you want to specify which browser is used to display the link, things get more complex. i made a very important userform for my organisation using excel vba on a excel file , now i want to change the icon of this excel file. Add Values to a ListBox. On the Commands tab, select Macros in the Categories pane and Custom button in the Commands pane. Most users know that jpg files are innocuous and, seeing the jpg extension, assume that SomeFile. Launch the Export Dialog Right-click on the query in the left menu and select Export > Excel from the contextual menu. Create a meaningful name for your data source. Chapter 1 In this chapter, learn how to turn on the Developer tab. Activate part, Excel will simply create a word file, and you can see the file in your task bar. In this chapter, learn how to create a simple macro which will be executed after clicking on a command button. Running Excel macros from other applications – this is basically the use case I quoted above. exe file in the target folder will be created. The Excel VBA Tutorial: Make Your First Macro and Get to Know the Tools is a great introduction that will teach you how to use the various tools associated with creating macros. The code can get complex, especially as we apply filters with multiple criteria, and the macro recorder can create most of the code for us. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm. Here's what you'll need: Microsoft Excel, with some basic knowledge about programming macro's in Visual Basic ; RSLinx (not the 'Lite' version, because that does not have DDE/OPC capabilities) A ControlLogix processor of course. Create a new, blank worksheet. When you open a new excel spreadsheet, these functions and macros are ready to be used. Create a Custom Desktop Shortcut Uses an Icon file for a shortcut in place of the standard "Workbook" icon. The VBA Dir function returns the name of a valid file, so you can use it to test whether a file exists. Open Method. Also, you should create column names on the destination worksheet and fill in one row of test data at least. Download the worksheet with examples of the for, do while and do until loops in VBA. However, malicious people could write VBA code to create macros that do harmful things. Save command creates new application file on disk. With Excel VBA you can automate tasks in Excel by writing so called macros. Then, you can paste the VBA code generated by Excel into the sample C# code below and run it dynamically at runtime. To make Excel open spreadsheets in new windows, do the following: Close Excel, if it is open. Create Bat File With Excel Data with VBA. How to open a document (local/network file or web page) from MS Access When developing Access database applications, you may want to open a document (a file on your local or network drive, or a web page) by the user or automatically opening the document in a background process coded in VBA. To create a macro, you just need to retrieve the corresponding command lines from the History window: select the session commands, then, with a right click, save the selected commands as. Create a system DNS using the Microsoft Excel Driver (*. Actually I have two exe's that'll display the result of the macro Those were built from VB 2008 One is for excel 2003 and the other is for Excel 2007 So I need to check for the office version installed in the user's system and invoke the corresponding exe to display the result. Everything is working fine. exe /s Then open the workbook whilst holding the shift key down to stop any macros from executing. Download the file given above. What i used to do is to open the excel file to run the macro but now I'm trying to find a way to run the macro from a vbs file or. Add values to a ComboBox in a UserForm in Excel. The Exe file is the executable file which transforms a source file into an executable file. Text To Excel Conversion With 'TXL Wizard' We've got 3 easy methods to convert Text to Excel The format of your text file determines which method to use. Net document level customization then you need to convert your VBA code to VB. EXE to run excel macros Your post does not comply with Rule 3 of our Forum RULES. exe) from within Excel 2000? Posted by Roger Redhat on March 10, 2001 12:48 AM Use the Shell function from within a macro. VBScript Infection Methods. Excel Free features make it easy to create Zip installer package totally programmed in VBA such that, when Setup. When you specify a help file and context argument for this function, Excel adds a Help button to the custom Input dialog box that users can click to access the custom help file in the Help window. Instructions to follow: 1. csv into the same folder and an. We have different methods and ways to find Next Friday date. After enter data your Excel sheet is look like the following picture. I am using Access 2007. how to generate and exe file of excel file I HAVE MADE AN EXCEL SHEET ADDING MANY BUTTONS USING CONTROOL TOL BOX COMMAND FROM vIEW-tOOLBARS MENU. Below is an example of a sample XML that contains a repeated item, each will have a model and description field. It is a really elegant way to build the output. exe) from within Excel 2000? Posted by Roger Redhat on March 10, 2001 12:48 AM Use the Shell function from within a macro. When the VBA Dir function returns an empty string, it means the file does not exist. First, turn on the Developer tab. a word file. And also, i want to change the particular color of the cell in Excel ?. Excel Data Entry How to Tab From Cell to Cell in an Excel Worksheet Form In Word, we can set up custom forms, and then tab through them to enter our data. exe (this is the file that starts excel). Create New Workbook in Excel VBA - Example Cases: Create new workbook; Create an Object for newly created workbook; Create new workbook. Saving a file with a unique name in Excel VBA Feb 24, 2014 When creating macros in Excel (or another Office application), you often want to have the macro save the file of results as part of the macro. After this, move it in front of the file or at the beginning of the file. Then you use the vbs file to find the pid for Excel and then interact through the fully launched Excel with the pid. How to dynamically add and run a VBA macro from Visual Basic create a new text file named KbTest. They could then embed these macros in Office documents and distribute them online. Excel To KML security is comparable to sending an email to a trusted colleague. We'll begin by getting you familiar with Excel's menu system, how to create formulas and use simple functions, how to format your data for appearance sake, how to use printing and charting capabilities of Excel, how to work with. To parse a file on disk, create an instance of the VBA_Parser class, providing the name of the file to open as parameter. File name, specified as a character vector or a string. That is the Office Open XML format saved in a binary format. The following section shows how to create a Chart in Excel through VB. On the Commands tab, select Macros in the Categories pane and Custom button in the Commands pane. Create a Custom Desktop Shortcut Uses an Icon file for a shortcut in place of the standard "Workbook" icon. First we open manually web site and found html-code of search form:. Remove files from the XLStart folder and the alternative startup folders. Create New Workbook in Excel VBA - Example Cases: Create new workbook; Create an Object for newly created workbook; Create new workbook. I have to create a final Pdf file that has all the different reports in it and i get individual reports in pdf format from different teams. The technique that is most frequently used to transfer data to an Excel workbooks is. Second task is to create macro, which will send previously exported excel file as an email attachment to chosen recipient. This wikiHow teaches how to create simple macros for Excel spreadsheets. I have developed aa application with the VBA in excel, but i want to create a file that i could install in any computer and if it´s possible, using Visual Basic 6. You can find below three specified macros or procedures to find Next Friday date using VBA functions. Excel reads CSV files by default but in most cases when you open a CSV file in Excel, you see scrambled data that’s impossible to read. While running the macro, the DOS command prompt appears and goes away in a flash but the function of the. Excel workbook copy protection software. Pass in the excel file name through a variable instead of iterating over each connection manager Refresh a specific query within the workbook, rather than calling RefreshAll Find your query within the workbook and set the BackgroundQuery property to False to avoid the asynchronous refresh call, and having to sleep. XLS or in Excel 2007-2016 your PERSONAL. ‘Starting the program and sub procedure to write VBA code to write the data to a text file. Choose "Excel macro-enabled workbook" from the "Save as type" drop-down list and click the Save button. This is a method which can be called from VBA which loads any type of add-in (XLL, XLA or XLAM). this is good. This is a late-binding example that I use to open an Excel file form a VB. Explain allows you to easily and quickly create help files, user manuals, and other documents. Test on a small folder first, to see how it works. You may use this macros with Microsoft Excel 97/2000/XP/2003/2007. All you need to do is go to the Data section. frm) with a command button. Run Macro:="Task1". When you specify a help file and context argument for this function, Excel adds a Help button to the custom Input dialog box that users can click to access the custom help file in the Help window. exe file that opens an userform (or dialogbox) with a Run button along with some other controls and runs a VBA macro when user clicks on the button. The Shell command returns the Process ID, PID, so you can kill the file when you're done. Parse a MS Office file - VBA_Parser. Click Ok button to finish editing. exe) from within Excel 2000? Posted by Roger Redhat on March 10, 2001 12:48 AM Use the Shell function from within a macro. exe file, so it acts as a standalone application. Use ShellExecute() instead of Shell (a Visual Basic statement) or WinExec() (a Windows API function) to work around the following limitation of the latter commands. I used record macro then saved a word document as a pdf then used that code and added the "appWD" to the front which I defined earlier in my macro as : Set appWD = CreateObject("Word. This blog mainly focus on teaching how to apply Visual Basic for Microsoft Excel. What i used to do is to open the excel file to run the macro but now I'm trying to find a way to run the macro from a vbs file or. Open Method. KML is a file format used to display geographic data in applications such as Google Earth or Google Maps. They drive almost everything interesting and useful you will ever do in a spreadsheet. Microsoft Access / VBA Forums on Bytes. very useful. However, I was able to find a workaround by renaming the the MSForms. A macro is simply a series of instructions. A file in Microsoft Excel is referred as Workbook. I need help with this function. Office software, like Excel , offers the option of Macros, which carry out data manipulation operations. Microsoft Excel also provides you more options for creation of a new workbook. Want to become an expert in VBA? So this is the right place for you. The nitty-gritty of writing a Binary file is that you can put the data into the file any way you want. How to import data from Excel to SQL Server Prerequisite - Save Excel data as text To use the rest of the methods described on this page - the BULK INSERT statement, the BCP tool, or Azure Data Factory - first you have to export your Excel data to a text file. An example is that if a command button is pressed it would open up a specific Word document. Creating an add-in isn't difficult, but it does require a bit of extra work. You may find the compiled EXE file at the location that you have chosen in the "Target Path" field on the compilation form. To turn on the Developter tab, execute the following steps. Here is a sample of the bat file "C:\Program Files\Microsoft Office\Office10\excel. I have a file called newcurl. You should consider. All it does is open the excel file when the compiled exe file is double clicked or opened (no enable or disable macros prompt either when the excel file is opened) No other purpose except to have a custom icon and to make the appearance appear un-excel like. Let me know your thoughts in the comments section. I have devoloped several vba modules containg macros in ms excel. Excel creates exe file as a result of saving. After you test the macro and see that it works, you can either leave macro security set to low or sign the macro. I have developed aa application with the VBA in excel, but i want to create a file that i could install in any computer and if it´s possible, using Visual Basic 6. Click the Office Button; Click the Excel Option button at the bottom, then you will enter the Excel Option window; Click the Popular button at the left; Under Top Option for Working with Excel, check the Show Developer tab in the Ribbon option. xls is the workbook that contains that macro you want to run. Unlock/Unprotect Excel File and Software. ico (icon) file. Your HTML input should contain at least one TABLE tag. Paste the output of the first portion of the payload script into the editor, save it and then paste the remainder of the script into thel word document itself. xls Comparative Ratio Analysis. If the macro directly or indirectly uses functions from other folders, after editing these functions need to create file again (use the Make Exe dialog or edit/run the macro). Most users know that jpg files are innocuous and, seeing the jpg extension, assume that SomeFile. Luckily, Excel comes with a built-in step recorder which means you will not have to code the macros yourself. For example, we could have a macro that tells Excel to take a number, add two, multiply by five, and return the modulus. I'm trying to present the user with a dialog of some sort where they can browse and select either a fi. How to run Excel macro from a vbs file or. The variable pctCompl (abbreviation for percentageCompleted) measures the progress of the macro. path & """ & " newcurl. exe /s Then open the workbook whilst holding the shift key down to stop any macros from executing. Open Microsoft Excel 2013. VBA Code to Open an Excel File using Workbooks. In this tutorial, you will learn how to rename a specific file. Programmers widely use it to create efficient and elegant macros. Demonstration video. Create a DLL by CSharp or VB. Next, we clear sheet1. To add the Developer tab to the Excel 2013 Ribbon, follow these two steps: Choose File. Needless to say, that NOT all Excel workbooks crash due to file corruption. Browse "My Documents" to use the compiled file, and then just double click the compiled file icon (sample. SYS), OCX Controls, and several others. When the user clicks on the file to open it, Windows sees the exe extension and executes the program, unleashing potential destruction upon the unwary user. If you have macros stored in other workbooks you can transfer them to the personal macro workbook by moving the modules within Visual Basic in excel. Dialog boxes with less functionality can be used to provide pop-up capabilities. Re: Makro create, run, delete. Copy a macro module to another workbook. Suppose, you are busy with some Excel application and want to send an email to your manager or team member attaching the same Excel document you are working on. txt file in catia 0 answers 71 views 0 followers How to export a revit file from revit to autocad, with a customized txt export file. txt" in the macros folder and it will automatically be installed when ImageJ starts up. exe) is clicked in a Zip package, Zip will automatically extract all the files to a temporary folder, runs the Setup program and, after this completed, delete the temporary installation files and folder. Checkout this article on how to create your own Personal Macro Workbook if you don't have yours setup yet. Create Bat File With Excel Data with VBA. Before you can convert your Excel file to KML, you have to arrange your worksheet in a specific way. It is DoneEx XCell Compiler, located at :. The Quick Access Toolbar. exe" Application. Rather than scour the internet hoping to find the correct set of constants or method syntax for formatting your spreadsheet, use the built in tools in Excel to write the familiar VBA code for you. Here is the syntax to Open an Excel File using VBA. Choose Compile to Exe in the XLS Padlock menu or ribbon:. In those cases you can use macros to write out a text file in any form you'd like. So I’ve put together a one-click Excel solution that renames the MSForms. zip file to a designated directory. Demonstration video. A message box with "you resized a window" will be displayed. Excel can open tab- or comma-delimited files and correctly parse the data into cells. xlsm? If the file extension is not. jpg is a harmless image file. Through an efficiently written macro, the work can be accomplished within minutes without the possibility of any errors creeping in. Open the VBA Editor by pressing Alt+F11 on your keyboard. With Excel VBA you can automate tasks in Excel using what is called a macro. Excel lets you build your charts and spreadsheets to meet your specific needs. Hi all, I have a spreadsheet workbook that i would like to convert to an. Once inside, you can change the look of the icons, cursors, dialogs, buttons, sounds, animations and other elements of the Windows user interface by editing. Find information on how to create and run a macro. Couldn't you save this as a Unicode Text file from within Excel? It sounds like this could be sourced from a single column of data since you're not using a CSV or tab-delimited type. Everything is working fine. Since you want an executable file, I assume you have forms in Excel. Save a file as a particular type using a macro. You can skip the. For Excel 2003 you can. And customize File or Folder dialog Box using VBA. Excel: 3rd party tool that claims to be able to compile an workbook to an EXE: DoneEx XCell Compiler. And then unzip the plugin package. ALSO i HAVE ADDED MANY FORMULAS AND COMPILED A WHOLE YEAR ACCOUNTING SYSTEM WHICH COULD BE IMPLEMENTED IN A SMALL SCHOOL RANGING FROM 100 TO 1000 STUDENTS. When Excel starts up, it opens a Personal. Don't forget to include a method for executing the macro or macros. converter from xl to exe This utility converts Excel files from the XL format to an EXE format (convert XLS to EXE, convert XLA to EXE, convert Excel to EXE). Create and save all your macros in a single workbook by creating them in Personal. This macro runs slowly, so reduce the Max Properties setting as low as possible. C:\Program Files (x86)\BarCodeWiz Code 128 Fonts\Addins\BarCodeWizC128. Extract the Excel_Automation_demo. I want excelVBA to run this file. Can any solution which will block the file without accepting the macros? Actually what I wanted was the excel file would create a serial code and asks to give the activation code. If the exe you call then creates other process, such as calling another exe, and then exits the batch file will continue processing after the called exe has terminated, as it has no knowledge of other processes started by it. Simply select the workbook in the "Macros in" section of the screen, choose the macro, then select "Run". xls") ' Loop over all sheets. Net or you can call your macro from VB. Demonstration video. Right-click the XLSM file in Google Drive and choose Open with > Google Sheets. FileDialog" method of Application object provides many useful methods and properties that would allow users to filter. Create a UserForm. It helps in data analysis to summarize data, create graphs and dashboards. Recovery Toolbox for Excel is a shareware product and distributed under a Try before you Buy License. This article introduces the basic concepts you need to know to be proficient with formulas in Excel. Create a system DNS using the Microsoft Excel Driver (*. To create a new workbook, normally you will be provided a way to do so. Hi Can anyone help me create a EXE file to auto click in the background a SAVE AS window that is opened by any program. First – using exchange SMTP server and second – by simply using Gmail. Re: Creating a. Once that is completed, you need to make sure that you have a Network shared directory that has Read,Write, Change Permissions for all users of the database. Macros>Install Macros command. The xlm file extension is with Microsoft Excel, one of the most popular and powerful tool you can use to create format spreadsheets, graphs and much more. Microsoft Excel. When compilation is completed, close Excel, and run the EXE file. Text To Excel Conversion With 'TXL Wizard' We've got 3 easy methods to convert Text to Excel The format of your text file determines which method to use. Second task is to create macro, which will send previously exported excel file as an email attachment to chosen recipient. From Separate Excel File. Save Your File To Your Computer. A VBA module with the above code for Adobe Professional. I am trying to create a macro enabled Excel file, in which, upon hitting the button, the Excel gets saved to data. to some place, e. com, shell not involved, you specify the file to change. From the above input in an excel sheet I want to create a XML file using a macro. Working with Workbooks in VBA. Open the Names file again and run the macro. Reporting: Configuring Excel to open several files in the same window. When compilation is completed, close Excel, and run the EXE file. Combine multiple Excel files into one with Ultimate Suite If you are not very comfortable with VBA and looking for an easier and faster way to merge Excel files, have a look at the Copy Sheets tool, one of 60+ time saving features included with our Ultimate Suite for Excel. When you or your customer will try to start the Sample. XlsxWriter is a Python module for creating Excel XLSX files. Actually i m using EXCEL 2007. This script should work at minimum for current versions of Microsoft Project. I will provide code for two scenarios. A new instance will open. The basis of a macro is Visual Basic for Applications (VBA), which is the programming language for Office applications such as Excel. bas" f= ile which then you can add to any VB 6. dia should be a parameter processed by. "Pawan" wrote: Thanks Joel But I did not get the example given by you. Let's write the entire code in a procedure. Thanks again for the link. Use this tool to convert HTML tables into CSV and Excel. Buttons make life easier. com, shell not involved, you specify the file to change. bat sitting inside the current directory that my excel file is in. exe) from within Excel 2000? Posted by Roger Redhat on March 10, 2001 12:48 AM Use the Shell function from within a macro. Then press Next and get to the next Wizard window where you have the option of either running a custom query to output custom data from your tables, or just select all data from more tables. ‘Declaring the strFile_Path variable as String Data Type to store the text file path. If you haven't split the database yet into Data Table in one, and all the other Queries, Forms, reports, Macro and Modules in another, please do so. It’s the backbone for almost all companies. There is no need for that; You can sign your own macros with SelfCert. Learn to enable or disable macros in Excel for Mac. Select Tools -- References and search for the QR Code encoder. The Access file can also be opened directly from the Exe file. exe /s Then open the workbook whilst holding the shift key down to stop any macros from executing. Hope you have enjoyed our earlier blogs, revisit "How to split excel data into separate. In this chapter, learn how to create a simple macro which will be executed after clicking on a command button. It's a tool for working with structured data. If using Vista and if Exl-Plan's help files fail to load and/or Excel indicates "There was a problem running the macro (1037). ALSO i HAVE ADDED MANY FORMULAS AND COMPILED A WHOLE YEAR ACCOUNTING SYSTEM WHICH COULD BE IMPLEMENTED IN A SMALL SCHOOL RANGING FROM 100 TO 1000 STUDENTS. MS Access VBA Programming MS Excel VBA MS Word VBA VBA 7 responses on “ VBA- Determine Executable Path for Given Application ” installsoft April 13, 2014 at 1:07 pm. exe That will launch Excel with the add-ins, etc. If the macro directly or indirectly uses functions from other folders, after editing these functions need to create file again (use the Make Exe dialog or edit/run the macro). Line 23 prints the Excel file to PDF when done manually (this was recorded using the Excel Macro Recorder). It allows you also to obtain various file and folder system properties. How to quickly create an empty Add-in for Excel 2007 and later versions Save a blank workbook as a Excel Add-In (*. @AutoItPID. Step by Step: Getting Started with Virtual Forms Note : If you want to create a desktop Excel Application with Virtual Forms without coding, with just a few clicks. If you want to learn how to check if a file exists, you can click on this link: VBA File Exists Using the. In this article, we will introduce a method to input all the file names into a worksheet by using VBA macro. New Workbook: Create macros that you can run in any new workbooks created during the current Excel session. exe is an Assembly Registration tool used to read the metadata within an assembly. Configure general and security options in XLS Padlock. The following is the code that I am using to add the bookmarks -. Visual Basic for applications or VBA is designed by Microsoft to be used along with handful of Microsoft applications such as Excel or Access. Rather than scour the internet hoping to find the correct set of constants or method syntax for formatting your spreadsheet, use the built in tools in Excel to write the familiar VBA code for you. Choose Compile to Exe in the XLS Padlock menu or ribbon:. Extract the Excel_Automation_demo. Sub Macro1. Then, you can paste the VBA code generated by Excel into the sample C# code below and run it dynamically at runtime. The workbook is secured now. To tell Excel that. Does any one how to open a. xls Forecasting Techniques files2000/lacher44. xlsm then your browser is probably changing this. You could use VBA to create the filename and store the filepath for saving it. A macro in Microsoft Excel is a process you can record and save so you can quickly execute and accomplish repetitive tasks in spreadsheets. To create a macro, you just need to retrieve the corresponding command lines from the History window: select the session commands, then, with a right click, save the selected commands as. If you have receive a spreadsheet or workbook file that contains the macros you wish to use, simply open the file in Excel. exe file that opens an userform (or dialogbox) with a Run button along with some other controls and runs a VBA macro when user clicks on the button. You can open a file dialog box from your Excel worksheet using VBA. It is a really elegant way to build the output. Working with Workbooks in VBA. might want to interrupt the process, enable the user to interact with Excel (DoEvent) etc. Compile workbook to EXE file; Create registration key for compiled workbook; Create protected trial/demo workbook; Compile EXE for Excel 32. How to create a png file of fixed width and fixed height in VBA? 2. Copy and paste the macro into the new module. xlsm or whatever you used to have for your file. Excel Chart in VB. Tips & Tricks 147 - Find the Location of Excel. There is only one program that I am currently aware of what compiles your Excel file (including VBA code) to an EXE file. How to create Outlook appointments from Excel data. When I use a batch file to open an Excel file the next morning, it opens the Excel app anew (new window), and Excel complains that my personal. In order to keep user suspicion low,. I know, if you are trying to create the macros for the first time in your machine, you will not be able to easily find the DEVELOPER tab when you open Excel. You should consider. By default, a Listbox in a form will be empty, and we need to use Add Values to a ComboBox. To see how the macro works, you can download the Export Excel Sheet as PDF sample file. After compilation, the Sample. Combine multiple Excel files into one with Ultimate Suite If you are not very comfortable with VBA and looking for an easier and faster way to merge Excel files, have a look at the Copy Sheets tool, one of 60+ time saving features included with our Ultimate Suite for Excel. While you may want to start with simple examples, macros can get incredibly complex. On the right see my Excel Worksheet and the Message Box with the similar output from my VBA Macro. The macro code opens each Excel file, performs a task, saves the file, and then closes the workbook. I wonder if anyone could please assist me with the VBA code to attach files (pdf / jpg) as an embedded object in Excel. ) XlsxWriter. @AutoItPID. 0 project that you want. Be sure to enable macros, if you want to run the macro. How to prevent files from automatically opening in Excel. The fact-checkers, whose work is more and more important for those who prefer facts over lies, police the line between fact and falsehood on a day-to-day basis, and do a great job. Today, my small contribution is to pass along a very good overview that reflects on one of Trump’s favorite overarching falsehoods. Namely: Trump describes an America in which everything was going down the tubes under  Obama, which is why we needed Trump to make America great again. And he claims that this project has come to fruition, with America setting records for prosperity under his leadership and guidance. “Obama bad; Trump good” is pretty much his analysis in all areas and measurement of U.S. activity, especially economically. Even if this were true, it would reflect poorly on Trump’s character, but it has the added problem of being false, a big lie made up of many small ones. Personally, I don’t assume that all economic measurements directly reflect the leadership of whoever occupies the Oval Office, nor am I smart enough to figure out what causes what in the economy. But the idea that presidents get the credit or the blame for the economy during their tenure is a political fact of life. Trump, in his adorable, immodest mendacity, not only claims credit for everything good that happens in the economy, but tells people, literally and specifically, that they have to vote for him even if they hate him, because without his guidance, their 401(k) accounts “will go down the tubes.” That would be offensive even if it were true, but it is utterly false. The stock market has been on a 10-year run of steady gains that began in 2009, the year Barack Obama was inaugurated. But why would anyone care about that? It’s only an unarguable, stubborn fact. Still, speaking of facts, there are so many measurements and indicators of how the economy is doing, that those not committed to an honest investigation can find evidence for whatever they want to believe. Trump and his most committed followers want to believe that everything was terrible under Barack Obama and great under Trump. That’s baloney. Anyone who believes that believes something false. And a series of charts and graphs published Monday in the Washington Post and explained by Economics Correspondent Heather Long provides the data that tells the tale. The details are complicated. Click through to the link above and you’ll learn much. But the overview is pretty simply this: The U.S. economy had a major meltdown in the last year of the George W. Bush presidency. Again, I’m not smart enough to know how much of this was Bush’s “fault.” But he had been in office for six years when the trouble started. So, if it’s ever reasonable to hold a president accountable for the performance of the economy, the timeline is bad for Bush. GDP growth went negative. Job growth fell sharply and then went negative. Median household income shrank. The Dow Jones Industrial Average dropped by more than 5,000 points! U.S. manufacturing output plunged, as did average home values, as did average hourly wages, as did measures of consumer confidence and most other indicators of economic health. (Backup for that is contained in the Post piece I linked to above.) Barack Obama inherited that mess of falling numbers, which continued during his first year in office, 2009, as he put in place policies designed to turn it around. By 2010, Obama’s second year, pretty much all of the negative numbers had turned positive. By the time Obama was up for reelection in 2012, all of them were headed in the right direction, which is certainly among the reasons voters gave him a second term by a solid (not landslide) margin. Basically, all of those good numbers continued throughout the second Obama term. The U.S. GDP, probably the single best measure of how the economy is doing, grew by 2.9 percent in 2015, which was Obama’s seventh year in office and was the best GDP growth number since before the crash of the late Bush years. GDP growth slowed to 1.6 percent in 2016, which may have been among the indicators that supported Trump’s campaign-year argument that everything was going to hell and only he could fix it. During the first year of Trump, GDP growth grew to 2.4 percent, which is decent but not great and anyway, a reasonable person would acknowledge that — to the degree that economic performance is to the credit or blame of the president — the performance in the first year of a new president is a mixture of the old and new policies. In Trump’s second year, 2018, the GDP grew 2.9 percent, equaling Obama’s best year, and so far in 2019, the growth rate has fallen to 2.1 percent, a mediocre number and a decline for which Trump presumably accepts no responsibility and blames either Nancy Pelosi, Ilhan Omar or, if he can swing it, Barack Obama. I suppose it’s natural for a president to want to take credit for everything good that happens on his (or someday her) watch, but not the blame for anything bad. Trump is more blatant about this than most. If we judge by his bad but remarkably steady approval ratings (today, according to the average maintained by 538.com, it’s 41.9 approval/ 53.7 disapproval) the pretty-good economy is not winning him new supporters, nor is his constant exaggeration of his accomplishments costing him many old ones). I already offered it above, but the full Washington Post workup of these numbers, and commentary/explanation by economics correspondent Heather Long, are here. On a related matter, if you care about what used to be called fiscal conservatism, which is the belief that federal debt and deficit matter, here’s a New York Times analysis, based on Congressional Budget Office data, suggesting that the annual budget deficit (that’s the amount the government borrows every year reflecting that amount by which federal spending exceeds revenues) which fell steadily during the Obama years, from a peak of $1.4 trillion at the beginning of the Obama administration, to $585 billion in 2016 (Obama’s last year in office), will be back up to $960 billion this fiscal year, and back over $1 trillion in 2020. (Here’s the New York Times piece detailing those numbers.) Trump is currently floating various tax cuts for the rich and the poor that will presumably worsen those projections, if passed. As the Times piece reported: