KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
When I go to my batch file's location and open it, the batch file works. My batch file is simply: cd .\data dir/b/o:n > names.txt As you can see, I'm in my current directory and moving down to the sub directory "data" and coping all the names and creating a file called names.txt . When I say shell "location of file" it opens the batch file, but the directory that is defaulted to is C:\my documents , so my commands won't work because it cannot find the sub directory. I want this to be a dynamic batch file, and therefore i need to write something in VBA that will open the batch file under its current directory or something to this effect. How do I do this?
Tags (comma-separated)
Save Edits
Cancel