Search results for query: *

Problem: I want to move a range of data but using code similar to[CODE VBA]src_range.Cut Destination:=des_range[/CODE] I find src_range.Address is changed to match des_range.Address. In some cases my value for des_range is compromized. I want to retain the original definition of...

Problem: I want to move a range of data but using code similar tosrc_range.Cut Destionation:=des_rangeI find src_range.Address is changed to match des_range.Address. In some cases my value for des_range is compromized. I want to retain the original definition of src_range.Address. I...

I've been successfully using a home-grown event viewer that used$handle=Win32::EventLog->new($event_group, $server_name) ; where $event_group was one of the basic "Application", "System", or "Security". One of the routines looked for print jobs to help me keep track of the heaviest users...

Having trouble with a % symbol in a SQL update statement. The following is largely striped down, but illustrates the issue set rs = New ADODB.Recordset With rs .ActiveConnection = con_ref ' assume con_ref set up in preceding code .CursorLocation = adUseClient .CursorType...

Basics of problem: - Read value from cell into a var: EX: myvar = .Range("B300").Value ' say val is 0.023 - Copy val into another cell: EX: .Range("B3").Value = myvar ' B3 now contains 0.0230000000447035 More; - Excel 2010 - B300 format = General - myvar is DIMed as Variant - B3...

Looking to see if I can send a .wav to an extension and/or another number. Essentially what I'm after is similar to an automated dialing system calling someone and playing a message. In my specific situation, at a manufacturing plant I'm wanting to set up a phone in shipping/receiving which a...

Since I drop in here now and again to ask questions - thought I'd attempt to return some effort. The following procedure is something I put together a long time ago but has come in fairly handy while debugging larger scripts. If anyone has upgrade suggestions - great. If anyone can use this -...

Does Tcl have a command that will return a variables type anlogous to 'winfo class' ?

Working with tclodbc 2.5 If I add a dsn:database configure add_dsn $driver [list "DSN=$dsn" "DBQ=$dbfile"] I can then do:foreach tvar [database datasources] { puts $tvar } and I'll see the $dsn I just added. Is there a way to find the DBQ information? Somethine like a 'database examine $dsn'...

Start with a MSWord template similar to: I select a range (say range_1) modifying text as current needs dictate (eg. today_bla bla bla) I then go back over the range and look for chunks of text I don't need (eg. unused_text), and want to delete the entire line. Here is my existing sub to work...

Please consider the following pseudo code: With Selection.Find .Text = "foo" End With If Selection.Find.Execute Then preserved_selection_state = Selection.Find Call some_subroutine_that_modifies_Selection Selection.Find = preserved_selection_state End If Can something like this be...

The goal is to read MS Access tables. I have some code that has worked, but I can't get it to work consistently. Looking to find out what I'm missing: Surfing, I found this code: package require dde set request "$mdbfile;TABLE $table" set it [dde request MSAccess $request All]...

I'm actually using Excel versus Access. Can't find an excel specific forum, hoping there is enough overlap to validly post here: - Have a basic form (call fUsrOpts) with a handful of OptionButtons broken down into different GroupNames (eg. "camera_num", "lens_filter"). - I'm looking for a...

Found the following:print "Index of first element $[\n"; print "pre 0 exists\n" if (exists $arr[0]); print "pre -1 exists\n" if (exists $arr[-1]); push(@arr, 'foo'); print "post 0 exists\n" if (exists $arr[0]); print "post -1 exists\n" if (exists $arr[-1]); print "arr elements $#arr\n"; This...

Not 100% sure just where the source of the problem is here: Setup: - OS: WinXP SP3 - Loaded apache http server 2.2 - appears to test ok - Loaded MySQL - generated tables - all is ok - Loaded php - generic 'hello world' works (hello.php) under command prompt - hello.php works as web page under...

Working with logon screens. While surfing finding lots of references to: 1) Goto Control Panel > User Accounts 2) Select "Change the Way Users Log On or Off" And / or 1) Goto Control Panel > User Accounts 2) Change "Users must enter a user name and password to use this computer" option...

Have a scripting question: The following code snippet works on *most* of my servers and all of the work stations I've tried so far. strComputer = wscript.arguments(0) Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set...

According to the help screens 'shutdown -f' should close open apps without warning. I'm running into the following scenario: 1) Open accessories->paint and make some change 2) Open a cmd prompt and issue "shutdown -f" 3) I'll get asked if I want to save the 'paint' program. 4) If I respond...

Not 100% if this is more appropriate here or under a perl forum - effectively a cut-n-paste of this has been already done there..... I have a script which telnetsinto a unix-AIX box from Windows. All is well. Starting to use the same routine to log into a SuSE10 box and am seeing the...

Not 100% if this is more appropriate here or under a unix forum - will likely be doing a cut-n-paste there as well. I have a script which uses Net::Telnet to telnet into a unix box from Windows. All is well. Starting to use the same routine to log into a SuSE10 box and am seeing the following...