Recent content by terryISO

Hi Paul. If you're using Spreadsheet::WriteExcel prior to version 2.17, you will get this problem with files larger than about 7 Meg. In that case, you need to install Spreadsheet::WriteExcel::Big. But that is now deprecated, so a better way is to install a newer version of...

Can I suggest (very strongly) that you also do this before you go much further, and then do it every few weeks? Open a DOS box (sorry, "command prompt" these days) and type: chkdsk C: /f /r Answer yes when asked if it should run when you restart the PC. I'll guarantee that it will find all...

And another missing semi-colon here: $gene_key{$gene}=($3." ".$2." ".$4) Should be $gene_key{$gene}=($3." ".$2." ".$4);

I don't see what you are hoping to achieve with this: my $rec={};

You can also do this to remove the leading zero: $hour=(1*$hour); But as prex1 says, why bother?

On some, maybe many, BIOS you don't need to do anything except tell the BIOS which is primary. No need to change any cables in that case.

When that old hardware that Windows 2000 is running on "FINALLY dies, what are you going to do then?" Same as I do now for new stuff with no 2k drivers. I'll simply use or tweak the XP/Vista drivers.

I have figured out a way around this now and have modified the Perl side of things to instruct the "built-in" Word functions to do what I wanted. my $filename=$_[0]; my $oWord = Win32::OLE->GetActiveObject('Word.Application', 'Quit') || Win32::OLE->new('Word.Application', 'Quit')...

Hi. Please excuse if this has already been answered somewhere, but of so I can't see it. I have anumber of programs where I have written a procedure in visual basic, and it operates within Word. As an example, I have a sequence which calls up a word document which contains a VB module called...

You don't say what platform you ar eusing (Unix, Windows etc), but I run Apache & Perl on Windows 2000. I have two Perl scripts which I run every three minutes, one evry seven minutes and five every Sunday. To do this I have set up scheuled taks using the Windows scgeduler. This works...

Hi. First the basic question (please excuse if this is so obvious that only a real newbie would get it wrong, but hey! I've done it wrong many times before!) Can you ping the Server? If not, you have a network problem, so check your network card and cable are installed and connected properly...

I use the WriteExcel module, but there is a distinct disadvantage. It writes in Excel 97 format. If you use the Win32::OLE module, it writes using the version that is installed on your system. Later versions of Excel have features that you may want toi use that are not available using...

Many thanks Bcastner! It was a profile issue. I deleted the profile off the the PDC and created a new one, and all is now working fine. It also fixed a couple of other minor niggles (print function caused the PC to reboot on some occasions, etc).

I have a strange problem on one PC in my network. If I go to START / RUN and then click on BROWSE, the task bar disappears and then comes back after a few moments. If I type the program name into the OPEN dialog box, that works OK. Now, I believe that this is Windows Explorer resetting itself...

Sorry, I gave you a Word example by mistake. It's a similar process using Excel. To open an Excel file, try using this in your main: use Win32::OLE qw(in with); use Win32::OLE::Const 'Microsoft Excel'; &open_excel("C:/myfolder/myfilename.doc"); # [other stuff] # --- end of main --- sub...