Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

MORE ON VBA

Hi, VBA (Visual Basic for Applicationns.) Ok.... heres where i stand. I have a program written in vb, that i need to be loaded by some VBA code. The 'Shell' command doesn't appear to work. Does anyone know how to make a VB program load,with a code in VBA? Please have a brainstorm for me a.s.a.p! Thanks!
0
beauvoir2
Asked:
beauvoir2
1 Solution
 
aelatikCommented:
Shell has to work, show your code :

Try :

Shell "notepad.exe"

and see what happens...
0
 
beauvoir2Author Commented:
Shell works in VB, but it doesnt seem to work in VBA. Ill try it again!
0
 
beauvoir2Author Commented:
Nope.... Shell definately doesnt work! Please try and come up with an alternative command! Thanks
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
nschulz777Commented:
I had a help file written once in powerpoint which I called from msaccess with this function, worked for me, PPPath was the Powerpoint .exe path, hlppath was the .pps file path, the sendkeys commands started the slideshow:
Function PPHelp()
Dim PPPath As String
Dim HlpPath As String
Dim strfile As String
PPPath = Forms![Job Setup]!PowerPointPath
HlpPath = Forms![Job Setup]!HelpPath
strfile = PPPath & Chr(32) & Chr(34) & HlpPath & Chr(34)
Dim RetVal
RetVal = Shell(strfile, 1)
SendKeys "%{e}", True
SendKeys "%{d}", True
SendKeys "v", True
End Function
0
 
RhaedesCommented:
Shell DOES work from VBA. I have a VBA program in Word 2000 which makes great use of it. What Office application/version are you using?
0
 
beauvoir2Author Commented:
Im using Office XP, and Access, but for some reason it Doesn't wanna work :'(
0
 
RhaedesCommented:
Please post your code!
0
 
beauvoir2Author Commented:
I dont have any code, which is my problem.... all i need is to no how to loada a prog
0
 
beauvoir2Author Commented:
Hang on... i think ive sussed it!
0
 
CleanupPingCommented:
Hi beauvoir2,
This old question (QID 20565637) needs to be finalized -- accept an answer, split points, or get a refund.  Please see http://www.cityofangels.com/Experts/Closing.htm for information and options.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now