I hope I have joined the correct forum.
I am trying to do a simple thing within the vba component of Microsoft
Access, that is use the Visual Basic ShellEcecute command to add a vCal
event to a Palm Desktop Calendar.
I can import a .vcs file into Palm Desktop by using the file / import
command.
But, when I double click on the .vcs icon in windows explorer I got some
error messages unitl I made the following changes.
I went into the registry and found the following information.
HKEY_CLASSES_ROOT\vcsfile
Edit Flags: 0000 00 00 01 00 ......
HKEY_CLASSES_ROOT\vcsfile\DefaultIcon =
C:\PROGRA~1\MICROS~1\OFFICE\1033\OUTLLIBR.DLL,44
HKEY_CLASSES_ROOT\vcsfile\shell
HKEY_CLASSES_ROOT\vcsfile\shell\open
The open command has some path to MS outlook, so I changed it to the
following, but it made no diffeence
HKEY_CLASSES_ROOT\vcsfile\shell\open\command "C:\Program Files\Sony
Handheld\Palm.exe" /vcal "%1"
Then under MyComputer / properties
Under Folder Options, Registered File types "vCalDocument"
Content Type {MIME}: text/plain
default Exctention for Content Type: .txt
Actions: Open
The action open Application used to perform action, Had something very
similar to the following string. It may have been without the qoutes.
"C:\Program Files\Sony Handheld\palm.exe" "%1"
Never the less, I browsed for it and added the %1.
In addition "Use DDE" is checked
DDE Message is [Open{"%1"}]
After doing this double clicking on open from windows explorer would open
Sony Desktop and add the vCal event after asking for comfirmation that I
wish to add the event.
Using Visual Basic, I executed the following command:
ShellExecute(vbNull, "Open, Path & vcs file , "", "", SW_SHOWNORMAL)
shell error #8: There was not enough memory to complete this operation.
as a check, I re-named the .vcs file .txt and ran the ShellExecute command
again. It opened in Notepad
Clearly, I am almost there, can you supply me with the missing pieces of the
puzzle to enable ShellEcecute to preform the same function as when I double
click on the Icon?
Many thanks
Richard Friedman
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/support/forums/
