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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SkipVought
  • Content: Threads
  • Order by date
  1. S

    ChatGTP

    Just noticed this over at Eng-Tips forum Microsoft VBA - Visual Basic for Applications https://www.eng-tips.com/viewthread.cfm?qid=507273 However, although AI might be a time saver, there is nothing that can replace personal learning and reasoning leading to rational and moral choices else we...
  2. S

    Word Art Anomaly, or Am I Dreaming?

    Hello fellow Office users. Way back when (well, in the recorded history of mankind, not so far back), as I recall (or am I dreaming) I was able to insert a Word Art object, type in a string, position the object and stretch or compress the width and/or height to distort the text. Not talkin'...
  3. S

    Adding Parameters to an Excel Query (NOT Power Query)

    WHERE [Start Date] >=? AND [End Date] <? When you Return data to Excel, you will be able to control the way that the Parameters are entered. As I recall there are 3 options including to specify the CELL(s) that the data resides. Right-click in the QueryTable results and Select Table from Drop...
  4. S

    I'm saying mostly goodbye

    It's Past Time I'm 4 weeks from the fifth anniversary of my layoff/retirement from my job. I was planning to retire on July 1, 2014. I had dodged the bullet so many times over the previous 50 years. Turns out, I got a very nice severance, so I really could not complain at age 72. I really...
  5. S

    I'm saying mostly goodbye

    It's Past Time I'm 4 weeks from the fifth anniversary of my layoff/retirement from my job. I was planning to retire on July 1, 2014. I had dodged the bullet so many times over the previous 50 years. Turns out, I got a very nice severance, so I really could not complain at age 72. I really...
  6. S

    Word 80 page book fold

    How will Word print an 80 page (20 sheet) booklet? I would hope something like 2 8-sheet signatures (64 pages) plus one 4-sheet signature (16 pages) for a total of 8 pages. Skip, [glasses]Just traded in my OLD subtlety... for a NUance![tongue]
  7. S

    For Computer Dinosaurs

    Meet The Thing King... http://duartes.org/gustavo/blog/post/the-thing-king/ Skip, [glasses]Just traded in my OLD subtlety... for a NUance![tongue]
  8. S

    How does SUMPRODUCT() work for Multiple Criteria Aggregations?

    Please check out FAQ68-7898. Does it adequately explain how this function works? Skip, [glasses]Just traded in my OLD subtlety... for a NUance![tongue]
  9. S

    An Example of Chart Events

    This was posted in forum68 and never got into this forum wher it really belonged. There is a fully functional workbook with a chart events example, FYI. http://www.tek-tips.com/viewthread.cfm?qid=1771963 Skip, [glasses]Just traded in my OLD subtlety... for a NUance![tongue]
  10. S

    Excel CHANGES all NUMERIC data that you enter into your worksheet!

    This is a reminder that Excel CHANGES all NUMERIC data that you enter into your worksheet! I know. This is a tabloid trick! but it's true! This is highlights & expansion from faq68-7375. When you see the word CONVERT it means change, but in a very specific way. When you ENTER 10 in a cell...
  11. S

    Frequency Function Anomaly

    Today there was a post, Distinct Count With Multiple Qualifiers. The Data example was Tote # MHE Translated Tote 1 TWR1EXT2 Tote 1 TWR1EXT2 Tote 1 TWR1EXT2 Tote 2 Location B Tote 2 Location B Carton 1 TWR1EXT2 The user wanted the unique count of Tote # and MHE Translated...
  12. S

    FYI: MS Patch Clobers ActiveX Controls &amp; Macros

    http://www.infoworld.com/article/2858280/microsoft-windows/botch-brigade-kb-2553154-2726958-clobber-excel-activex-kb-3011970-silverlight-kb-3004394-root-cert.html
  13. S

    No more trophies for participating

    Let's heat this general topic just a tad. http://abcnews.go.com/blogs/headlines/2013/10/texas-football-program-wants-kids-to-earn-their-trophies/ I believe that the participation trophy mindset is a fantasy frame of mind. Skip, [glasses]Just traded in my old subtlety... for a NUANCE![tongue]
  14. S

    Variable Grouping

    Here's my sample table OAI OUT AT AT IN OUT IN The rules for a new column groupID are as follows: when OAI = 'OUT' then [prev groupID] + 1 else [prev groupID] in order to get OAI groupID OUT 1 AT 1 AT 1 IN 1 OUT 2 IN 2 Your expert advice is appreciated. Skip, [glasses]Just...
  15. S

    Structured Table: Column Reshuffle Issue

    1) The ST is created (in my case it is usually as a result of a query). I returned 2 columns from an external table: CC_CATEGORY, CC 2) A formula is created in an adjacent column of the table to reference a heading. I named my table tCC. My formula is =COUNTIF([CC_CATEGORY]...
  16. S

    Excel 2007 - Personal.XLSB Missing

    The company recently upgraded to Office 2007. (Windows XP) From that time, my Personal.XLSB does not open when loading Excel. My Personal.XLSB is in the XLSTART folder in both these paths C:\Program Files\Microsoft Office\Office12\XLSTART C:\Documents and Settings\ii36250\Application...
  17. S

    Has any experienced Excel power user also used Qlikview?

    Seems to me from the info I've read, that an experienced Excel user could do the same external data access, interactive charts & reports as Qlikview advertises. Where am I wrong? Skip, [glasses]Just traded in my old subtlety... for a NUANCE![tongue]
  18. S

    An Excel Structured Table Conundrum

    Are you using Structured Tables in Excel 2007+... well are ya? Well I am, and loving NEARLY every minute. But I've run into an opportunity. I am essentialy creating my own pivot on dates. The ROW data is created using a query of my source data to get unique values. The COLUMN data is date...
  19. S

    Can Extra! Be Used to Control an SAP Session?

    In our former IMS system, I could use an Extra! emulator to scrape data from the terminal and put data on the terminal screen that would update the IMS system. In this way a significant number of updates could be performed with little or no user involvement at the terminal. Are there any...
  20. S

    Mass Update Process

    In our former legacy system, IMS, I could use a terminal emulator to scrape data from the terminal and put data on the terminal screen that would update the IMS system. In this way a significant number of updates could be performed with little or no user involvement at the terminal. Are there...

Part and Inventory Search

Back
Top