Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

I want to Open a short cut  on my desktop using VBA or MS Access

Posted on 2008-10-14
8
Medium Priority
?
489 Views
Last Modified: 2013-11-28
Dim a as Object
Dim str as string
Dim Target  As string
Dim Startin  AS string


Target = "C:\Program Files\Sage Software\V420JO\MAS90\Home\pvxwin32.exe" -hd ..\launcher\sota.ini ..\soa\startup.m4p -arg direct uion vbc "" JOB jt_timetrackerlaborimport_ui AUTO

Startin ="C:\Program Files\Sage Software\V420JO\MAS90\Home"
str = Target &  Startin
a = SHELL(str,vbNormalFocus)

0
Comment
Question by:daruffin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
8 Comments
 
LVL 12

Expert Comment

by:jazzIIIlove
ID: 22715277
0
 

Author Comment

by:daruffin
ID: 22715444
This only tells me how to create a short cut I need to open a short cut using the shell command. I want to click a button on my MS Access form and open this short cut which is located on my desktop.
0
 
LVL 12

Expert Comment

by:jazzIIIlove
ID: 22715470
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:daruffin
ID: 22715649
You keep sending me how to create a short cut. I want to run my shortcut which is already created on my desktop and This shortcut run another program. How can I run this short using the Shell command
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 1000 total points
ID: 22728605
daruffin,

Is your question simply: How to Open a Shortcut?
Or more specifically:  How to Open a Shortcut using the Shell command?

Because you can open a shortcut quite easily by treating it as a Hyperlink
Try something like this:

Application.FollowHyperlink "C:\Documents and Settings\user\Desktop\NameOfYourShortCut.lnk"

(If you get a hyperlink warning, you can disable it for good by seeing this link: http://support.microsoft.com/kb/829072/en-us)

JeffCoachman

0
 

Author Comment

by:daruffin
ID: 22734904
Let me try this and I will get back to you
0
 

Author Closing Comment

by:daruffin
ID: 31506047
This worked out well
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22771587
;-)
0

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question