1. K

    Embedded If Statements

    I have the following formula that works: =IFERROR(IF(AND(D5="Y",E5="Y"),C5*$G$2,0),"") I need to add an additional piece that says to look at a cell in B5 and if it says INACTIVE then multiple C5 with G1, otherwise I want it to do the original formula posted above. I have not successfully...
  2. G

    Embedded Vlookup problem

    Hi, I'm trying to use a Vlookup to use different ranges within an existing Vlookup depending on what's in column B. =VLOOKUP(A2,VLOOKUP(B2,StaticData!$A$2:$X$21,24,FALSE),2,FALSE) I'm getting an #value because the range is coming back with speech marks around it... Any help appreciated...
  3. T

    Outlook VBA way to differentiate between attachments and embedded images?

    I'm trying to prevent myself from accidentally sending a file to someone outside of my organization's domain. (We've all hit the "reply all" button and sent something to someone we didn't know was in the email chain, right?) I've got some code I found online, but it doesn't make a...
  4. A

    Opening embedded PDFs in Excel 2016

    I have embedded several PDFs into an Excel spreadsheet using the process detailed here: https://www.youtube.com/watch?v=btzTt8whcL4 When I try to open them (either by double clicking or by selecting Adobe Acrobat Object -> Open) nothing happens. I'm using MS Excel 2016, and Acrobat Reader DC.
  5. B

    Hide blank sheets that do not have an object embedded

    I wonder if anybody can tell me if this is possible I have a workbook with a few blank sheets; these are used to embed pdf documents if required. However I would like to is run some code to hide the empty sheets if there has not been a pdf document embedded within that sheet. Below code will...
  6. J

    Changing an Embedded image on a button with code

    I have a sort button I want to change the picture on between the embedded images of "Sort Ascending" and "Sort Decsending". Since they're embedded within Access, I'm not sure what I need to do to get to it. I do remember seeing something about resource databases that are kind of like system dbs...
  7. N

    Multiple Embedded IF/AND Statements

    This below formula is only returning the first IF Statements Value if True value and everything else is just 0. Does anyone know why this is happening...
  8. E

    How to reference worksheet object embedded in Powerpoint using Excel VBA

    Hi VBA Gurus, I would like to reference a worksheet object which is embedded in PowerPoint can someone advise how I can reference it using VBA. My code is in Excel Workbook VBA Editor and I have added the powerpoint libary so I will be using th Ealy Binding technique. The original name of the...
  9. Trevor3007

    debug error Y/N

    hi, The code below worked fine until I added the line (text in red) Sub savetab() If MsgBox("Do you want to save as a MACRO embedded workbook?", vbYesNo) = vbYes Then ActiveWorkbook.SaveAs "C:\Users\data1" & Application.PathSeparator & ActiveWorkbook.Sheets(1).Name & ".xlsm", 52 Else...
  10. A

    Copying Macros To A New Workbook

    In my VBA project, a worksheet is created, copied to a new book and saved. This worksheet is like an internal user order form and has a few macro embedded shapes on it for use by the user using the form which is emailed to them. The macros are stored in the workbook that created the initial...
  11. D

    Embedded If statements versus lookup tables

    I am trying to optimize the following and not sure how to do so. I have a list of 50 items. Let's say ten of them need to return a value based on the item in the list whereas the other 40 need to simply return a default value. For example, I have a list of vendors and need a column for the...
  12. K

    Emailing worksheet as attachement via embedded Hyperlink

    Hello! I've embedded a hyperlink within my Excel 2010 worksheet for email purposes; however, I need the email to automatically attach the spreadsheet I am working on. What is the easiest way to do this? Thank you!
  13. C

    Embedded files within excel naming

    In Excel, when I go to Insert/Text/Object/Create from File/Display as icon then Browse and find the file I am wanting to embed. Then go to Change icon and ensure that my Caption box is the exact name of the file I am wanting to embed, then click OK. It successfully embeds the file and shows...
  14. J

    Translate an embedded Excel formula in vba for Excel

    Hi, I need help. I need to put this formula in Excel in vba code...
  15. sdruley

    Copying last 18 records of text file to worksheet

    URL: https://www.screencast.com/t/Zq5GPIg7Dsm EMBEDDED CODE: <!-- copy and paste. Modify height and width if desired. --> <a href="https://content.screencast.com/users/pharaohdruley/folders/Default/media/1f24e3a6-f70e-4c59-98e5-08f405443f6c/09.08.2018-11.38.png"><img class="embeddedObject"...
  16. C

    Unable to attach multiple embedded PDF from excel into Outlook

    Hi, I am unable to attach multiple embedded PDF from excel into Outlook. To attach single embedded PDF is working fine if the PDF size is no more than 20 KB. For the multiple embedded PDF, my end result will be taking the last embedded PDF. My questions has 2: How to reduce the PDF size...
  17. P

    Embedded code to auto re-size columns no longer working in win10/excel2016

    I had this embedded code in a worksheet to auto re-size columns. When I upgraded to win10/excel2016 it no longer works. Please help! Option Explicit Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Application.ScreenUpdating = False...
  18. R

    Embedded If statements

    I need help putting in ranges for my embedded IF's in a formula If $A7 is = to 1-7 (meaning 1,2,3,4,5,6,7) return value 0, if $A7 is = 8-22 return value of 1, IF $A7 is 23-37 return value of 2, if $A7 is 38-52 return value of 3 Thank you
  19. C

    Embedded PDF file won't open

    Through the help of many on this site I created a worksheet that you can add an embedded PDF or other type files and this works GREAT but now for some reason I have 1 excel file with an embedded PDF that just will not open... clicking on the embedded file does nothing... there are embedded .JPG...
  20. B

    Embedded word file in excel

    Hello, This is a spreadsheet I've been using for some time now and the embedded file was working. Today I'm having trouble opening the file. When I click on the file it's selected as though I want to copy of move the file to another location. Thanks bell1958

Some videos you may like

This Week's Hot Topics