Solved

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

Posted on 2008-10-14
8
418 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
  • 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
 

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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

919 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now