Internet shortcuts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Moss - 03 Nov 2006 19:11 GMT

I need to retrieve data from my Favorites folder using Access.
Using Scripting.FileSystemObject, I can get the names of files and
sub-folders, file sizes and dates.
But I can't get the Internet Shortcut, the value of one of the properties of
the files.
Obviously I need to use some other object.
Which one, please?

Reply to this Message

Douglas J. Steele - 03 Nov 2006 19:19 GMT

Take a look at my August 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access"

You can download the column (and sample database) for free from
http://www.accessmvp.com/DJSteele/SmartAccess.html

While you're there, you might want to grab the September 2005 column as
well.

(And while you didn't ask, I just thought I'd add that I don't see any
reason to use FSO to get any of the information you've described!)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I need to retrieve data from my Favorites folder using Access.
> Using Scripting.FileSystemObject, I can get the names of files and
[quoted text clipped - 4 lines]
> Obviously I need to use some other object.
> Which one, please?

Reply to this Message

David Moss - 03 Nov 2006 20:43 GMT

I am ... bouche bée, as they say in French. I submit a question. I go off to
make a sandwich. I come back. There's the answer. Of course. Everything works
like that. Mr Steele. Thank you.

> Take a look at my August 2005 "Access Answers" column in Pinnacle
> Publication's "Smart Access"
[quoted text clipped - 16 lines]
> > Obviously I need to use some other object.
> > Which one, please?

Reply to this Message

David Moss - 06 Nov 2006 00:09 GMT

New problem.
Internet shortcuts have a modified date, as well as a date created and a
date accessed. I need to be able to retrieve the modified date. I am assuming
that that is what is stored in the .URL file with key "Modified=". E.g., in
the example in your article:
[DEFAULT]
BASEURL=http://www.smartaccessnewsletter.com/ME2/Audiences/Default.asp
[InternetShortcut]
URL=http://www.smartaccessnewsletter.com/ME2/Audiences/Default.asp
Modified=B04FC6954E6BC501D9
the modified date is B04FC6954E6BC501D9 (to repeat, I am assuming).
How, please, do I convert that to a date?

In case you're interested in the reason, the internet shortcuts are the 947
(as it turns out, thanks to your program) references I cite in some research
I have been doing for the best part of four years. URLs change over the years
and it is good practice to quote the date you accessed the web page.
Normally, the date created would do. But I seem to have had to re-construct
my Favorites folder on 2 Feb 2005, because that is the earliest date created
I've got. The date modifieds go back much earlier. As an example, I think
908B79DFA411C401ED should translate into 24 March 2004 13:35. But how?

Reply to this Message