Search results for query: *

I have an Excel application which prepares data for entry into a web-based form on our Intranet. It even opens IE for me and sizes it so I can see both the information and the form to enter it. But I would prefer it if I get the app to fill in the data itself. Is there some way I can send a...

How can I open a browser and follow a link from a VBA script, and control the size and position of the browser window? I have an Excel spreadsheet application that organizes data in the spreadsheet for entry into a form on our Intranet. I would like to have it not only organize the data, but...

I have a subroutine declared by the following line: Sup Fliprows (ByVal tp as String, ByVal bot as String) I have tried to call it with the line: Fliprows ("ZMeetings", "ZSixSigma") When I try to enter this line, however, the VB Editor comes back with: Compile Error: Expected: = Try as I...

This is probably simple, but I can't seem to locate the right syntax/locations. I have a workbook with a macro which, at one point in its execution, opens a form for user input. I would like for the last value entered to show up as the default the next time the form is activated, even if the...

I am trying to create a dictionary object in a Visual Basic Macro running in Excel. The VB Help shows this example for creating and populating the object: Dim d 'Create a variable Set d = CreateObject(Scripting.Dictionary) d.Add "a", "Athens" 'Add some keys and items d.Add...

I have an Excel worksheet I have set up to track how much time is spent on various activities. To make the time entry process quick and easy, each activity is listed on a row and days are listed on columns. Each row is given its own command button. When the user finishes a task, he presses the...

When I sort files on my workstation, I get a sorting that puts the following two entries in the indicated order: M22759/16-2-9 M22759/16-22-9 There is a remote Linux cluster that is being installed on which they sort as M22759/16-22-9 M22759/16-2-9 I figured it was collating-order difference...

I first encountered this problem on a different forum, but am also experiencing it on this one. On the other forum, on my own machine when I try to log in, it will log me in, but apparently does not recognize any future pings as still being me. After logging in, it shows the welcome screen, and...

What is the best way to determine in a shell whether it is being run interactively or is running a script? The problem is most workers in my group need to do their work in a common directory. The usual practice has been to add 'cd /workingdirectory' line to their .kshrc files (obviously we...

Does anyone know a simple, fool-proof way of identifying the user in the Korn shell? The environment variable USER is writable, so anyone can change its value to whatever they want. For a while I thought that LOGNAME would do it, but then I realized that you can get around its protections and...

This thread is just a referal to the thread I posted on the General UNIX discussion forum. I have seen so many people in both forums refer to this trick that I wanted to make sure everyone saw it. The thread is: thread80-374220

I am posting this in both the General UNIX forum and the UNIX scripting forum since I have seen so many people suggest using the TZ trick described in [faq80-953] to find yesterday's date. Unfortunately the trick is flawed, unless you are using Greenwich Mean Time. To see the problem, try this...

We maintain a database of hardware weights consisting of a text file with lines following the format <part number> <part description> <weight> <other info ...> for example: 27489-001 switchlight 0.05 ... The problem is that our database is massive (over 156,000 entries so far) and...

A common practice where I work is to alias the arrow keys as follows: alias __A='^P' #up arrow=move back through history alias __B='^N' #down arrow=move forward through history alias __C='^F' #right arrow=move cursor forward one position alias __D='^B' #left arrow=move cursor back one...

Does anyone know a better way to direct awk output to more than one file descriptor than using print &quot;out&quot; | &quot;cat 1>&2&quot; for example? I would nawk, but around here there is no &quot;would&quot; to nawk, and I can't stand around and gawk. It's a very awk-ward situation. I...

I have a script in which I need to test a variable to see if it consists of a 7 digit number (possibly starting with 0) followed by a dash and a number of 1,2 or 3 digits. For example: 6912054-3 0156924-103 I have used [[ $num = [0-9][0-9][0-9][0-9][0-9][0-9][0-9]-[0-9]* ]] and so far gotten...

I have a file I would like to sort by 1 field, while otherwise leaving the order alone. For example if the original file is: 2 B 1 B 2 A 3 A 4 D 3 D I would like it sorted as: 2 A 3 A 2 B 1 B 4 D 3 D But no matter how I try to limit the sorting field of &quot;sort&quot;, within the...

I am trying to set up a database program so that the only way to change the database is through my program. I thought I had the answer in using the &quot;set user ID to file owner&quot; capacity of chmod (&quot;chmod u+s&quot;). I sounds to me from the description I have that when this is set on...