How can write the shell function for the dir command?

G

giannis

Suppose we want the dir command* for the directory:

c:\my mp3 files\

and suppose that "path" is a string variable that:

path="c:\my mp3 files\"

How can write the shell function for the dir** command
with this variable ?

* at the Start->Run the dir command is :
command.com /c dir "c:\my mp3 files"

**I dont want the dir() function of access
i want the Shell function !!!
 
V

Van T. Dinh

(Newsgroups trimmed. Please restrict to *relevant* newsgroups only)

Shell "command.com /K dir ""C:\Program Files""",vbMaximizedFocus

or

MyPath$="C:\Program Files"
Shell "command.com /K dir " & MyPath,vbMaximizedFocus

I change to /K flag as /C will execute and then disappear straight away.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Dir() not working in MS Word 2016 in MAC system 0
The dir command in the Shell() function for long names folders 2
VBA - exporting serial letters to single documents 0
Shell command produces a "Run-time error '5': Invalid procedure call or argumen 0
Incorporating the User Profile location into a document template path 1
api 2
Can the below code be modified for select. Drive Letter, Dir. 2

Top