Programming :: VB Scripting Worklsheet And Key Events?
Jan 18, 2011
am working an a worksheet where I need to lookup id in an other worksheet.The script works as long as I am staying on the same row. When pressing key up or enter the corresponmding lookup information is not placed on the very same row.In short terms, I want the lookup data to be enterd on the same row no matter what key I am pressing.
The script:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cfind As Range
On Error Resume Next
If Intersect(Target, Range("A:A")) Is Nothing Then Exit Sub
thisRow = ActiveCell.Row
[code].....
This example is set to Enter key procedure. So when the enter key is pressed, my current row will change by 1 so I have to compensate for that. All I want is that the data will be correctly enterd no matter what key I am pressing.
View 3 Replies
ADVERTISEMENT
Sep 17, 2009
Is there a firefox add-on to script HTML and/or Javascript directly inside firefox
View 1 Replies
View Related
Jan 8, 2010
I wonder if there is a way to caputure all X keyboard events, blocking them from going to the window with keyboard focus?
View 4 Replies
View Related
Nov 13, 2010
how to intercept the mouse and keyboard events in Linux,like hooking technique in Window ?
View 1 Replies
View Related
Feb 3, 2011
I have a program that receive user input.
I want to run this program automatically without user interaction, and in order to do that I need to simulate key events.
How can I do such a thing?
The program I am running is partly java and partly shell.
The shell part is easily done by using:
./prog.sh <parameters (Parameters being a file containing parameters)
But the java doesn't work similarly.
View 7 Replies
View Related
May 8, 2011
I want to capture short randomly occurring events such as Sudden Interstellar Disturbances, Lightning, ion counting, etc. To do this I wish to use the LINE-IN port. My sensor would feed a signal of less that 2 volts but could be submitted via a voltage divider. Since the sound card captures 44100 events per second this should capture events I am looking at, I think, but maybe not. I would capture the sound buffer to a string or memory buffer every second (and half second so I can prevent overwriting of its buffer, then merge the two).
Every 60 seconds (for validation) I would run "time" and count full buffer transfers in between to time events. By effectively counting characters from the beginning of the processing buffer to the beginning of the event I could further refine the "time to event". I think I could then save a decent number of values or until no data received from the processing buffer to preserve the event. This I would output with event time (to within 1/44100 sec) along with the data points captured to a file.
Except for the outputting of info to a file I think I can scan a buffer for events within a second (while LINE-IN continues capturing data on that port). I believe I have a way to handle the outputting. I am asking if any of the processing of the previous buffer would interfere with the sound cards data capture on LINE-IN? There would be no disabling of interrupts. I am presuming that system interrupts would not effect the LINE-IN data capture. Is this true?
View 6 Replies
View Related
Aug 25, 2010
i want to capture the mouse events (click,double..,position ) as well as keyboard events (key strokes) for every application running separately?
View 1 Replies
View Related
Nov 23, 2010
Is it possible to generate keyboard event "Ctrl+c" from a shell script code.? I have written a shell script to compile my application and copy it to the server home directory, inorder to run my application I need to start the server (by running a shell script). But before that I need to stop the the currently running instance of my server. To do that I have to generate a keyboard event (Ctrl+c which I press it manually). I want to automate the entire process by writing a shell script I am able to run the server just by adding ./run.sh in my shell script. But before that to stop my server can I generate a keyboard by using a shell script event(ctrL+C) to stop server.?
View 2 Replies
View Related
Mar 7, 2010
Groovy is an object-oriented programming language for the Java platform. I do not have experience in Java, only perl and shell scripts. Recently I have been asked to maintain a software written in groovy (also to make enhancements). So can I learn groovy without knowing java language. or isit I have to learn java before venturing into groovy.
View 1 Replies
View Related
Jul 27, 2011
some basic programming/scripting/etc. ability but I am not able to do what I now need to do. I would like to have a link on a website that when a user clicked on that link, one script or another would execute based on what operating system that person is using. To wit: If a Mac User clicked on it, it would run a terminal script and would set up a served printer for him; if a PC user clicked on it, it would run a script to set up the served printer on his machine, you get the drift. The printer is being served on a Windows Server 2003 machine, the users are NOT domain users, the print server is also hosting the files, scripts, webpage.
View 11 Replies
View Related
Jul 23, 2009
I want to know which is the best scripting language right now and what you guys think its going to be the best or most used in the future, that is, in about 5-10 years. Take into account system administration and applications. This are the languages i had in mind, add more if you think other scripting languages are better or worth considering.
View 14 Replies
View Related
Jul 13, 2011
i'm in the process of learing C++. currently i'm creating shell scripts to get things done. i'm just curious how, as a programmer using C++ you would get a similar job done.as an example i have a script that takes the contents of files, pipes it to some sed and awk commands, which is piped to create a new file. that file is then imported into a mysql database.if you were going to do this in C++, would you call the sed/awk programs to modify the file, or can it be done within the program itself? i'm probably jumping the gun here because i've just started learing about pointers so this is above my ability
View 12 Replies
View Related
Jul 8, 2010
I need to find a way to download the attachment from a daily report e-mail to me. The kicker is it will need to be down with a cron tabbed bash script.For example, which linux based CLI client is best suited to be scripted?
View 2 Replies
View Related
Jan 27, 2010
I'm trying to put together a script that will quickly run through an archive directory of log files that are named by day of the month 01.gz, 02.gz, 03.gz.... 31.gz. The script uses gunzip -c | grep | wc to count up the total number of hourly occurrences of a filename and outputs the results to stdout.
The only snag I have left is the octal limit when it gets to 08 and 09. I've seen examples using perl and awk, but this script uses a number of nested for loops and if statements that I don't want to have to rewrite in a different syntax. I found that I can use num=10#08 to set that variable to a base 10 instead of a base 8, but then I lose the leading 0 again when it passes the number to the next filename variable.
View 8 Replies
View Related
Aug 4, 2010
I am a newbie, I am writing a script file to execute some programs.
# ! bin/ bash
clear
echo "*************************************"
echo " ACOUSTIC MODELLING - BELLHOP "
echo "*************************************"
#exec ssh automatix
code....
problem 1 : I can ssh to the required space but after the terminal prompts me for password it stops ececuting the script.
problem 2: after performing the 'exec' command for the first time. its not executing anything after that line. is there any work around for this.
View 1 Replies
View Related
Jul 28, 2009
We have to (re)write a bunch of scripts to download files from remote ftp servers, where we won't know the names beforehand; move the files to an archive folder on the FTP server; copy the files to the correct servers on our LAN; and log the file information in Oracle.Our current scripts are for a windows product called ScriptFTP that provides a nice little language. It does everything except the logging, but we're wanting to get rid of Windows.
I have recently been given the job of maintaining the code, and I'm looking for a good language for simple, robust ftp scripts that will work on Linux. We have some customers with remarkably unreliable FTP servers. If necessary, I can write another program to handle the logging to Oracle. I'm usually a C++ developer, so a similar syntax is a bonus. I also want to be able to hand this over to an entry-level programmer later.
So far, I'm intrigued by PHP, but I've hardly had a chance to look at it for any scripting. I like the idea of being able to loop through the files individually and even be able to skip over anything that looks like it's currently being written (either based on the file name or date/time). I've thought about writing something in C++ that would take a simple config file instead of a full blown script. However, I don't want the maintenance, unless someone writes a quality FTP library that is inexpensive (hopefully free) for commercial use.
View 10 Replies
View Related
Aug 13, 2010
I am going to school for Network Engineering and hope to one day be a systems administrator or something similar. I was wondering what some good scripting languages would be to learn. I know the obvious, Python, Perl, Shell Scripting and PHP, but what else?
View 10 Replies
View Related
Dec 1, 2010
I am familiar with C, C++, and Python at a novice level. I have recently tried learning bash, but I can't seem to wrap my head around it. My biggest problem, I think, is the huge "vocabulary"-- it seems like there are thousands of commonly used commands, and several ways to use said commands.I've done some google searches but can't seem to find scripting tutorials that tailor to n00bs. Most go from basic "Hello World" programs to very complex scripts.
View 5 Replies
View Related
Aug 25, 2015
You are probably using systemd (check it with ps --pid 1) and therefore /etc/init.d isn't considered for autostart. Here can you find some information about systemd and autostart [1]. As far as I know systemd isn't intended to start applications with systemd. I recommend you to use the autostart feature of your window manager or desktop environment or at least the .xinitrc.
[URL] ....
View 7 Replies
View Related
May 19, 2010
My query is i have a.sql , b.sql , c.sql files which needs to be executed using "$ db2 -tvf a.sql"; "$ db2 -tvf b.sql"; "$db2 -tvf c.sql" , script with which i can execute all these sql files in a single shot.
View 4 Replies
View Related
May 7, 2011
looking to write a dependency map tree that creates a tree structure of object names . This tree will be written to a file and read back to create the tree structure of files . how to write this using bash ?
View 1 Replies
View Related
May 29, 2011
I have a file called list.txt with on word on each line that changes in length. I'd like to make a menu, each line being its own choice. I pieced together most of it the only thing missing is a failsafe for typing a number out of range
Code:
#!/bin/bash
p=`cat list.txt | awk '{print$1}'`
[code]....
View 2 Replies
View Related
Jul 6, 2011
I've been using Ubuntu for about 6 months now, but haven't had a need to start scripting until just recently. I know programming basics, but that's about it.Anyway, I have a program that I would normally run in this manner (note that I didn't create a permanent alias because I've been moving the program around a lot):alias dx='python /path/to/dxProgram.py' dx A_input.dx B_input.dxSo, you see, program dx takes two input files, and 'A' must come before 'B'. I have a folder full of these types of files that I'd like to loop through with this program. They're named as follows:
0_A_input.dx
0_B_input.dx
1_A_input.dx
[code]....
View 6 Replies
View Related
Jul 13, 2010
Does anyone have an example of a way to use ImageMagick or GIMP to Auto-White-Balance and scale 50% as a shell script? I'm asking because I usually do this to post-process photos in GIMP but being able to do this in a shell script means I could put it in Thunar in Xfce and save myself quite a bit of time.I checked the man page of mogrify and convert and didn't see any auto-white-balance type options that I am aware of
View 3 Replies
View Related
Jun 19, 2009
I made a little rsync script for log transfer.
Code:
SERVERS=(SERVER1 SERVER2 SERVER3)
SERVER1_SERV=(web ftp mail)
SERVER2_SERV=(web transcoding)
SERVER3_SERV=(web ftp mail)
for SERVER in ${SERVERS[@]}
do
echo "Starting tranfer for server $SERVER"
for SERVICE in ${$SERVER_$SERVICE[@]}
do
something_to_be_done
fi
done
But when I run it I get ${$SERVER_$SERVICE[@]}: bad substitution
View 5 Replies
View Related
Sep 5, 2010
How do I create a user account in a shell script? I know this may sound n00bish to you, but I know it's more than just mkdir-ing the home directory and subdirectories.
View 7 Replies
View Related
May 26, 2011
Which scripting language to learn for Linux Administration? Python, Ruby, Perl, or PHP?
View 7 Replies
View Related
Jun 29, 2011
i'm wondering which scripting language is better for distro related activity such as cron jobs , startup scripts and similar things.why is bash mostly used ? is it because of efficiency ?what about perl , python or php as potential successors to bash ?
View 14 Replies
View Related
Dec 2, 2010
I need to part a string into separate integers ....like "0x0-0xffffffff,0x20000" into 3 integers 0x0 and 0xfffffff and 0x20000.... i can't use any other high-level languages ..
View 3 Replies
View Related
May 21, 2011
I need to write a bash script that will allow me to manage my "virtual network" (in reality just a bunch of directories and files). I need to obtain something like : I have my own command 'connect'. We can use it in two different modes: user and admin. If I type 'connect adashiu virtual_machine_name, computer will ask about password, if password is correct he will change a prompt to :
adashiu_at_virtual_machine_name >
after that user can start to use commands reserved only for user mode. Analogically with admin mode: prompt 'admin >' and administrator can only use bunch of commands reserved for him. changing prompt and separated commands for user and admin ?
View 8 Replies
View Related
