1. 7

    Query as record of subqueries - how to load subqueries in ExcelTable or DataModel

    Hello everyone, it proved to be the most useful to divide the query into small parts that can be easily tested and reused. So I'm trying always write the query as a record of subqueries like it is in #shared, for example: Data = [ Cleaned = let source = csv.. renamedColumns = ...
  2. J

    Image scale to fit on userform

    Hi, I have a large area on my userform which I want an image to occupy. The image which is inserted is based on a CB selection. However, when the image is inserted, its always much smaller than the pre-determined area. I know I can scale the image area to fit the smaller image, but is there a...
  3. J

    Display graph/chart in userform based on Combobox selections

    Hi all, So, I have a serform (U1), which has two combo boxes (CB1 and CB2). I would like the user to be able to make a selection from each combo box and this to plot a graph. The Y-axis values of both comboboxes is the same. I have a work sheet (see pic), with the number of fruit sales on...
  4. 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...
  5. 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...
  6. 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...
  7. 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.
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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!
  16. 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...
  17. 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...
  18. 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"...
  19. 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...
  20. paquirl

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back