embedded

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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!

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

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

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

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

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