Search results for query: *

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...

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'...

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...

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...

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...

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]

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]

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]

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]

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...

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...

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

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]

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...

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]...

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...

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]

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...

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...

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...