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: dcompto
  • Content: Threads
  • Order by date
  1. dcompto

    How to write this formula in VBA

    I have hit a wall in writing a portion of an Excel 2016 macro... Haven't figured out how to write VBA for: In ws Extracted1, For every row, compare cell F to cell P, If F = P, copy F to ws Sorted corresponding row of cell B If F <> P, copy P to ws Sorted corresponding row of cell B I have a...
  2. dcompto

    Clearing Data Form Criteria - Excel 2016

    I'm trying to use a Data Form to quickly find and view all fields of a record matching the Name field criteria then repeat the process for multiple records. I enter the name (or partial name with *) in the Name field and it displays the record. I then click the Criteria button followed by the...
  3. dcompto

    Excel 2016 PivotTable Start_Time field shows as Duration - Why?

    I've been doing this type of PivotTable for several years without problem but recently upgraded to Office 2016 and Windows 10 and I can't figure out why my Excel 2016 Data (defined as a Table) changes the Start_Time field (formatted as Time > 1:30 PM in the Table) is shown as if if were Duration...
  4. dcompto

    Excel 2010: Exlanation of formula for Thanksgiving date of current year

    I found a formula for determining the date of Thanksgiving for the current year from http://chandoo.org/wp/2009/11/25/findout-thanksgiving-date/, and it works great. However, I do not understand the explanation of the ",26,25,24,23,22,28,27". Can someone explain it to me so I can understand...
  5. dcompto

    Word 2010 Tell which label (Product Number) used in existing doc?

    Do you know of a way to tell which labels product number was used for an existing Word 2010 doc? I have a label document that was created by someone else and I'm wondering if there is an easy way to determine the product number (instead of applying borders to the labels, measuring the label...
  6. dcompto

    Outlook 2010 conditional formatting - whole words?

    Using Outlook 2010, and trying to set up conditional formatting for words in Subject line: "bus", "shuttle", and "BOB reservations", but emails containing the word "business", etc. are also being affected. Have even tried putting a space after each one of my conditional words and phrases without...
  7. dcompto

    Create field for Video Length

    Win 7, Access 2010: I searched this thread and googled a lot yesterday, but have not found an answer. I'm creating a database for 100+ YouTube videos created by one of my bosses and I need to include a field for video length. Would like to be able to perform calculations on the field and for...
  8. dcompto

    Acrobat X javascript for Protection &gt; Remove hidden information... &gt; MetaData

    Using Acrobat X, I have created an Action that does: Step (1) Execute Javascript 'to apply a copyright watermark /* Watermark - COPYRIGHT */ this.addWatermarkFromText({cText: "COPYRIGHT \xa9 " + util.printd("yyyy", new Date), nTextAlign:app.constants.align.center, cFont: "Arial Black"...
  9. dcompto

    Flatten Transparency via Action with javascript

    I created an Action that executes javascript that inserts a Copyright [yyyy] watermark at a 45-degree angle on all pages of my PDF, and I would like to add more javascript to perform: Tools > Print Production > Preflight > Flatten transparency (high resolution) How can this be done?
  10. dcompto

    PivotTable style with Banded Rows not working (!?)

    I created several PivotTables off of my Excel Table that is formatted using Table Style Medium 2. I have tried applying Pivot Style Dark 2 (with the Banded Rows option selected) for each of the PivotTables; however, it does not give me Banded Rows. Can anyone tell me how to get Banded Rows to...
  11. dcompto

    Formula using PivotTable count results?

    I need to do a formula (MyCalc) using my Pivot Table's count results ($B4:$B12). Can this be done? For example: Leader1 Count of Student MyCalc StudentName 13 $B4*3 StudentName 9 $B5*3 StudentName 5 $B5*3 StudentName 3 $B5*3 StudentName 2...
  12. dcompto

    WORD/EXCEL 2010: Directory Merge

    Word 2010 Directory mail merge. Excel 2010 table. Can anyone help with this? I'll be glad to pay an agreed fee. I haven't figured out how to configure the merge Form to: (1) create separate tables for each day of the week, beginning each one on a new page. (2) only insert the Start field in...
  13. dcompto

    2-Column Date Range Extract

    Using Excel 2010 (A) (B) (C) (D) (E) EMPLOYEE ID FROM TO EMAIL Examples of Columns C and D: FROM TO 01/01/12 01/17/12 01/18/12 02/29/12 01/18/12 02/29/12 01/18/12 02/29/12 03/01/12 05/31/12 03/01/12 05/31/12 09/01/11 05/31/12 09/01/11 05/31/12...
  14. dcompto

    Nested If statement in Excel&gt;Word merge for Days (M, MW, MWF)

    I'm trying to create a Class Schedule by merging data from Excel to Word 2011. The "Days" column is Text and the "Start" and "End" columns are time fields. The Excel data looks like this: Course Description Days Start End Room Instructor MAE 3323 Mech Des I MWF 8:30 9:20...
  15. dcompto

    Edit VBA code - Save Emails From Outlook To Hard Drive

    Can anyone look at the code, below, and tell me how I should edit it? Googled and found code to "Save Emails From Outlook To Hard Drive". Works great, but I need to make an adjustment. Upon Save, the subfolders are placed outside the parent folder. I need the subfolders to be saved inside the...
  16. dcompto

    WD2007 open template as new doc INSIDE Word

    Template pinned to Office button in Word 2007, opens as a template instead of a new document based upon the template. Prof wants faster way than Office Button > New... > My templates... Anyone know a much faster way? He already knows he can double-click it OUTSIDE of Word.
  17. dcompto

    OL2007/2010 drag &amp; drop message into EXISTING appt

    Using Windows 7, Outlook 2007/2010, Exchanger Server... I know to drag & drop an email message onto the calendar icon in the Navigation Pane to insert the text of the entire message into a NEW APPT, but my boss wants to also drag & drop messages onto EXISTING APPTS. Does anyone know a way to...
  18. dcompto

    Copy/print Excel formulas with color-coding from edit mode

    Excel 2007, Win 7: Anyone know a way to copy or print Excel formulas with the color-coding that is shown in edit mode? I know several ways to convert formulas to text, none of which include the color-coding. TIA.
  19. dcompto

    Outlook 2007 search &amp; replace hyphens in Subject

    Using VBA in Outlook 2007, can someone tell me how I can code to change an en dash to a hyphen IN THE SUBJECT LINE? I have already managed to put together code that cycles through each mailitem in a picked folder and saves each attachment using its mailitem's custom Subject line, but I need to...
  20. dcompto

    .bat file to append login/logout timestamp to .txt file

    If this is not the right forum for this question, please let me know. I would like to have a simple .bat file to append my login/logout timestamp to a .txt file. The login part is easy: echo Login %date% %time% >> C:\DOCUME~1\[username]\Desktop\Login_Log.txt but I haven't figured out the code...

Part and Inventory Search

Back
Top