If you want I can post the workbook.
Do not know if info is private let me know and I'll post it.
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
I found what you meant by Tools -> Reference -> Microsoft Html Lib..
Code seems ok, but it is not working. I have in module1 some other code. Maybe that's what is making all the trouble.
EDIT:
I uploaded the new workbook so you can see it. Columns are all the same.
Hi,
The attached is what I came up with. It, however does not contain the Function code supplied on this forum. I modified my original code.
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
I get an error display #1004.
Error in the method of paste special of the class range. (I translated this from spanish to english.)
Hi,
Where does the debug show for the error?
Which workbook did you test the code with? The one I supplied or the one you posted on the forum?
Sorry you did say rror was for the Paste.
Still which workbook did you use
Last edited by Charles; 01-30-2011 at 03:33 PM. Reason: update remark
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
For a working example look here.
Re: Visit Site Address Macro
Dear Charles, and everyone else viewing this thread,
I have finally integrated the code that you sent me with that worksheet. It is working perfectly!!! This thread is solved.
However I am missing to add the button you had in the previous worksheet you sent me.
This is my final post. I have attached the final worksheet (it just missing the "Url" button.
Many thanks.
Last edited by Drus; 01-30-2011 at 03:56 PM. Reason: added attachment
Thanks for letting us know that your project is done, you can add the button and attach it to the code.
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
Sorry I don't know how to create a button in excel.
I would appreciate you explained it to me, rather than sending me the worksheet with it. So I can learn for future projects.
Hi,
If you are using 2007 click the "Developer Tab"
Click "Design Mode"
Click "Insert"
You will see a drop down
You will also see in the header for the dropdown "Form Control"
Click on the "Button" which is the top left button in the Form Control
Now on you worksheet you can click any place that you want and a button will appear and when it does it will show a display box for you to assign the button too. Select the Macro and then click Ok. You should now be able to run the macro from that button.
Also deselect The Design Mode, you really do not need to select it.
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
I see. I will try to do as you say.
I found 2 things:
The macro actually works,
I believe I may have missplaced in the macro code the location of the output cell which it is only copying "http://services.runescape.com/m=avatar-rs//chat.gif " from a cell, therefore the url returned is not the correct one.
Maybe you could look at it.
Also I have an observation, the loop of the macro will make it run until it finds a cell with no "display name" content?
All issues have been solved. Thanks to Charles and everyone else who helped me.
One final attachment 100% functional at your disposal. Thread will be marked as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks