embedded

  1. 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
  2. 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...
  3. 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
  4. S

    Counting cell that have numbers in the string

    I'm trying to count the cell that have a number embedded in the string: <tbody> 11/10/2016 11/14/2016 11/17/2016 11/21/2016 11/24/2016 </tbody> <tbody> 1zSMITH 2zSMITH SMITH SMITH3 x4zSMITH </tbody> I can count if the Number is 1st or last but am having problems when the are embedded. The...
  5. P

    Is there a VBA macro that can embed an email that is in the outlook Inbox into an Excel sheet?

    To all Excel Gurus! Is there a vba macro that can run from Excel that will open up the Outlook Inbox so that a specific email can be selected and be embedded into a spreadsheet as an object? ie. When a user double clicks the embedded email icon in the sheet, then that particular email opens up...
  6. R

    Consolidating embedded PowerPoint data in to a single chart

    I am creating a report in PowerPoint 2010 with charts on separate slides. The chart is the same layout each time, and the data refers to a different subset of team members. (If it helps, they show forecast project hours versus actual project hours for our developers, split by our...
  7. T

    Embedded Word Document Issues

    Hello I've embedded a Word document into an Excel file. Everything works great, however, it looks ugly. My main issues are: When I click on the Word file's icon, the icon shows a bounding box around it. The Word file's icon can currently be resized and repositioned anywhere in the Excel...
  8. L

    copying header/foorter which has pics

    Hi Is it possible to copy header/footer which has embedded pictures and tabs from one file to another? Thanks
  9. D

    VBA grab pictures from shapes and name as adj cell

    Hi This is a bit complicated to explain but I shall try!!! I receive a price list from a supplier, which contains PartCode,Description and price, it also includes an embedded picture shape of the product (which has generic names e.g. picture069) and a hyperlink embedded in another shape with a...
  10. R

    Data input = automatic formula input

    Is there a way that a formula can be automatically applied to a cell if specific data is input in another? For example: If "vendor" is typed in B2, (specified formula) is automatically embedded in F2.
  11. M

    Embedded If/Then Formula

    Hello all, I'm having an issue with an embedded IF/THEN Formula which has three different IFs. Every values in the L column will change. The different choices are: No quotes, I'm putting them there to show the spaces before or after the value. 1. "# %not " (# being a single number) 2. ST00...
  12. U

    vba code to copy the embedded text file from excel and to paste in a floder

    Hi... need help sooon! I am trying to copy the text file which is embedded in my excel, and trying to paste it in a folder using the below code. ActiveSheet.OLEObjects(1).Copy CreateObject("Shell.Application") _ .Namespace(ActiveWorkbook.Path & "\") _ .Self.InvokeVerb "Paste" It is working...
  13. G

    Is there a way to stop this VBA from falling over if an error happens?

    Hello; I have some embedded VBA I'm using that clears the contents of a cell if another cell is changed. These columns are used for data trending, and so its basically to ensure the data is trending correctly (i.e. sub-area matches area) Here is the code: Option Explicit Private Sub...
  14. O

    Printing Embedded Word Document and Active Sheets

    I have a spreadsheet that has multiple tabs in it. I need to be able to FIRST print the 'Comments' tab (which contains the embedded word doc that is 4 pages long), then print all active sheets that are visible. I've tried this piece of code, but I throw an error "User-Defined Type not defined"...
  15. T

    Embedding objects in a workbook

    Is it possible to secure an embedded object within a cell in excel so that it doesn't move when you change margins or add rows/columns?
  16. C

    Algorithmic formula help - works horizontally not vertically

    How can I write a formula to display data as per the below? The 239.555 is cell C2. The months going horizontally start from E3, going vertically they start from B5. In E5 I am up to here with the formula (needs to be dragged across and down) so as to apply the pattern below to each row...
  17. C

    Converting algorithm to formula ( embedded IF AND )

    Morning, I have the following algorithm: <TBODY> N</SPAN> Y</SPAN> Y</SPAN> N</SPAN> Y</SPAN> Y</SPAN> Y</SPAN> </TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL></COLGROUP> The part I have bolded repeats infinitely afterwards. I need to convert this into an excel formula. Where a 'Y'...
  18. C

    IF OR functions, unless a certain condition is met

    Hi all, What I want to achieve is this: Display me a set value e.g. 10, every time that EITHER condition A or condition B are met, UNLESS a given cell = 0. To give some context, this is relating to deliveries of a product. I am forecasting the costs incurred over a period of years where...
  19. T

    How to extract image from embedded OLEObject and paste into Word?

    Hi, I've embedded images into my spreadsheet as icons using the code below, and I need to then copy the images into Word - not images of the icons, but the original images. Is this possible? If so, can anyone help with how? I've tried several things, including Steve Bullen's PastePicture, but I...
  20. P

    VBA code to open and amend the embedded word doc in an excel sheet!

    Hi All , I need a vba code which can open an embedded word doc ("Doc1.docx") in my Excel Sheet1, amend the document the way I need (code that I already have), copy that amended version, paste it in the new mail of already opened Outlook, keeping the format intact and eventually close the word...

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
Back
Top