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..
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...
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 !!
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 !!!
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...
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...
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...
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\...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.