ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Saving a Favorite from code (https://www.excelbanter.com/excel-programming/290457-saving-favorite-code.html)

Miguel Velez

Saving a Favorite from code
 
I'm writing a macro which needs to do various things. One
of them is to same a "Favorite" to a particular link. The
link goes something like this:

"http://serverid.domain.area.net:7781/forms90/f90servlet?
config=bfoc&form=issz003.fmx"

Does anyone know if this can be done using VBA in Excel?
If so, how?

Any help will be greatly appreciated.


Miguel

Colo[_91_]

Saving a Favorite from code
 
Hello Miguel,

Does the word "Favorite" mean the "Favorite" of ie?
If so, it can be done with WHS(Windows Script Host) an
FSO(FileSystemObject).
You can get "Favorite" folder something like this.

Code
-------------------

Dim WSH As New WshShell
GetFavorites = WSH.SpecialFolders("Favorites")

-------------------


--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 08:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com