Recent content by chester27

Anyone seen this before?

100's of miles away. We only have RDp access, and is the only box with the application we want to call. I can do it using calls to batch files that use PsExec from Sysinternals, but this is not practical to place on 100's of PC's Just looking for maybe a function to call and execute the command...

Looking for help with creating a macro to launch a command or script on a remote server, and return success or fail.

Andy I thought I had, I only changed one line as it was more an oversight on my part, but just in case it is misread here it is. Sub ConCat() ' ' ConCat Macro ' ' Dim oWS As Worksheet, lLastRow As Long, r As Long Set oWS = ActiveSheet lLastRow = oWS.Cells.SpecialCells(xlLastCell).Row For r =...

Skip Yep my bad, "If Len(oWS.Cells(r, 4)) > 0 And Len(oWS.Cells(r, 5)) > 0 Then"..... should have read "If Len(oWS.Cells(r, 1)) > 0 And Len(oWS.Cells(r, 4)) > 0 Then...." All works a treat now Zelgar Do Until IsEmpty(Cells(oWS.Cells(r, 4)) ' Combine A to D keeps throwing a debug error but not...

Looking for some help or advice. Trying to create a Macro that will concatenate 4 columns A-D with a ~ separator in Column F. It needs to start in E2 and continue till empty cell in column D. I have tried the below so far but fails to continue past E3. Sub ConCat() ' ' ConCat Macro ' ' Dim...

I am trying to reduce the processing time of a spreadsheet that contains the following formula. The constants need to remain constant but the rest will need to reflect the position in the worksheet e.g. as it would if the formula were copied across columns...

Keep getting this in the logs... The ASA discarded a TCP packet that has no associated connection in the ASA connection table. The ASA looks for a SYN flag in the packet, which indicates a request to establish a new connection. If the SYN flag is not set, and there is no existing connection, the...

We have a site to site vpn setup between a cisco asa 5505 and a checkpoint NG firewall. We can do all the normal browsing of networks etc, but when we try and use a cisco ip phone, it rings once then goes engaged. If we use the VPN desktop client we are able to use IP communicator ok and all...

All sorted, found a rouge entry, and used the set dateformat to dmy then used the convert(xxxxx, 120) thanks for all the help.

This is driving me mad. Now finding dates as 1991-11-23. All these dates are in a VarChar column and need to update them to datetime in the new column.

Sorry for the confusion in advance, have had a closer look and it seems that the datetime given is 23-12-1991 00:00:00 and I am trying to update this into a datetime column and change it to 23/12/1991 00:00:00. If I leave as 23-12-1991 00:00:00 it works in the DB but application expects the / so...

I have a holding table with imported data from an external source. All columns are set to Varchar(50). When I try and run a script that takes this data and populates the correct table I get "conversion failed when converting to datetime error" data in Varchar field reads 22/11/2008 00:00:00...

Using Citrix default drivers and a Seagull driver for a label printer.

We have 4 CTX servers in a farm and 70 clients. Each PC that connects has a policy that sets the printers in session. These printers are mapped through from local clients. Printing is extremely slow, and puts a strain on the CTX servers if more than 10 users connected. Servers are W2K3 SP2 with...