cmd

I have been working on some code to get Excel to retrieve every group that a user is a member of in AD. This will be for comparing users permission and I was looking to get the code onto an excel spreadsheet so I could sort the data. I have been successful using cmd to get the info into a txt...

Macro for executing commands from cmd prompt I need to run a batch from command prompt. It has exe file as well. My moto is to activate exe as schedule run. Below are the problem which I am facing due to which I need a macro to be created. Any of the resolution can solve my problem. This...

How do I open a .xml file as a "table" in excel from a batch file...I currently get it to start excel and open the file...but it prompts you to select how to open the xml file...I want it to open as a "table" every time?

Hey Guys, I`m using prompt control to create .txt files to use as data for a database in excel. I`ve come up with a VBA file that opens these .txt and import those infos to a sheet. I would like to eliminate the use of prompt and generate the same files thru VBA code. Also, I would like to...

i have batch file that run from VBAexcel But the thing is i dont want to run batch file i want everything on VBA . for example you use vba to cmd and then run this line of command i have try but i just new to VBA and programing :) how can i do it here the code this is from batch @echo off...

Hi Guys & Gals, i'm trying to use Excel VBA to create schedule tasks. I'm using a very simple macro to test it Sub Test() Shell (Selection.Value) End Sub The selection at the time is the commands for CMD SCHTASKS in one complete string SCHTASKS /S \\RemoteCompName /U MYDOMAIN\MYUSERNAME /P...

hello, i'd like to run a batch file in cygwin. my script is: Sub test() Shell "c:\cygwin\bin\bash /K c:\test.bat", vbNormalFocus End Sub but this doesn't work. the cygwin window opens then immediately closes without running the batch. (and no, i can't run test.bat in cmd.exe because it...