embed

Hi All I understand that one can embed a Worksheet or selected range from a Worksheet into a userform and that this Control should be available on the Form Controls Toolbox. I cannot seem to find it, does anybody know what it is called? Is it one of th Additional Controls? Thanks HighandWilder

Hi, Is there a way to show a specific page in a PDF when inserting it as an object? I have i a PDF on 4 pages that i would like to insert as 4 object, showing each page. When I insert the object, only the first page is shown. Is there a way to alter this? I am doing the insertion as a macro...

I have a hyperlink on my spreadsheet that, when opened, reveals a string of numbers and letters. I need to be able to see this information real time. Is it possible to embed this string in a neighboring cell so I can refer to it? Thanks for any help on this.

Hi, I'm trying to embed formulaB8 into formulaB9, resulting in valueA11. <tbody> formulaB8 : SUM(A2:A4) formulaB9 : =SUM(formulaB8,2) valueA11 : 8 </tbody> I'm trying to do this without actually pasting the formulaB8 text into formulaB9. Since I have one large formula that is re-used...

Hello! I hope this is the correct forum to post this question in, I apologize if it should be in the Excel forum. I am using Power View via Excel(2016) to display a bubble chart on an aerial photograph. I would like to add an image (.jpeg) that I can adjust the transparency to display on top...

Good afternoon, I have created an Excel template that includes an embedded object (PDF) using an icon. Currently, clicking the icon takes me to PDF "A". I would like to copy this template and edit the embedded object/icon so that clicking it takes me to PDF "B", PDF "C", and so on so that I do...

Hi, Can you please tell me if i want to embed my online excel workbook in a restricted webpage (clients can access after username and password) 1. Does my workbook can give access to multiple users at the same time such that one user who is currently editing a workbook doesnot create problems...

I embedded an Excel file into a WordPress page via OneDrive, but I can’t edit the cells on smaller screen devices. A PC with a mouse or touchscreen works fine. A Samsung Galaxy Tab 2 7.0 also works, though it requires multiple taps / double-taps to select the cell (shows white circle anchors...

Hello folks, I'm trying to add a standard "File Open" dialogue box into a userform, in Excel 2016 64-bit version. (1) There is a way to do this in Excel 32-bit version, described here: Design a VBA User Form - ComboBox and Open File Dialogue Box Controls In short, [VBA Editor - Tools -...

Hello all, I'm trying to figure out how to do this properly, but I can't figure it out yet. I am trying to make a cell in my workbook, reference the value of an uploaded file (and cell) in onedrive. Can anybody help me with this? I have no issues with a local computer address, but I can't...

Hey guys, first off thanks for the help. Tried searching butdidn't find anything related.<o:p></o:p> For work I have to take pictures of several different featuresand add pricing information and condition etc. Basically I want to embed a jpegfile in the workbook with a saved copy in the actual...

I need help with this spreadsheet. We cannot load the sound files on computers, so the files need to be embedded. They can be a wav or an mp3. The spreadshet is used to track projected hours for each store. Ideally we would like a cash register sound (green.wav) to play when the value is...

Hello (to be short), I'm creating a custom (Usercontrol (ocx)) Userforms for excel, the name is Virtual forms. (Not to bother with the details, you can read about it in the Lounge v.2.0 here in MrExcel forums...

Hi everyone, I am planning to link a website with an excel file (rather than coding the formulae into PHP) so when a user enters the input values then the output from cell “A8” of the workbook should be displayed in the webpage. More details below – for example 1. In the web page you see...

My VBA is currently adding a list of photos from a file chosen by the user but as others have had the problem it saves them as links instead of embedding them. Is there a way to choose all and convert them after they have been inserted? Sub AddOlEObject() Dim mainWorkBook As Workbook...

Hi all, first post! I have created two ways of embedding chart images via VBA into a new Outlook email: 1) Display the email and then paste the chart image into the body 2) Embed the images via HTML (after attaching files) Both of these solutions create and send the email which can be viewed...

=IF(L2="Closed",(IF(MONTH($E2)<=3,"Q1",IF(MONTH($E2)<=6,"Q2",IF(MONTH($E2)<=9,"Q3",IF(MONTH($E2)<=12,"Q4",""))))&"-"&if(isblank($J2),Year(I2),$J2),"") Hi, Can anyone recognise where the error lies in the formula above? It won't let me enter it. If you need any more information then let me...

Hello, I have a macro that searches a folder on my desktop for a particular image and then inserts it into a designated column. Sku's listed are in column D. Respective images get inserted into column C. Sub ProcessFiles() Dim sPath As String, s As String, r As Range Dim shp As ShapeRange Dim...

Hello there i have a excell addin thats importing pictures based on cell value. The addin got 4 userforms -selecting cell where the picture will be inserted. -selecting the article value -selecting the first and the last row -selecting the folder where pictures are located. The problem is...

Hi everyone, I am in the process of integrating an excel sheet onto a webpage that I am working on. The website is currently running off wordpress. What are my options if I want the spreadsheet (just one sheet only) to be embedded on to the webpage, but still have the sorting functionality...