excel vba wait for shell command to complete

So I'm running a simple shell command in Excel VBA that runs a batch file in a specified directory like below: Dim strBatchName As String strBatchName = "C:\folder\runbat.bat" Shell strBatchName But the issue is sometimes the batch file might take longer on some computer to run, and there are proceeding VBA code that is dependent on the b...

Emacs Python-inferior shell not showing prompt after matplotlib show() command

So I've been experimenting with numpy and matplotlib and have stumbled across some bug when running python from the emacs inferior shell. When I send the py file to the shell interpreter I can run commands after the code executed. The command prompt "> " appears fine. However, after I invoke a matplotlib show command on a plot the shell j...

How to connect to existing instance of Excel from PowerShell?

All examples that automate Excel through PowerShell start with this line: PS> $Excel = New-Object -Com Excel.Application This seems to be handling a new instance of Excel, e.g. running $Excel.Visiable = $true will show an empty, blank Excel window, not switch to the existing workbook. If there is already an instance of Excel running,...

gnome-shell cpu usage is too high

especially when playing videos, mplayer & gnome-shell kick it up to 40% and the video itself is not high res video, medium res xvid/divx files. Running latest nvidia drivers on fedora 18 PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1135 xxxx 20 0 697m 258m 57m S 29.5 6.5 56:36.66 gnome-shell 26436 xxxx 20 0 204m 46m 10m S 10.3...

Old Japanese Man Creates Amazing Art Using Excel (Wait, Excel?)

Microsoft Excel isn't only for spreadsheets. It can also be used to create art. Don't believe me? Just ask 73 year-old Tatsuo Horiuchi. He'll tell ya. Read more...

Translating shell script into Windows command shell script (batch)

I have a shell script which makes directories week_01 to week_09 using a for loop and one another directory called week_10 . I want to translate this shell script into Windows commands using two lines of code? Shell Script: #!/bin/bash for (( Y=1;Y<=9;Y++)) mkdir week_0$Y done mkdir week_10...

Excel 2010 Complete Tutorial for Android

HK.Collection Microsoft Excel 2010 Complete Tutorial With this Tutorial, you have 4 Apps in one. ============= All in One Package Contents : 1) Excel 2010 Learn-Basic. [You can download it separately from link bellow]... $2.44

mysqladmin to set initial root password fails in script but works in shell

I am trying to do this as part of a startup script (that runs as root) on an EC2 instance # mysqladmin -u root password mygreatnewpassword To debug this I echoed the entire command to the log and it's correct. I did a 'ps ax' before the command in the script to be sure mysql was running. I tried it with double and single quotes around the...

Tornado shell command to find current system date in vxworks 5.5

I am using tornado 2.2 in Vxworks PPC board for running my C program. What is the Tornado shell command to get current sytem time. Google is not giving any answer for it, its only giving details about C system call to find system date.

Fatal Error While Running Artisan (Laravel) on Command Line

I am experiencing a fatal error while using artisan on the (fantastic) Laravel PHP framework. I recently downloaded v3.2.1 of Laravel, and I tried running the following command line from within the directory that artisan resides: php artisan key:generate This should create a random key for me in my applications/application.php file. (Plea...

How to create a Ruby executable using ocra or rubyscript2exe gems but including needed Excel files?

I have a dozen of selenium webdriver scripts written in Ruby and I have used both rubyscript2exe and ocra gems in an attempt to end up with a 'bundled' executable but to no avail. Problem is, my scripts are grabbing test data from Excel files; and this is causing havoc when trying to create the executable. It works fine on the machine whi...

Plink error - "unix shell commands cannot be executed using this account"

I'm trying to run plink.exe to execute a command on a remote UNIX machine. When logging in using Putty, my command is executed successfully. My problem is when using the same credentials (same user and password) to execute the same command exactly with plink. I keep getting a message "UNIX shell commands cannot be executed using this acc...

Error Using a Makefile For a Linux Shell Written in C

I created a Linux shell for one of my classes written in C. The shell works perfectly running such commands as ls, pwd, ps, top, cd, etc. However, using a MakeFile (because that is part of the submission process), when the you use the command "make test" in Terminal I get the error tcsetpgrp: Inappropriate ioctl for device" amongst all of...

using ulimit for current shell

I want to increase the hard limit of maxfiles using ulimit -Hn for the current bash shell. The problem is I can not do it without using sudo. But, when I do sudo ulimit -Hn unlimited, it does not effect the current shell's limits. Is there a way to achieve it for the current shell from with we are issuing the ulimit command? I am using Ma...

Python calling shell commands. What type of shell is started?

I have the following python function that allows me to run shell commands from within a python script: import subprocess def run_shell_command(cmd,cwd=None): retVal = subprocess.Popen(cmd, shell=True, stdout=subprocess.PIPE, cwd=cwd); retVal = retVal.stdout.read().strip('\n'); return(retVal); This allows me to do thing...

Stop Excel 2010 from appending .txt to file with existing extension

I think this problem may have to do with Windows 7 vs Windows XP. With Excel 2010 running under XP this does not happen. Under Win 7 running Excel 2010, when saving a spreadsheet as a tab delimited text file (.txt). Excel 2010 appends the .txt file extension to a file that already has an existing file extension. For my work I must save ex...

Multiple context menu run as administrator through registry editor

I am trying to create two context menus for .EXE files in Windows 8, both of which will need admin privileges. As I can see in registry, HKEY_CLASSES_ROOT\exefile\shell\runas can only have one command and it is being used by the "Run as administrator" context menu. Right now, I am using this code in a .reg file: [HKEY_CLASSES_ROOT\exefile...

Spawn inside spawn nodejs

I'm new on nodejs, and here is my question. A bit of background: I have two commands I run on my shell. The first one will set some env variables and log me into a new shell. For example: $ cmdpk giveMeShell Will give me a new shell, Then: $ cmdpk execThis Will execute inside that new given shell. If I execute cmdpk execThis without firs...

Passing shell commands with Python os.system() or subprocess.check_call()

I'm trying to call 'sed' from Python and having troubles passing the command line via either subprocess.check_call() or os.system(). I'm on Windows 7, but using the 'sed' from Cygwin (it's in the path). If I do this from the Cygwin shell, it works fine: $ sed 's/&amp;nbsp;/\&nbsp;/g' <"C:foobar" >"C:foobar.temp" In Python, I...

Excel Unlocker - 2.0

Excel Unlocker software helps to extract Excel password and reveal Excel workbook password. Enstella Excel Password unlocker tool easy to crack excel open password and Excel Sheet password. Unlock Excel tool supports Excel 2010/2007/2003/XP/2000/97.

GNU Parallel 20120822 ('Boson')

GNU parallel is a shell tool for executing jobs in parallel locally or using remote computers. A job is typically a single command or a small script that has to be run for each of the lines in the input. The typical input is a list of files, a list of hosts, a list of users, a list of URLs, or a list of tables. If you use xargs today you...

Shell Game Machine

Despite it’s simplicity, we’ve always enjoyed the old shell game trick. Here, an handmade automaton manages to mess with our heads as it performs the familiar trick whenever its crank is turned. Hat Tip More Awesome Stuff for You to Click On: Marcel the Shell Two Marcel the Shell Biggest Fireworks Shell Ever Ferrari x Shell: 6...

How to make data logger using Borland C++ Builder and Excel

Hi, I'm an electronic engineering student want to ask about the programming code using BCB and Excel, please someone help me because, i must complete my final year project using this software, tq...

Digital Microsoft Excel Courses, Nationwide

Expert Microsoft Excel Training with 32 Business-Focused Units – From $29 for an Online Course to Complete at your Leisure with Final Certificate, with Options for Additional Courses to Train the Whole Office (From $308 Value) Microsoft Excel Online Course Five Microsoft Excel Online Courses Ten Microsoft Excel Onli...

Why do calls to the subprocess modele in Python under Windows change the working directory?

I'm running Python 2.7.3 under windows (installed the binary from python.org). When running in the cmd shell or under MinGW msys, I see odd behavior. If I make a subprocess call with shell=False, the current working directory is maintained. If I set shell=True, the cwd is set to the root of my c: drive. This seems wrong. >>> impo...

Importing data into Excel using XML and Excel Templates

I am generating CSV data from a C# application. This can be imported into Excel easily but I need formatting applied to the file. One option is interop but the machine running this application will not have Office products installed so that is out. I've been told that XML can work with Excel templates and am looking for a starter example...

Opening a winform from an IronPython shell without blocking the shell or the form

I'm starting a winform from an IronPython shell. My form is then calling a script which runs for some hours and writes output to the shell. While the script is running, the GUI is blocked (I cannot hit any buttons or minimize it). I tried these approaches: When I open the form with ShowDialog(), the form stays in front. I cannot put the p...

Correct incantation of subprocess with shell=True to get output and not hang

Inside a a subprocess call, I want to use shell=True so that it does on globbing pathnames (code below), however this has the annoying side-effect of making subprocess spawn a child process (which must then be `communicate()d/ poll()ed/ wait()ed/ terminate()d/ kill()ed/ whatevah Yes I am aware the globbing can also be done with fnmat...

SCP command line and PHP exec() not doing the same thing

When I run this on the command line: scp -i private.ppk -P 22 foo.txt someuser@domain.com:/home/someuser/foo.t xt Everything works fine. foo.txt gets transferred to the remote server without any problems. I need to run the exact same command from PHP. So, I have the following code: $command = 'scp -i private.ppk -P 22 foo.txt someuser@dom...

Why CTRL+C won't work when using RS-232 on Linux?

First of all, I don't know if this should stay in SO or go to SU: you tell me. The solution might have to do with programming. I am executing Linux on an embedded device and communicating with it using RS-232 @ 9600 bauds. Everything works fine using PuTTY on Windows: I have a shell and can type and execute commands. The problem is: when...

Create a macro to copy from a cell in excel to a text box in a browser, then click add

I have already created a Macro using a 3rd party application that does what i want 80% of the time. The problem is that i can't leave it running because it sometimes bugs out, or the browser takes a little longer to respond. I would like to know if i could create what i wanted in the macro manager that comes with excel (VB). I want to: co...

JNA: get all windows processes command line

Looking for a way by using JNA to get a list of all currently running windows programs and their command lines. There are a few tutorials on this site ( Get list of processes on Windows in a charset-safe way ) which show how to get a list of running program names but I'm looking for the full command line. I've seen posts mention the use o...

Python code to send command through command line

final="cacls " + "E:/" + "\"" + list1[2] + " " + list1[3] + "\"" + " /p " + str os.system(final) I am trying to set permission to a folder Using Python but while running this command , User input needs to be provided too i.e it asks ARE YOU SURE(Y/N) and the user needs to enter "Y" or "N" Is there any way to use python to send the user...

C# Proper Way to Close Multiple Excel Objects With Excel Process Destroyed

I have a C# console program. When it runs, it instantiates some Excel objects such as: (openExcelO). When the program is done running, I have a method to close down Excel (closeExcel) and that is supposed to properly clean up the Excel process. In task manager I can see the remnants of Excel that remain. The shut down routines were cobble...

Can I toggle folders-panel (visible/hidden)?

*Is there a command to hide-show the navigation pane in Windows Explorer ?* Win7 default 3xclicks for on and 3xclicks off - is not particularly slick, compared to WinXP. ie, Organize > Layout > Navigation Pane I use "Classic Shell" and I can run a script file from a custom-command control on WinExp in the Classic Shell toolbar. * Q:1 Is...

Excel 2010 Automation issue

Guys, I am attempting to create a new instance of Excel from Access (also 2010) I have a reference set to "Microsoft Excel 14.0 Object Library" in my project. I am using the following lines to open a new instance of excel: Code: Dim oXL As Excel.Application Set oXL = New Excel.Application Excel never opens, I just get an error that the e...

VB.net text -> Excel conversion (with extensive formatting required after conversion)

I'm creating a program in VB.net that does the following: At a high level I receive a file in email, put the attachment in a monitored folder, import the text file to excel, format the excel, and then email the excel file to a list of recipients. Here is my plan: Completed: Outlook VBA to monitor all incoming email for specific message. O...

Работа с Excel - C# для начинающих

Здравствуйте! У меня проблема в том, что я делаю все так как там , но выдает ошибку в строчках на слова Excel, например: Код: Excel.Application xlApp; // здесь на Excel Error Namespace '<global namespace>' contains a definition conflicting with alias 'Excel' C:\Users\Администратор\Desktop\Excel\Exc el\Form1.cs 23 13 Excel Excel.Workb...

Script Shell Qui Ne Se Lance Pas Au Demarrage

Bonjour, Je souhaite lancer au demarrage un script php. Pour cela j'ai fait un script shell qui execute le script php. Mon script est le suivant : #!/bin/sh PATH=/sbin:/bin:/usr/sbin:/usr/bin:/opt/ sbin DAEMON=/usr/bin/php NAME=php DESC="Server php" PIDFILE=/opt/var/run/$NAME.pid RUNNING=0 PID="" # Defaults SERVERPATH="/volume1/web/back/se...

سوال: مشاهده نشدن Command prompt پس از اجرای فایل bat با دستور Shell

با سلام خدمت دوستان گرامی می خواهم برنامه ای بنویسم که زمانیکه با استفاده از دستور Shell ، فایل bat را اجرا نمودیم، زمان اجرا، command prompt در پایین صفحه مشاهده نشود. پیشاپیش از راهنمایی تان یک دنیا ممنون...