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 Mike Lewis 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 !

    My Accounting team runs a Macro Against a workbook that takes approximately 35 - 50 mins to run. Previously running this Macro on Excel 2003 it took about 2 mins to run... Here are the old and new system settings: Old System Windows 7 (32Bit), Office 2003 (4 Gig of Ram) Dual Core Processor...
  6. Pyro777

    Excel 2013 Macros are running Extremely Slow.

    My accounting team runs a Macro against a Workbook that takes approximately 35 Mins to run. Previously running this Macro, on Excel 2003 it took about 2 mins to run... Here are the old and new system Settings: Old System: Windows 7 (32 Bit), Office 2003 (4 Gig of Ram) Dual Core Processor...
  7. Pyro777

    Divide Network Total Bytes Received by the Total Bytes PerSecond

    I am very new to Powershell (If you couldnt tell). How would i assign a numerical value ??? All I am wanting to do is take the Network card in my Provisioning server (Get the Total Bytes Per Second and divide it by the Total Received Per Second) so i can get a network load on that/those...
  8. Pyro777

    Divide Network Total Bytes Received by the Total Bytes PerSecond

    With the below Powershell Script, I can display both the Network Total Bytes Per Second and Total 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...
  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

    I need a little help with my syntax.... This script displays the memory information from all of my systems when it is completed, I am trying to ping the systems first before letting the script search the WMI to query the memory information, if the system does not respond, I want it to log that...
  18. Pyro777

    Auto copying files but not replicating existing files

    Have you tried using robocopy, with the correct switches 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\...
  19. Pyro777

    This I am missing the last server on my list

    PHV, I knew it was something minor, but I am learning as I go along... You totally ROCK, Works Great Now !!! I just gave you a star.... 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...
  20. Pyro777

    This I am missing the last server on my list

    This script goes out and checks all of the servers that I add to a text file called servers.txt on my C:\ drive. The script works great with one issue. If I have 3 servers listed. It will display all 3 servers, total disk space, used disk space and available disk space with no issues. At the...

Part and Inventory Search

Back
Top