pictures in excel

Hello All, I found a script online that I have successfully gotten to add pictures to my excel sheet in the location I want them. :) (Trust me this was an accomplishment I am new to scripting - read Please, please be patient with me and my bumbles here ;)) Here is that script, as I have it...

Okay, I feel embarrassed to even be asking such a seemingly simple question, but I just switched to Office 365 from Office 2013. Does anyone know how to change the Insert Picture default folder in Excel? I found it in the advanced options for Word, but haven't been able to find it anywhere in...

Hello all, I've been working on a program that will show a different picture depending on a selection from a dropdown list, it's on a sheet that may need to be copied several times and the PC this will be used on isn't great, can anyone offer any idea for this? Stuff I've tried already: 1...

I'm not great with VBA, but I think it's the only way to solve this puzzle. I have a table with one picture in a particular cell that will move around. (It's a linked picture to a table, since you can't nest tables. -___- ) What I would like is this: A macro/VBA code that will BOTH expand a...

I have 40+ reports that I generate weekly for different clients. I have the workbook set up so that each report is in a new sheet/tab and have a macro that runs through and saves each report as a PDF using the file name I desigate in a cell within the sheet. My clients are now wanting the...

I am trying to change the columns of a Waterfall chart from bars to an arrow. I know how to accomplish this in Excel but I need to make this happen for the user with VBA. The macro recorder does not work when modifying charts in Excel so I cannot find the code to create a pictograph there or...

Hello, I got the following code from this forum itself that works great: But when I change it to the following code: It does not work with cell J1. I am not sure what do i have to do to make it work. I want both pictures to show up when two different values are selected in those two cells...

Each month I receive a spreadsheet from another office. From it I extract certain data. I have created a macro to loop thru and do this. The problem is, some cells contain both a picture and text. I need to ignore those cells. I need a way to determine if a cell contains a picture. The only...

Hello, I have inserted pictures into my worksheet with this code: Sub InsertPicture() Dim sPicture As String, pic As Picture sPicture = Application.GetOpenFilename _ ("Pictures (*.gif; *.jpg; *.bmp; *.tif), *.gif; *.jpg; *.bmp; *.tif", _ , "Select Picture to Import") If sPicture =...

Hello. I was wondering if it is at possible to obtain data for a graph that has been pasted as a picture? It seems unlikely to me, but just thought I'd ask anyway.

I created a VBA program that allows you to select pictures via command buttons and by typing in data (one set of pictures is selected by the command button and the detailed pictures is selected by typing in the desired picture). My file was working perfectly when I left it and after someone else...

Hello, I have been looking into this for awhile. I have a very basic knowledge with excel 2003. I got an excel (2003) file that have over 15,000 links to pics. Every cell has one link to a pic <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...

I am trying to find a simple way of automatically adding pictures into an excel cell depending upon a % factor. i.e. if C1 = >80% i want to add a picture of the sun in D1, but if C1=<79% i want to add in a picture of rain clouds. Can anyone pls. help with this. :confused: