Hi,
I have a link address in a cell: http://finance.yahoo.com/d/quotes.cs...OG+YHOO&f=snd1
I would like to use VBA/Macros to help do the following automatically:
-Copy and paste this link to an internet browser, eg. Firefox and let browser direct to this address
-After pasting and clicking Enter, the browser will display a dialog box to ask if we need to open a file with Excel
-Click Yes to open with Excel
-Always save into existing workbook
I do not know VBA at all. Please help.
Thanks a lot.
Re: Copy link to a browser and export a file
Hi,
no need browser ‼ You can directly open the URL file in Excel just by using Workbooks.Open method for example,
just see in VBA inner help, beginner level …
Or just activate Macro recorder, open the URL file, copy / paste data : you will have a free code !
Hi Marc,
Only the browser can generate the Excel file I need. I have tried to insert hyperlink with the URL address but it has produced some codes I don't understand.
Regards,
Working on my side without browser !
But you can also do a search and learn how to pilot a browser …
Quite simply:
How to install your new code
Please Login or Register to view this content.
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Very understandable advice.
But it appears with run-time error "1004" when running and requires debug on "With Workbooks.Open(ActiveCell.Value2)"
How to solve it please?
You need to select the cell with the lin in first
I finally got it. Thanks a lot.
One more question: How do I change the codes to save into a designated file?
Hi, tywlam
.. This is a good example of how you can easily get what you want From a Macro Recording.Originally Posted by tywlam
. I have no idea what exactly this Thread is about, but I simply ran Kyle’s code in debug mode ( In Development Window selected code and steped through with F8 and then stopped running the macro( Hit stop small square stop button above in the development Window Ribbon ( symbol Bar ) ) after the first line before it did the
.Save
. I then ran a macro recording while I did a save As manually where I saved in the place I wanted the File to be saved. Then I stopped the macro recorder (Small square button bottom left of the worksheet in the Bottom Spreadsheet Ribbon ( Status Bar ) , or view >> Macros >> Stop Recording )
. I got this code:
…..Please Login or Register to view this content.
So I modified Kyle’s code so..
Please Login or Register to view this content.
. Then ( after deleting the file created – I found a Folder called tywlamStuff-Dateien and an Chrome HTML Document called tywlamStuff in my Folder on a OSB Stick with this Path F:\ExcelForum\Hyperlinks\ ) I ran the program. I did it in debug Mode again so as to see wjere, ( if ) anything went wrong. Nothing did go wrong, and i got the Two thing again in the desired Folder.
. This particular example is also a good example of when a macro recording is very useful, even to experienced users. The particular Arguments which are often not optional when saving files are so many that no one bothers to remember them all.
Alan
P.s. 1 ) If this Thread is solved for you, then please mark it as solved
P.s.2 ) When you follow on a request, as you have done here
http://www.excelforum.com/excel-prog...ro-button.html
.. then please reference this link
http://www.excelforum.com/excel-prog...rt-a-file.html
.. as that may help someone getting started with helping you.
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks