Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: TomBarsh
  • Content: Threads
  • Order by date
  1. TomBarsh

    Excel calculation mode - VBA concise and verbose statements

    I recently was befuddled with some VBA code and had to sort things out. The statement to change the application's calculation mode is: Application.Calculation = [something] I've always used (well, for 20 years or more?) the "somethings" as: = xlCalculationAutomatic =...
  2. TomBarsh

    Elevator at John Hancock Center in Chicago

    John Hancock Center is one of the tallest buildings in Chicago (okay, I guess its name was officially changed earlier this year). One of the express elevators to the restaurants and observation level at the top of the building experienced broken cable(s) this week. A number of news articles...
  3. TomBarsh

    Excel: Missing embedded images ?

    On occasion I open a workbook and where I had previously pasted an image of something, instead there is a 'box' placeholder with a 'red X' in the top left, and the caption "The image part with relationship ID rID1 [the digit may vary] was not found in the file". This is worrisome as the...
  4. TomBarsh

    Excel AutoCorrect ?

    So I am documenting my investigation of "Health Savings Accounts" in the USA, commonly referred to as "HSA" Excel keeps regularly and willfully changing my typing HSA to HAS. I don't understand why. The AutoCorrect settings are set to "Ignore words in UPPERCASE". Plus I capitulated and added...
  5. TomBarsh

    major Colombia bridge collapses during construction

    That's the country of Colombia. A major bridge, 440 metres span, collapsed during construction. Seems to be a cable-stayed bridge with concrete towers and deck. Seems like one tower and span collapsed during construction, killing at least 10 workers...
  6. TomBarsh

    Synchronicity of calculations with external data in Excel 2016?

    I'm using the Excel feature to access external data from the web. The data source is a Google Sheet that has been published. I have a simple routine to refresh the data ("ThisWorkbook.RefreshAll"). But subsequent commands seem to execute before the external data has been fully refreshed...
  7. TomBarsh

    False positive from File | Open "Search" field

    I used the "Search" field in the Excel File/Open dialog to search for workbooks containing the word "curvature". I got some hits and opened them all. I could find the presence of "curvature" in all files except one. I use the workbook search tool (making certain that all sheets are visible) and...
  8. TomBarsh

    [Excel 2016] File Open command that bypasses the "Backstage"?

    [Excel 2016] In customizing the Quick Access Toolbar (choosing from 'All Commands') there is the tool to "Open" files, which is the same as selecting File / Open. Either method uses the "Backstage". The "tooltip" when hovering over this selection while customizing the QAT even indicates...
  9. TomBarsh

    List your fave tips for Excel 2016, Please : - )

    I have been dragged kicking and screaming into using Excel 2016. "Upgrading" from my old Excel 2007 (which was itself another kicking and screaming story). Okay, it seems to run all of my VBA and standard workbooks without too many hitches [okay, in hindsight that was TIP #3]. But I just don't...
  10. TomBarsh

    "hidden" text on VBA modules?

    Is it possible to "hide" the text on a VBA module in Excel? Reason I ask is I was given a very complex (publicly distributed) workbook about "Topic A". There are a number of modules, mostly of very simple code and about half or more of which have no text at all. I tried Ctrl + End to go to the...
  11. TomBarsh

    upgrading from Excel 2007?

    I happily use Excel 2007 on my office computer (3-4 year old Dell with Windows 7). And on my 10 year old Sony Vaio running Windows Vista. And I happily use a lot of VBA in the process. I just purchased a new personal laptop with Windows 10 and debating about getting Excel 2016. The reviews at...
  12. TomBarsh

    History of some of my Excel faux pas (boo-boos)

    I have been using Excel since Excel 3.0 with the old xlm macro language. Not that I consider myself an expert on Excel by any means, just a good journeyman. For entertainment, here are a few of the things that have driven me batty with Excel over time. No telling how many hours were expended...
  13. TomBarsh

    Excel: xlsm versus xlsb ?

    Every so often I stumble across Excel issues that I investigated years before (this occurs in my work life too) and have forgotten. So I just realized that Excel 2007 offers the xlsm and the xlsb formats. My copy of Walkenbach's book for 2007 barely even mentions the xlsb format. But he does...
  14. TomBarsh

    "mystery" formula from AISC spec ?

    Can someone identify this "mystery" formula purportedly from AISC for "unity" check? I was provided with this formula in some calculations; due to the context I assume they are referring to the combined load checks for beam-column. I can't identify this in the 9th or 13th Editions of the AISC...
  15. TomBarsh

    need help with changing cell name in worksheet using VBA

    Using VBA (and Excel 2007), I have a problem with a line where I want to change the cell referenced by a name. All I am trying to do is assign an existing name to a new cell. In simplest form: Sub Red() Dim WB As Workbook Dim WS As Worksheet Set WB = ActiveWorkbook Set WS =...
  16. TomBarsh

    use of IBC in countries other than USA ?

    Is the IBC (or portions thereof, say, for wind and seismic?) adopted in any countries outside the US? My partial answer is "yes", Saudi Arabia and Abu Dhabi, as per SK Ghosh: http://skghoshassociates.com/SKGAblog/viewpost.php?id=37 But are there any other countries?
  17. TomBarsh

    ASCE "Anchorage Design for Petrochemical Facilities" ?

    I am interested in analysis of anchor bolt tensile loads for vertical pressure vessels. ASCE has a publication "Anchorage Design for Petrochemical Facilities". The initial edition was published in 1997 (combined as "Wind Loads and Anchor Bolt Design for Petrochemical Facilities", two books in...
  18. TomBarsh

    How to identify a phantom Excel VBA routine that uses keystroke shortcut

    I have an Excel workbook with 303 VBA routines in it. There is a "phantom" routine that I just found uses the keystroke shortcut: Ctrl + r. This file has been around for 20+ years so who knows when/where/why I set that up. I sure don't. The phantom routine is capable of running as soon as the...
  19. TomBarsh

    text for AISC LRFD ?

    Any suggestions for a basic steel design text utilizing LRFD? I just checked Schaum's Outlines site and they still have the "Structural Steel Design (LRFD)" by Rokach that I've had since 1991. They are still re-publishing the same Edition so I'd be getting nothing new here. Is this Schaum's...
  20. TomBarsh

    AWWA D-100: allowable compressive stress ?

    I have worked with D-100 in the long distant past but do not have access to the current Edition. Are the rules for allowable longitudinal compressive stress (or critical buckling) given in AWWA D-100 Section 13.4.3.4 based on Clarence Miller's method that is the basis for the new ASME Section...

Part and Inventory Search

Back
Top