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!

  • Congratulations Wanet Telecoms Ltd 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. Pyro777

    Excel 2013 Macro runs Extremely Slow !

    Yes I am, I am sending all of your recommendations to my programmer, people in my company are pretty stubborn. Thank you everyone for your assistance. Let me know if you can think of anything else..
  2. Pyro777

    Excel 2013 Macro runs Extremely Slow !

    Good Thought Andrzejek... Here is part of that code that is run 90% of the time. Maybe some assistance with this part then i can work from there ?? Sub Rate_Filed() Dim sht As String Dim dPolPrem1 As Double, dPolPrem2 As Double, dcapfact As Double Dim ncov As Byte, Lstrow As Integer, n As...
  3. Pyro777

    Excel 2013 Macro runs Extremely Slow !

    Thank you for your Quick response on this one Zelgar. Unfortunately i have already tried this and still very slow. I believe it is in the coding per earlier comments but I am not very familiar with the Coding/Syntax... Once again, thank you for your input !!
  4. Pyro777

    Excel 2013 Macro runs Extremely Slow !

    This is why I love this site, you two are awesome !! The only unfortunate item is that I did not create this Macro. I am trying to assist our Accounting team. I am not very strong with Macros in Excel. Combo, Do you have any additional coding i can replace in this Macro as i am not very...
  5. Pyro777

    Excel 2013 Macro runs Extremely Slow !

    ...Then drencapfact = 1 ElseIf dPolPrem2 / dPolPrem1 > dcapfact Then drencapfact = (dPolPrem1 * dcapfact) / dPolPrem2 Else drencapfact = 1 End If For j = 0 To jUnit...
  6. Pyro777

    Excel 2013 Macros are running Extremely Slow.

    ...Then drencapfact = 1 ElseIf dPolPrem2 / dPolPrem1 > dcapfact Then drencapfact = (dPolPrem1 * dcapfact) / dPolPrem2 Else drencapfact = 1 End If...
  7. Pyro777

    Divide Network Total Bytes Received by the Total Bytes PerSecond

    ...?? Here is an example of my script that does work for another monitoring piece... $Process = Get-WmiObject -Computer Server21 -Query "Select * from Win32_Process where name = 'InetMgr6.exe'"| Select @{Label="Server...
  8. Pyro777

    Divide Network Total Bytes Received by the Total Bytes PerSecond

    ...Bytes Received. When I try to divide on the 3rd line, I receive the following error: (Listed Below my Code) $cnt = ([int]"\Network Interface(B*)\Bytes Total/sec") $cat = "\Network Interface(B*)\Bytes Received/sec" $cant = ($cat,$cnt) get-counter -ComputerName Server1, Server2 -counter...
  9. Pyro777

    VBscript for printers

    Here is a little nugget we used to use, now everything is handled through GPO but hope this will help you. This script will check the Security group your users belongs to and then if found will map a network printer.. You can add as many security groups and printers under each heading.. Hope...
  10. Pyro777

    Read multiple workstations from a Text file

    Hello, I have a script that will ask you to enter in a file extension then check to see what file is associated with it. It will then write the information found to a text file on the local C Drive. I was asked to run this script against every system in my production network. All systems are...
  11. Pyro777

    The application failed to initialize properly (0xc0000005)

    JockMullin, Thank you for all of your great input but unfortunately I have already tried the things you have recommended. As I have noted earlier in my the posts before. The .bat file works with No issues if it is only Windows XP SP1. I am an administrator with full rights to the network, the...
  12. Pyro777

    The application failed to initialize properly (0xc0000005)

    Thanks for your information Linney, I will check this as well, but the .bat file is on the local desktop with full rights for both me and authenticated users (Just in case), I am a local admin as well as a network admin, so all of the rights are in place.. This was working with no issues when it...
  13. Pyro777

    The application failed to initialize properly (0xc0000005)

    I just installed MDAC 2.8 SP1 from your link and am still getting the same error. Any other possiblities ??
  14. Pyro777

    The application failed to initialize properly (0xc0000005)

    Yes I have updated to SP3 and all the latest patches, I am a Network Administrator so rights are good, along with I have Local admin rights on the system. It was running with SP1... I will check the MDAC, is that something that SP2 changes when installed ??? Thanks for the quick response !!!
  15. Pyro777

    The application failed to initialize properly (0xc0000005)

    Here is an old error but with a new twist. I am trying to bring my company into the Realm of Windows XP from Windows 2000 as the higher ups do not want to go to Windows 7 as of yet... All of my applications but one works on Windows XP. Here is the twist, the application is a .bat file and all...
  16. Pyro777

    Ping each workstation first, then check WS Memory totals using WMI

    That is the code i am using, I added the Ping information but not sure if it that part is actually working... If I take it out, I takes over 20 mins for 15 systems to be checked as the script stalls on workstations that are not available on my network...
  17. Pyro777

    Ping each workstation first, then check WS Memory totals using WMI

    ..."INSTALLED MEMORY DIMM INFORMATION" Set objwmi = GetObject("winmgmts:\\" & strcomputer & "\root\CIMV2") Set colSettings = objWMI.ExecQuery("Select * from Win32_ComputerSystem") For Each objComputer In colsettings strmodel = CStr(objComputer.Model) F.WriteLine "Your Model number is...
  18. Pyro777

    Auto copying files but not replicating existing files

    ...it will only copy new files added and any files that you have changed... Here is an example of a script I use in my production environment... ' *** NOTE1::: You MUST have a copy of ROBOCOPY.EXE in the c:\program files\CCMCTools\Apps\ folder for this script to WORK !! *** ' *** NOTE2::: A...
  19. Pyro777

    This I am missing the last server on my list

    ...Thanks for all of your help... In case anyone else wants this code here is the final working code... Thanks to PHV !! On Error Resume Next '********************** '* Standard Variables * '********************** strserverlist = "C:\serverlist.txt" '********************** '* Constant...
  20. Pyro777

    This I am missing the last server on my list

    ...%Free Used Space Server1 194.4 GB 77 GB 40% 117.4 GB Server2 31.2 GB 13 GB 42% 18.2 GB Server3 52 GB 31.7 GB 61% 20.3 GB *Total Used Disk Space is 135.6 *Total Disk Space is 225.6 The script has not added the totals for Server3. The script seems to drop off the...

Part and Inventory Search

Back
Top