20 unique uses of microsoft excel spreadsheets

SPing = sPing & 'TTL (s) = ' & vbTab & vbTab & oRetStatus.ResponseTimeToLive SPing = sPing & 'Time (ms) = ' & vbTab & oRetStatus.ResponseTime & Chr(10) SPing = sHost & ' Ping Success on ' & Now() & Chr(10) If IsNull(oRetStatus.StatusCode) Or oRetStatus.StatusCode 0 Then ('select * from Win32_PingStatus where address = '' & sHost & ''') Set oPing = GetObject('winmgmts:').ExecQuery _ IntSiteCount = CInt(Sheet1.Cells(1, 2).Value) Not only can you place them anywhere on the sheet, but you can use those objects to interactively (or automatically) add, remove, or manipulate information on the sheet. Look at a sheet as a design board where you can place Visual Basic form objects like command buttons, dropdown boxes, textboxes and anything else at all. If you look at it that way, you may realize just how much you can accomplish with the application. It is actually a design platform for applications. Microsoft Excel is not just a data spreadsheet. If you want to enhance your use of Excel, I invite you to follow along as I share a few of these designs - and simple scripts - that I used to accomplish these tasks. This spreadsheet has 4 tabs and covers everything from grouping links of URLs that I want to launch all at once, to managing my debt and paying it off faster. To help with that, I've decided to share a 'Automation' spreadsheet that I've created to manage different areas of my life. However, if you're serious about using Excel to manage more of your life, then you should take the time to learn how VBA coding works.

20 unique uses of microsoft excel spreadsheets