Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. terryISO

    WriteExcel error message - file too big

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

    Windows XP Performance

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

    a tiny syntax error for new commer

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

    Multiple Replacement within a loop help.

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

    Getting rid of the first 0 digit when counting

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

    WINDOWS 2000 PROFESSIONAL

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

    Why are YOU still running Windows 2000

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

    Passing values fromPerl to Word

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

    Passing values fromPerl to Word

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

    okay, i need to run a perl script each day at 1 am, automatically...

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

    How Do I Add A Windows 2000 PRO W/S to An NT 4 Domain Whcih is not run

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

    How to open an existing excel file using Win32::Ole

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

    Problem with BROWSE function

    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).
  14. terryISO

    Problem with BROWSE function

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

    How to open an existing excel file using Win32::Ole

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

    How to open an existing excel file using Win32::Ole

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

    Windows 2000 reboots from tie to time Help!

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

    No domain controller can be found

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

    Can I set 2 Printers up to be the default

    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_...
  20. terryISO

    No domain controller can be found

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

Part and Inventory Search

Back
Top