Search results for query: *

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')...

...$oWord->{ActiveDocument}->Close; $oDoc->SaveAs("E:/waste.doc"); $oDoc->Close; unlink("E:/waste.doc"); $oWord->Quit(); *************** My question is, does anyone know how I can pass a value from Perl to the VB module? I imagine it would be something in the line which fires off the...

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...

Hi. As sloppyhack never responded, I thought you might like the following example, which opens a Word document, then saves it in text format. I'm not sure from your posts if you have installed Win32-ole module, but you will need to do so first. Call it from your main routine like this: use...

Another thing to check is your Windows Update settings. It is quite possible that you have set it to automatically download and install updates. Some of the recent updates will cause your PC to reboot in it's (supposedly) quiter moments. I have seen my server do this a couple of times recently...

Hi again. Looking through my notes, there was one other fix that I found that worked when I had the same problem (I am assuming that you do have NetBEUI etc set up on the server and the Win98/ME PCs - you didn't mention if you had checked this in your last reply). That was to set up an LMHOSTS...

Hi. I had a similar requirement a couple of years ago. As I was using Word, I inserted some VBA code into the document and made it print some text fields to a label printer and then some text fields (the same as to the label printer plus some other fields) to a laser-jet printer. You _CAN_...

Hi. I have had this problem a few times in the past. I run a mixed Windows 98 and 2000 system, using an NT4 domain controller, but I also had the problem once or twice when I had only Windows 98 PCs with an NT4 Domain Controller. Solutions that worked for me: (1) Check that the IP address and...