Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Import Image From Web

Is there a way I can import, to my excel sheet, an image (or photo) from web? Web query only let me import data not image.

View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Is There A Way When Type Image Name In Textbox It Load Out That Image
is there a way to load an image out when u type the image name in the textfield.
Example when I type in my name it load my image out beside the name.

View Replies!   View Related
Embed Image In Cell :: HTTPS URL To An Image
I have a dataset that includes the path and optionally an HTTPS URL to an image. Is it possible to embed this image in a cell?

Short of that what might be some other options?

View Replies!   View Related
Display Image Based On Image Name In Cell
Is there a way to have image box display an image with a name matching data from a cell? example: if I type "hello" in cell a1, Image box will load image named "hello". And display new images by changing the name in cell a1. Note: the images will be located in a permanent folder.

View Replies!   View Related
Add Image To Worksheet Image Control
I am trying to display an image ("image") on an image control ("Image1") placed in a worksheet ("Sheet1"). The problem is that I want this action to take place when I press a button in a user form. I am trying to use the following code, but it seems that VBA does not recognize the image control ("Image1") in the worksheet.

Private Sub cmdDisplayImage_Click()
Dim image As Variant
image = ThisWorkbook.Path & "sun.jpg"
Image1.Picture = LoadPicture(image)
End Sub

View Replies!   View Related
Import Multiple Text Files & Copy Each Import
I'm attempting to import around 200 (and growing!) separate text files into Excel. I am using the formula below to import the text file and then using a separate macro to select the information I need, copy it into another spreadsheet, and then run the import macro again.

However, I have a problem in that my import macro gives me 'Run-time error '1004:

Application defined or user defined error''. At first this wasn't a problem as the information is pasted into the spreadsheet despite the error anyway. However, now that I am looping the macro it is obviously causing more problems as it prevents the loop. I would really appreciate it if anyone knows of a work-around or can spot an error in the coding to resolve this!

The code below shows is for the import macro only:

Sub ImportTextFile(FName As String, Sep As String)

Dim RowNdx As Long
Dim ColNdx As Integer
Dim TempVal As Variant
Dim WholeLine As String
Dim Pos As Integer
Dim NextPos As Integer
Dim SaveColNdx As Integer

View Replies!   View Related
Import CSV Every X Minutes Without Import Dialog Appearing
I have a simple macro importing a .csv data file to a worksheet every 30 minutes.

When the macro runs an Import Text File dialog box displays.

What do I need to do to have the macro run to completion without the dialog box interruption?

Sub RefreshHourlyData()

htime = Now + TimeValue("00:30:00")

Application .OnTime htime, "RefreshHourlyData"


Selection.QueryTable.Refresh BackgroundQuery:=False


End Sub

View Replies!   View Related
Image In Pop-up
I have three worksheets A, B, and C. I'm using the worksheets as a pseudo-database. Worksheet A contains raw data. Worksheet B contains a look-up table. Woksheet merges the information together. Currently I do have the VBA code working to compare the value in WS A to WS B and if they match then it inserts the data into WS C. What I am wanting is a pop-up window that when the value is WS A isn't contained in WS B. This pop up window would contain both an image (to be dynamically pulled from the hard drive) and a text input field. My next step would then take the input field and inset that into WS B.

View Replies!   View Related
Insert Image
I have a multi-row ,multi-column spreadsheet which lists furniture items, and with some plain Excel formulas allows me to create a proper list.

I'm using Excel as a database, in Sheet1 I have all the data, and Sheet2 is actually where I select the data and set the list of the chosen items.

Now, I have the images for all the items listed in Sheet1 in the same folder of the xlsm file, and I want to insert the proper image in a given cell in the given row.

Looking for something which may do the trick I did find this code in your site and it actually works for me!

Now, what I need is to provide the PictureFileName and TargetCell via parameters already present in the spreadsheet.

Say I want to retrieve the image shelves.jpg which is in the folder DATABASEimgs in your code mentioned above I manually set the string for PictureFileName like this

View Replies!   View Related
Find In The Image
I need the desired output as found in the image.

View Replies!   View Related
Display A Web Image Using VBA
I am using a macro to display an above 255 character image:

Sub Test()
Dim URL As String
URL = Worksheets("Sheet1").Range("B4").Value
ActiveWorkbook.FollowHyperlink URL
End Sub

Is there any way of opening this in a specific part of the spreadsheet (say aligning with C5) rather than a separate web browser?

View Replies!   View Related
Image Viewer
I want to set a image viewer with excel where I select any cell read that cell and show the same image in that viewer

Image viewer

1 Abc_xy45
2 xyz_er45
(these all are style no )

I made a folder where I store all images with style no
it will be same no in A Column

So when I select any style no I can able to see image in image viewer is this possible?

View Replies!   View Related
VBA Display Image
I'm trying to writ a small user form with a text box, buttom and image container. The idea is when I type a sign number and click the button the form add the sign number to the address path of the folder containing the images and set the image containers picture to the corisponding file .. this is what I've done so far but I cant get it to work -

View Replies!   View Related
Fit Image To Cell
I'm looking to see if there is a feature similar to using F2 to paste text into a cell and having the cell automatically expand to the needed row height. I just need it for images. Is there a feature that will allow me to paste a picture/image into a cell and have the cell automatically expand to the height &/or width needed to accommodate the size of the image?

View Replies!   View Related
Text/Image Loader
I need a macro that load from a folder a specific file text(.txt) and then load the txt content in the sheet work. But no all the content just a one part. A one column

Only the first one column of the text.

You can see an example here.....

View Replies!   View Related
Shortcut To Copy As Image
I'm copying a lot of tables and charts etc in Excel to paste into PowerPoint. And I'm using the mouse to go into Past > As image > Copy as image

I then get asked a question that I need to hit the enter button to answer.

I'd like to make a shortcut for this. Is this possible in VBA?


Using Excel 2007 & Vista if that matters

View Replies!   View Related
Batch Image Saving
Added pictures of the items to include on quotes (the pictures are in a column to the right of all the other details - (these pictures only exist in Excel)).
Our new quoting software tool needs a link to the filename - however, our pictures don't have logical filenames!

Is there a way we can do a batch save as of all these images so it ends up as 'part#'.jpg within folder X?

There are about 6,000 products and will be a bit of zombie work we don't really want to do!

View Replies!   View Related
Creating An Image From A Graph
I want to add a button to a worksheet to allow a graph to be exported as an image. This seems to be a fairly common request, I have read some of the posts but cant get it to work. I am using Excel 2003 as that is all we have...

So, I have a simple button on 'sheet1' containing :

Sub CommandButton1_Click()

Worksheets("Sheet1").ChartObjects("Chart 1").Chart.Export Filename:="h: est.jpg", FilterName:="jpg"

End Sub

.. but it doesn't work. I get the error :

Run-time error '1004':
Application-defined or object-defined error

View Replies!   View Related
Search Image From A Folder
I really need a macro that from a targeted folder, if i write an image filename in a cell box, that image is showed in a Image control box.

View Replies!   View Related
Link Image To Cell
In Excel, I have a sheet for each team that I manage. Each sheet lists the team members and displays their picture below their names. Some people are on multiple teams/sheets.

I have a master list with everybody's name and picture that I copy and paste the pictures from when putting a team together. This has become a very tedious process.

Is there a way I can type the person's name on a team sheet and have their picture automatically appear below their name? I don't know if this can be done with some kind of lookup or if it will involve VB. I tried making the picture the background of an Autoshape or comment, but I could not figure out how to dynamically change the picture based on the name in a cell.

View Replies!   View Related
On Click Move The Image
I need information to be automatically entered into a specified cell on Sheet 1 when an image I've pasted onto Sheet 2 is clicked on or moved. How can I do this? Is this even possible?

View Replies!   View Related
Convert Image To Thumbnail
I'm a total noob and I'm running into a problem. I'm trying to link thumbnails or pictures into a cell but I'm not sure if it's possible. I need to type in the cell where the image is stored and have it pop up in the cell.

Is that possible? I don't want it floating on top of the cell but within it so I can adjust the cell so the picture will resize accordingly.

View Replies!   View Related
Auto Format Image
I've got a simple macro for asking a user to locate a file of choice and inserting it into specific cell.

Is there a way I can code it so that regardless of the image it 'fits to fill' the cell? The images may vary

The size of the cell will be fixed, but I don;t know who to ascertain that information or tell VBA what it is?

Sub InsertLogo()
Range("A1:E5").Select 'merged cell'
'Object.AutoSize = True
End Sub

I tried using the 'Object.AutoSize = True, but kept getting stumped on a run time error.

View Replies!   View Related
Insert Image Macro
I want to be able to click a button on my Excel Spreadsheet that will take me to my JPeg Photo location and allow me to add a JPeg Photo.

I have the below code but i does not recognise the JPeg File, so it work upto actually being able to select an image.

View Replies!   View Related
Copying Chart With Image On Top Of It
I have a workbook where there is one chart per worksheet.

The chart may start in a different cell depending on the worksheet.

Each chart has an image on top of it (small image in the corner).

I already know how to copy the chart to the clipboard using a visual basic script. I am getting the first chart object on the worksheet. Is there some way to copy the image and the chart together to clipboard? I assume that I need to somehow group the chart and image together before copying to clipboard. The image will always be on top of the chart but may not always be in the same position on top of the chart.

The reason why it may be good to group the chart and image together is because I want to preserve the location of the image with respect to the chart.

How would I do this via a visual basic script?

View Replies!   View Related
Embed Image In Cell
why there is no option for adding a picture manually to the comment of a cell? when editing a comment the Insert picture from file from the Insert menu is disabled ! (Office XP)

and can you please edit the code so the Width and Height of the comment box is set exactly to the dimensions of the picture? (that is how to get the exact width and height of the picture being inserted from code in excel ?)

View Replies!   View Related
Add Image To Cell Comment Box
I have a set of data with text in one cell and images in a cell adjacent the text to illustrate the text. I am trying to figure out how to add a comment to the cell containing the text and take the image in the adjacent cell and put it in the comment.

Is there a way to do this, or do I have to write a macro that saves the images as their own files and then insert the image files into the comment?

View Replies!   View Related
Insert Image With IF Statement
Is it possibe to insert an image (such as Picture1 which is the name of an image created by Insert>Name>Define) using an IF statement as in:


View Replies!   View Related
Looking For A Way To Hover Over Object And Have Image Appear
I don't know if this is possible or not but I am looking for a way to hover over a cell and have an image appear. If this is not possible is there a way to add something like a comment on the cell but have it be an image not text? Currently I have the cell hyper-linked to the image but it would be nice if I did not need a whole other window to pop up.

View Replies!   View Related
Image Link To Combobox
I have around 50 items in my combobox list where i would like to attach an image on each item and show up on the userform when a certain item is picked. Kindly assist on what code is best for this operation.

View Replies!   View Related
Saving An Image Of My Screen
I want to save an image of my worksheet, after I have right clicked, to be used in a power point presentation. How do I do that?

View Replies!   View Related
Pasting Cells As An Image
I Want to copy some part of an excel sheet and paste it exactly as an image on to another excel sheet.

View Replies!   View Related
Sheet Background Image As One
I'm trying to put the image in the background by doing 'Format - Sheet - Background'
but the image become tiles instead of one.

I want the image in the background so I can edit cells with formulas on top of the image. Is there any way of manupilate the background image with Macro so I can have just on image instead of tiles?

I've done watermark but that's only available in preview. I'm using Excel 2003

View Replies!   View Related
Image File Resize
i m sending image files via EMail attachment with VBA code. Though the images are 5Mb+ each and when sending 20+ on a 128k upload connection that takes a while. Is there a way that the images can be resized through vba and saved as a new folder. Or send the images to another program and pause the code until the resizing has been done.

View Replies!   View Related
Create Image Box On Form
Create image box on form. If

View Replies!   View Related
Editing Button Image With VBA
I'm designing a custom toolbar in VBA and have managed to create a toolbar with buttons.

However, I've been battling away trying to edit the buttons images so that I can design the button image to match the nature of macro assigned to it. The problem is that if you record yourself doing it, the macro written in VBA doesn't seem to recognise the editing button actions.

Does anyone out there know of a way to custom edit a button image in VBA?

View Replies!   View Related
Custom Image To A Commandbarpopup
I have learnt how to create a custom menu in Excel.


I have also managed to assign a custom image to a CommandBarButton.

What I can't figure out is how I can assign a custom image to a CommandBarPopup. (Not on the topmost level, but one level below... in the ozgrid example, this would be "Next menu".) There is no FaceId or PasteFace for CommandBarPopups.

View Replies!   View Related
Display Image As Thumbnail
Is there a way to insert a reference image thumbnail into my worksheet? I've tried inserting images/pictures directly, however these are duplicate copies of the originals from my system folder. C:/my documents/my pictures. I have about a hundred small images in this folder which are continually updated. (ie: the image changes) I would need this update to be reflected in excel as well.

View Replies!   View Related
Use Image From Library On Userform
Is it possible to use a VB library image and add it to a UserForm? i.e. I would like to use the vbInformation image used in a Msgbox.

View Replies!   View Related
Change An Image On Mouse Over
I have a UserForm with an Image on it that serves as a button. I need it to change to a second image when the mouse cursor goes over it. Is this possible?

View Replies!   View Related
Rotate Image On Userform
I am rotating an image on a userform by uploading different gif images to simulate the rotation. There is an annoying screen flicker around the image when changing images that I would like to get rid of if possible. how to get rid of the flicker or a different technique I could use to rotate an image? 1st attempt - uploading different pictures

For h = 1 To Sheets("Bar Contents"). Range("B" & ItemRow) Step 1
PictureLocation = ThisWorkbook.Path & "PicturesTransparent" & Sheets("Bar Contents").Range("C" & ItemRow) _
& " " & h & ".gif"
GameUserForm.DrinkAnimation.Picture = LoadPicture(PictureLocation)
Sleep 50
Next h.........................

View Replies!   View Related
All Image Files From Directory
I would like to list all the files I have in a directory. I know how to do this.

* * *

Now I would like to list just the image files such as PNG, JPG etc. I mean just the files I could get with: Application.Dialogs(xlDialogInsertPicture).Show

My Problem, I don't know what extension is "Todas las imagenes", "All the Images"
I mean the Extension I get When using: Application.Dialogs(xlDialogInsertPicture).Show

View Replies!   View Related
Inserted Image Not Showing
I am trying to insert an image into a worksheet with no avail. Whenever I choose INSERT/ PICTURE/ FROM FILE and select the file, it doesn't show up. I moved the entire sheet to another workbook and it all my attempts showed up there. What is stopping me from inserting a picture from file? Also, inserting AutoShapes is completely greyed out (disabled)...

View Replies!   View Related
Image In A User Form
I am trying to put an image on a user form for the first time and am unsure how to do this. Is there a way to cut and paste to the userform?

View Replies!   View Related
Display Image In Cell
I am trying to add a feature to an excel spreadsheet that will display image files (map files, .emf if possible), whenever its respective cell is clicked. I have a reasonable amount of experience with macros, although it was purely in excel which completely limits my vba skills. I could probably figure something out if I spent a few weeks on it and then it would probably be like 90 mb and slow.

View Replies!   View Related
Save Chart As Image
Is it possible to save a diagram (chart) as an gif image with vba? Save as web files is not an option as it generates folders and other files aswell, nor no plugins/third party. Standard vba only.

View Replies!   View Related
Mirror Image Or Flipping Cells
I have created a garden bed planting chart in excel. I made each cell a square where each cell will be equal to 1 square foot and simply typed in the plant name that will be planted in that spot. The planting beds will be on each side of a sidewalk. I want a mirror image of the layout for the opposite side of the sidewalk. How do I do this in excel?

View Replies!   View Related
Calling An Image Alt Text For Use In A Macro?
I'm hoping there is some way to call whatever text is stored in the "alt text" field of images placed in an excel sheet for use as a variable / string reference in a macro.

The "alt text" will not be changed in any way by the macro.

View Replies!   View Related
Picture In Cell Into Image Control
I need to move a picture in a cell on a work sheet to a user form image box. I have tried loadimage(range("I3") however it will not work

View Replies!   View Related
Field Contains The Full Pathname Of The Image
I work for emergency services, and one of my colleagues has a GPS camera that snaps digital pictures and collects the coordinates where the image was shot. These coordinates are recorded in a database file readable in Excel. The emergency mapping software can load these points along with the images, but in order for the hotlinks to work (and thus be able to click on a point and load the image), I need a field in the database file that shows the full path name of the respective JPG image. As it is, the database file has a field (named ORIGINAL) that records just the filename of the image.

I need a field that contains the full pathname of the image. This is easily done in Excel, but I need an external script that will run this outside of Excel because I need to streamline the process. If dispatchers need to go into Excel and edit columns to make the data show up, they're not likely to bother.

I have a blank (not populated) column in the dbf (named INTERNAL) that I can use for the full pathname. What I want to do is begin with the text "C:/" and insert the text in the ORIGINAL column immediately following this. Is there a script, such as in a batch file, that will run this outside of Excel?

View Replies!   View Related
Image Without A Source File On A Form
Is there a way to paste an image onto a user form in Excel instead of using the Image button on the tool box?

I am using Excel 2003 for this one.

View Replies!   View Related
Copyright 2005-08, All rights reserved