Download And Save Picture From Url Into Local File

Jan 28, 2010

I have a program operating in excel 2007 that extracts a picture from a URL and puts it into a PPT slide. I now discover that PPT 2007 doesn't allow this.

So my intent now is to download the jpg into a local file and then import into the PPT.

This is from a couple of sites:
[url]
[url]

At the top of the code:

Option Explicit

Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" _
(ByVal pCaller As Long, _
ByVal szURL As String, _
ByVal szFileName As String, _
ByVal dwReserved As Long, _
ByVal lpfnCB As Long) As Long

in the excel cell if a URL picture needs to be inserted it starts with the prefix "picture=" then the http address.

This did not work.

So I then copied the code from the websites into a module (changing the destination file and URL to mine of course) and called the procedure and still nothing.

View 7 Replies


ADVERTISEMENT

Open Website - Download CSV File / Save As In Specific Folder Under Different Name And File Type

Jul 6, 2012

I am trying to open a website, then for excel to download the csv file, then for it to save it in a specific folder under a specific name and file format (excel).

I am successful at opening the website with the following code, but how to do the rest.

Sub Searchez()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate "http://quote.morningstar.ca/Quicktakes/stock/keyratios.aspx?t=clwr®ion=USA&culture=en-CA&ops=clear" 'load web page google.com
IE.Visible = True
While IE.Busy
DoEvents
Wend

'IE.Navigate2 "javascript:SRT_keystuts.exportcsv()"
'this is the name of the download link as from when i hover my pointer over download link.
End Sub

View 1 Replies View Related

Download XLS File From Net And Save New Worksheet As Name

Oct 6, 2012

Ticker = "ABC"

I have made a url

[URL] ......

And try to open it

Workbooks.Open(url)

But I get the error

Object does not support this property or method

I am trying to download an xls file, copy the data to a worksheet with the name "ticker" and then close the xls download file

View 3 Replies View Related

VBA - Go To Website And Download File From Save Prompt

May 24, 2013

How to save a file onto the computer using VBA. The code template below that I found on another forum seems promising, except when I go to the desktop to access it, the .csv file has what looks like the page's source code instead of the actual file I want. This may be because when I go to the url, it doesn't automatically download the file; rather, I am asked to save the file to a certain location (since I don't know the path name of the uploaded file on the site).

Is there any way to alter this code to accommodate this, or will I have to use a different code entirely?

VB:
Sub Test()
Dim FileNum As Long
Dim FileData() As Byte
Dim MyFile As String
Dim WHTTP As Object

[Code] .....

View 9 Replies View Related

Download Zip File From Internet Explorer And Save It Into C Drive Using VBA Codes

May 21, 2014

How to download the zip file from internet explorer and save it into c: using VBA codes.

I have tried many codes from the internet but none of them are working. i am facing problem for the popup box. the macro which i have found was not supporting to it.

Please find the source data from my web page.

[Code] ....

View 3 Replies View Related

Save Range To Picture/Graphic File

Apr 14, 2008

I found thru this board's search function the solution to my original or saving excel range into a graphic file. {url} ...

View 6 Replies View Related

Insert Picture From File Increases File Size More Than The Picture You Inserting

Mar 17, 2009

I am putting together a price list in excel and using images and hyperlinks to jazz it up a bit - what I am finding is that if I insert a 25KB GIF image, the excel file grows in size by over 100KB

why is this disproportionate growth happening and is there a way around it - I dont want my Price List growing too large but need the images....?

View 9 Replies View Related

Macro To Download Csv File From A Dynamic Date Based Url To A File Location

Feb 23, 2014

I have a requirement to download a lot of historical data files from the archieve of an website. The url goes something like this: [URL]....

This downloads file for 21022014 ie. 21-Feb-2014. I need to be able to have a facility to have a selection criteria on my user form (in excel) where I specify a date range and the macro automatically downloads all the valid excel files available within that date range (files for Saturday, Sunday and some holiday dates will not be available in the website archive database) one after the other (like at single clcik of button) into a specific location (predefined viz.. c:/Users/EOD files/) on my laptop. Best would be if I am able to select the save location run time by using a 'Browse' like feature where I go and choose my local laptop folder...same type when we try uploading a file from our laptop to the web..

View 1 Replies View Related

Updating Local Excel File Through The Internet?

Apr 14, 2014

30 people in different countries use a sophisticated VBA Excel file on their local PCs, let's call it myexcelfile.xls. This file contains no custom data, as all data is stored in myexcelfile_backup.xls.

The biggest challenge with this set up is that whenever there is a newer release or bugfix of myexcelfile.xls, I need to send it out per email to 30 people and hope they replace it with my updated version.

Note that newer versions can replace older versions without any data loss, as all data is stored in the backup file.

Idea: with tools like WGET or BITSADMIN, I was thinking of creating a batch file, that would simply download the latest version from a FTP server, and replace the older version with the newly downloaded one.

Constraints: I shouldn't be using any software that is not native to Windows 7the files can sit in different folders on these 30 computers, therefore the update mechanism would have to identify the path they are in.the update mechanism would have to close the file first before running the update. Question: What is the best way to go about this? A DOS Batch file? Or another excel file that is just the "updater", meaning, it's only purpose is to download the new file from the web and overwrite the old file?

View 1 Replies View Related

Open URL Or Local Html File With Command Button?

Jan 16, 2010

What is the code to open a URL or local html file with a command button?

View 4 Replies View Related

Send A File By Email Versus To A Local Desktop

Jul 13, 2007


Case "TD"
strfilename = "\TomsblackibmTomsProposals" & strfilename

I would like to send this file by email if possible instead of to his computer. The user recently went from a desktop "in the office" to a laptop "all over the place".

Sub Save_and_SaveSalesman()


Dim strPath As String, strPath2 As String, CurrPath As String

Dim WB1 As Workbook
Dim WB2 As Workbook

Set WB1 = ActiveWorkbook

'First thing, save my work
WB1.Save

CurrPath = WB1.Path

'ASSUMING THAT C6 and O3 are BOTH in WB1
'move this line HERE: only do this once, and concatenate in the Select..Case later
'doing thsi inside the Select..Case pulls values from WB2, which might cause errors.............................

View 9 Replies View Related

Dynamic Hyperlink To File Names Found On Local Drive?

Mar 31, 2014

I want to list file names from a directory and sub directories and hyperlink them. I have been able to list the file names onto an excel sheet, but I cannot get it to hyperlink to the file.

'Force the explicit delcaration of variables
Option Explicit
Sub ListFiles()

[Code]....

View 1 Replies View Related

Download File From Web Using VBA?

Nov 12, 2008

I have been working on automating IE. Part of my task involves using explorer to download a file from a given url and save it to disk. I've figured out how to launch explorer and start the download, but then a dialogue box appears asking whether to save the file and where to save it. how do I automatically get past this and save the file to e.g "quotes.xls"?

View 7 Replies View Related

FTP File Download With Loop?

Jun 2, 2014

I have the following code that I want to download everyfile at the listed ftp site to a folder on my computer. I was thinking about trying to make a key with dates in thisworkbook sheet1 starting in cell A1 and have it loop through.

Code:
Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long

[Code].....

View 1 Replies View Related

Download Zip File Form Website Using VBA?

Jul 7, 2009

how can i use VBA tp download a file from a webpage? I've found the following that would display the source code of a webpage. I need to download a zip file and save it to the desktop.What alterations do I have to make?

Code:

Sub Downloadfile()
Dim objHttp As Object
Set objHttp = CreateObject("MSXML2.ServerXMLHTTP")
Call objHttp.Open("GET", "http:\yahoo.com", False)
Call objHttp.Send("")
Call MsgBox(objHttp.ResponseText)
End Sub

View 9 Replies View Related

Download A .txt File And Don't Lose The Formatting?

Aug 8, 2006

How can I download a .TXT file and don't lose the formatting?
I found an example:

Option Explicit
Private Declare Function InternetGetConnectedState Lib "wininet" ( _
ByRef lpdwFlags As Long, _
ByVal dwReserved As Long) As Long

Private Declare Function InternetAutodial Lib "wininet.dll" ( _
ByVal dwFlags As Long, _
ByVal dwReserved As Long) As Long

Private Declare Function InternetAutodialHangup Lib "wininet.dll" ( _
ByVal dwReserved As Long) As Long..........................

View 4 Replies View Related

Download Images From URLs In Excel File?

May 12, 2014

I have an excel file which contains 9 columns. Column A contains an article number i.e 12345 . Column B contains name of the product. Columns C and D contain Description and Specifications respectively. Columns E,F,G,H and I contain URL:s of images.

I want to do following.

1. Download all the images in a folder on my harddisk.

2. Copy the text in column C and place it under the text in column D.

note that I am a novice at excel and have never used macros/Javascript/VBA/etc

View 2 Replies View Related

File Download Without Knowing The Full Url (only Indirect Url Available)

Aug 13, 2008

have a link such as www.abc.se/downloadfile?file=12345. When opening this link in a browser the DownloadFile window popups and the file can be downloaded.

I would like to be able to download the file without involving the DownloadFile pop up (since some users have auto open enabled thus the downloadfile pop-up is not always shown)

I have tried URLDownloadToCacheFile and similiar methods but they fail as they dont have the direct link to the file.

So my question now is how can I extract the direct url?

There should be a way to capture it since it will be used in the downloadfile dialog.

View 9 Replies View Related

Automatically Control File Download Dialog

Jun 29, 2006

complete the attached code (Excel VBA) to automatically process a File Download dialog from Internet Explorer. I want to click "Save" which will produce the "Save As" dialog. Then I need to enter a default filename like (C:Temp) and click "Save" again. When this is working, I will hide Internet Explorer to make the operation completely transparent to the user. The URL is a sample chosen specifically for this test case.

Public Sub Report_Test()

Dim objIE As SHDocVw.InternetExplorer
Dim strURL As String
Dim varItem As Variant

' Establish connection to the Internet Explorer application.
Set objIE = CreateObject("InternetExplorer.Application")

' Set Internet Explorer visible.
objIE.Visible = True

View 3 Replies View Related

VBA - Download Excel File From Internet And Then Extract Data Out Of It

Dec 20, 2012

I'm trying to download an Excel file from the internet and then extract data out of it. The problem is that I don't get any errors, yet the file downloaded is only 1kb in size. The extraction bit works, but the file is empty. The actual file is size 350KB.

Code:
Sub ExtractDataTest()

Dim FileNum As Long
Dim FileData() As Byte
Dim MyFile As String
Dim WHTTP As Object

On Error Resume Next

[Code] ....

View 1 Replies View Related

VBA - Get / Download Excel File From Server And Copy Contents Into New Worksheet

Dec 20, 2012

For some reason the following Macro won't work:

Code:
Sub ExtractDataTest()
Dim FilePath$, Row&, Column&, Address$
'change constants & FilePath below to suit
'***************************************
Const FileName$ = "Dxo.xlsx"
Const SheetName$ = "Open"

[Code] .......

I get a run-time error '52' on line ("Bad file name or number"):

Code:
If Dir(FilePath & FileName) = Empty Then

And when location is 'C:' it works and I don't get an error.

View 2 Replies View Related

Export And Save Worksheet As A Picture

Jan 31, 2010

Is there a way to export and save the contents and table layout of a worksheet as a picture ( say jpeg )?

Basically what I would love to do is that when I save the workbook, a certain worksheet named " Fax " is saved to my desktop as a picture (as a snapshot). What would even be better is that the said file was named with simply the date !

The purpose of this is so I can email it to a very non computer guy who thinks that excel is only a gum . . .

I know this is weird but you guys are the best, you helped me a lot to make my spreadsheet.

View 14 Replies View Related

Image Picture Resize And Save As On Different Location?

Aug 21, 2014

I have a picture on my image at userform. And I want to change my picture size ( like attached picture: fast image resizer program ) and save as different location. It is my school project.

Your valuable macro codes about ıf this and attached workbooks are very important for me.

View 3 Replies View Related

Save Excel File As Another File Using Current Date As Part Of File Name

Oct 10, 2011

VBA coding for automatically saving an excel file as another file using the current date as part of the file name together with "32ga" as a constant add-in. I also what this macro to run at a particular time of the day let say 00:20hrs. The excel file i want to save as is always open . It has data that changes every 24-hrs.

View 1 Replies View Related

Excel 2010 :: Save Open Worksheet To File And Include Date Of Save?

Mar 11, 2014

am using Excel 2010 and having issues trying to save a worksheet to a specified file location with the save date....

I have tried several posts form this forum and elsewhere and can't seem to get the macro to do what I want.....

I want to save a 'worksheet' from an open workbook that I use for updating information to the same file path as the workbook with the date the file saved...

View 6 Replies View Related

Excel Save As Should Default File Save Type To XLSX Using VBA

Aug 21, 2012

What I am trying to do is that I have an excel file with macros and it is a read-only file. In order for the user to save, I want them to only be able to save as a .xlsx file as it disables all macros. If for whatever reason, the user wants to save the file as another .xlsm file, they should be allowed but before they save, a "are you sure you want to save as .xlsm?" message should pop up.

All the options in the save as box should still be available in case they want to save in that particular format. Just that the .xlsx should be the default.

View 2 Replies View Related

Using VBA To Paste Picture Over JPG File

Nov 2, 2013

Using VBA, is it possible to paste a picture at a given location over a jpg picture file?

View 3 Replies View Related

Save As Macro :: Save File To Folder

Jan 17, 2010

I have a macro that copy one sheet of the Active workbook and sends it via email.

I need to add a code in this sheet so when one opens it from the email, with a command button to be able to save the file to specific, fixed folder on the local network with its original file name.

View 10 Replies View Related

How To Show Picture From Another File Directly

Jul 2, 2013

I have an excel file with about 200 images! This increases the filesize too much. So, I want to (if possible) have all the 200 images in different files, but still show all the pictures directly in Excel like before, without having the directly imported into excel. So, easy explained: I want to show a picture directly in excel that is in another file without having the picture increasing the filesize as before! How can i do this??

View 6 Replies View Related

Insert A Picture In The Word File?

Oct 7, 2009

I had copied a macro from this forum [it was posted by either shg or NBVC], and I modified it to fit my needs. The macro creates a new word document and sends a series of cells from an excel worksheet column to this word file. Everything works fine, but now I need to insert a picture after row 14. I have inserted the code [colored red], but I am sure the syntax or something isn't right. That part doesn't work.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved