I have the following formula that works:
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...
I'm trying to use a Vlookup to use different ranges within an existing Vlookup depending on what's in column B.
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...
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...
The code below worked fine until I added the line (text in red)
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
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?
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 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!
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Application.ScreenUpdating = False...
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
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...
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.