Programming :: VBA / Excel - Looping Through Image Controls Based On Cell Contents?
Jun 28, 2011
I have an Excel Spreadsheet which reports upon weekly performance. One portion of the worksheet looks at week over week increases /decreases. I've placed a number of image controls (15 in Total) next to cells which calculate week over week change. The image controls simply display an image depending on whether the value of the adjacent cell is positive or negative. So, here is my basic working IF statement:
Code:
Private Sub Worksheet_Change(ByVal UpDown As Range)
If Range("J26") > 0 And IsNumeric(Range("J26").Value) Then
Image1.Picture = LoadPicture("C:path oup_arrow.gif")
ElseIf Range("J26") < 0 And IsNumeric(Range("J26").Value) Then
[code]....
As you can see, this is pretty simple. What I'd like to do is find a way to loop through all 15 controls and avoid having 15 IF statements run on the Worksheet_Change() event. The cells containing the week over week values are all in the same column, but not continuous. Involved cells are: ("J26", "J27", "J33", "J34", "J35", "J36", "J37", "J38", "J39", "J40", "J42", "J43", "J44", "J45", "J46")
I have a LAMP based web hosting account (BlueHost). I have an existing simple MS Excel application which I would like to make it web based. However I am not sure what tools or features of PHP are out there that will aid me with this task. Here are some details:
1. I don't want to create an entire Excel program online. For that there are plenty of existing applications like Google Docs, MS's own online version of Excel, etc. 2. My current excel file uses some of the following excel functions: a) SUM b) Product Sum c) Conditional Formatting (like changing font color if an amount is below a threshold, etc.) d) Sorting (Date, Amount) e) Drop Down Box to select pre-defined values
3. Ability to add/delete/modify a entry (row) 4. I don't care whether the application has the same look-n-feel as MS Excel.
As you can see it is a very simple home grown excel application with few basic mathematical functions. Here are some few thoughts that I have currently in my mind:
i) Just start coding intuitively as you would develop a normal web based application. ii) Do (i) but use some of the PHP's excel oriented helper functions (COMs?) if there are any iii) Use completely a different set of tools permitting that they run on LAMP environment.
I could have started with (i) but before making a costly mistake I thought I would get some opinion from the community to see if this is the right approach.
I want to know something: i have a OS based on Debian configured and installed on a machine that controls all the network. Then, I can access it via another machine (with Windows for example) (connected by crossover cable or using a switch) by a web browser where I can do everything, including adding hosts, adding users, configure mail servers, voip, configure domains, etc etc etc..I would like to install Nagios on my server but I would like to monitor the hosts, routers that I have on the network using the Windows machine. How can I do that? Isn't it supposed to access the nagios information only in the machine where it is installed?
I am querying a single string column in a table. The string values have spaces in them. I want to loop over each value in bash. I set IFS to split lists on newlines instead of spaces. When I try this, it is splitting the list of results on the actual character 'n', not the newline ''.
DATA=`mysql -u root -ppassword --silent 'SELECT name FROM table_a;'` IFS=$' ' for i in $DATA; do echo "item = $i"
instead of importing a file I would like to use the variable $x I tried using pipes, but with no luck. My goal is to read one line at a time, but not have to export my data to another file, I would like to keep it all within one script.
Fedora 13, 64 bit. I have 9 cell Dell Studio 1555. However, it shows a battery time equivalent to 6 cell one. Works fine with Windows 7. Recebtly upgraded the BIOS as well.. No effect.
how to generate excel charts from C, or if it's possible at all? For example, if I had 2 arrays that I wanted to export to excel and graph against each other. I know how to export it to a csv file, that's no problem, but I have no idea where to start with generating a graph of the data. I can't seem to find any examples anywhere. Just a simple example to show you what I mean: Code:
char arr1[] = {'a','b','c'}; int arr2[] = {10,20,30}; int main ()
Does anybody know how to generate excel charts from C, or if it's possible at all?
For example, if I had 2 arrays that I wanted to export to excel and graph against each other. I know how to export it to a csv file, that's no problem, but I have no idea where to start with generating a graph of the data. I can't seem to find any examples anywhere.
I'd appreciate if someone could point me in the right direction.
Just a simple example to show you what I mean code...
I am having trouble getting some code to work. It takes an input file (csv) and converts it to an XLS. The problem is that I can't seem to get a header to be printed first...
Code: use Spreadsheet::WriteExcel; my $input = $ARGV[0];
Are there any solutions by which linux-based web server frameworks (like zend or any other) can process data inside microsoft excel spreadsheets (*.xls)?
i am using linux for the first time. i have been given a project which will fetch data from csd(comma separated form) and ll display on d screen. i want a c program for linux which ll do the above given task. moreover i want the parameter file(such as location of file, file name,etc..) as a different file. so that i can access this program on any computer.
I have just exported 3 png files out of gimp for a html document I'm working on right now, and they are all almost the same, except I need each to load when the user does something. So the first image will display on the page, and when a user puts their cursor over it, then it will load image 2. When they press it, it loads image 3.
I have a system built and running in exactly the basic configuration I want, with my recompiled kernel, extra packages, special drivers, everything works, life is good. What I want to do is take this exact setup and create an image I can copy onto a bootable USB stick. Is there a way to essentially take the contents of my hard drive and copy that onto a USB stick and then boot directly from that? The use case behind this is that I am building an embedded system of which I may have hundreds of boxes with identical hardware and software configurations. Instead of hard drives, I am going to use USB sticks for cost efficiency and maintenance. My idea is that when it's time to upgrade, I could just image a hundred new sticks and go out and swap them.
My issue is that a standard LiveCD install gets me maybe 25% of the way to a finished system. I need to recompile the kernel for realtime support with my CPU, add some fidgety drivers for some specific hardware, and install a whole bunch of additional packages. I suppose I could create a makefile(s) to replicate all the manual steps of the buildout but that seems like a lot of unnecessary complexity IF I can just image that running system as it is.
When I eject CD from CDROM by pushing eject button(mounted on CDROM) it still shows CD and it's contents in nautilus file browser. If I replaced the CD it still shows contents of older CD. If I eject CD manually by file browser then there is no such issue. I know this is the kernel issue because this issue has come after updating my kernel from linux 2.6.33 to linux-netbook-2.6.35. I am using MeeGo. I want to know which kernel parameter(or module) I have to add.
A long time ago I wrote a short essay about the 'federal' 'reserve' board. I don't remember it's name or format. I think it's somewhere on my rather large hard discs (to of them divided into various partitions).I'm trying to write a command line that will find it based on a quote that is in it: "our fathers brought forth"I have tried various configurations of grep, and or combining grep with find, but I'm getting nowhere. I really don't understand the syntax of either command, or how they work together, and the examples that I can find are really no help at all.
I am trying to read the contents of a file into something else. I have a file.txt that I am working with, I want to read the file and take the data and run some commands with the data that it read. So if it read www.yahoo.com I want to be able to nslookup. Does that make sense? I have been trying to use the read command but that does not seem to work. I even was trying to read filename | > filename to see if I could even read any of the data at all. Nothing is working.
want to watch the file continoulsy for any newly written data to file.Presently i am periodically opening the file and checking for the newly updated contents.Is there something like refresing the file descriptor, since open is a system call, calling it many times may affect performance. Does the tail program opens file multiple times to check for the updated contents when used with -f option.Can some one explain or give some links on how the filedescriptors remembers its end contents while some other programs keeps updating the file.
I am in the process of writing a program that plays the game mancala. I wanted to create a function that requires the player to choose a number between one and six, should be simple right? I kept having problems, so I started testing stuff out.
Code:
#include <stdio.h> #include <stdlib.h> short move();
[code]....
I am using gcc version 4.3.2 (Debian 4.3.2-1.1). On a whim, I tried something else out; when I change the 'short' variables to 'int' , the problem seems to dissapear.... I tried changing the format string in the scanf statement from "%d" to "%u" which is listed as the appropriate string for the 'short' type, still no luck.
How can read the file /var/etc/allInOne.cfg and distribute its contents on multiple cfg files using C language. /var/etc/allInOne.cfg contain the data and the path of each text file.
The source file "/var/etc/allInOne.cfg "look like this: line1 line2 ... line10 filePath:/var/etc/file1.cfg line12 line13 ... line14 filePath:/var/etc/file2.cfg linen .. filePath:/var/etc/filen.cfg the result will be :
The expected result is: /var/etc/file1.cfg will contain line1 to line10 /var/etc/file2.cfg will contain line 12 to line13 /var/etc/filen.cfg will contain linen to linen-1
