Search results for query: *

Is there a programmatic method to differentiate between files created by an MS program or a simulator such as open office?

I'm trying to validate an XML against the XSD Schema. At the point of adding the SchemaCache I get the error Incorrect definition for the root element in schema. I may be completely wrong but I maybe missing a required namespace. I've having trouble understanding the MSXML model and I'm...

a corporate system outputs data into an Excel spreadsheet. cell that have line feeds are displayed: aaabbb, but on double click the cell is expanded and displays: aaa bbb I've trying to replicate this for all used cells. A recorded macro shows: Range("A11").Select...

Hi, I'm trying to write a regex pattern for my schema. I want to prohibit the use of certain characters ("&'#) & -- I have the following pattern that works to a point: [a-zA-Z\s\d_\. !$%^*()_+={}|:;,?~/£@\\]* I'm having trouble restricting the hyphen '-' to a single char as I need to exclude...

Why is vba so slow to run in office 2013 when compared to earlier versions of office? I find everything much slower but more noticeable are routines in Excel. I've tried running the following first but get limited results in terms of speed. Function StopOperations() With Application...

I’m trying to count the number of personal titles in a body of text. Each title is prefixed with ‘Y00’. I use this regex pattern: (Y00)[A-z]*\s This works well to match the prefix followed by Alpha characters until whitespace. And so will match: Y00Mr Y00Miss Y00Prof However it misses the...

Is it possible to set a variable that although isn't part of the post array will be available allowing that the post array is sent to same page? I'm trying to use Paypal IPN. When Paypal returns notification I'll want to insert into mySQL. Can I store the sql insert string so that it's...

When sending an SQL to an Access DB on a network server is the whole table returned in the record set and the unneeded fields discarded by the Client, or are only the requested fields returned? Never knock on Death's door: ring the bell and run away! Death really hates that!

I've been running a varient for the following code to query 1 Excel workbook from another Excel work without problem for about 18 months. Now it's stopped reading the field 'Closed' (this is a date formatted column "dd/mm/yyyy hh:mm") although it will read other columns of the same format. I'm...

Hi, I posted thread707-1596418 in VBA Visual Basic for Applications (Microsoft) Forum but realised it may be better suited to this forum. Any help gratefully received. Never knock on Death's door: ring the bell and run away! Death really hates that!

We currently use 3 directories (AD, x500 & SunOne authentication directory). I’ve successfully used ADO to connect to the first two directories, but am now having trouble connecting to SunOne. With the first two directories I used and LDAP query i.e <LDAP// ServerAddress / StartNode >. For...

This has been bugging me for sometime (but I've just got around to looking into it). When I plug in headphones the Laptop built in speakers continue playing. It's a Medion Laptop running Vista with Realtek HD sound card / Software. I've tried updating the sound card driver, no joy. Poured...

This has been bugging me for sometime (but I’ve just got around to looking into it). When I plug in headphones the Laptop built in speakers continue playing. It’s a Medion Laptop running Vista with Realtek HD sound card / Software. I’ve tried updating the sound card driver, no joy. Poured...

The following is throwing the error "Too few Parameters. Expected 2." I just can't see the error. Can sombody please help? Private Sub AddDataToSheet(ByVal sTeamName As String, _ ByVal sSubject As String, ByVal dtReceived As Date, _ ByVal sStatus As...

I posted the following question in the Java Script forum but have had no takers. This may be due to the question having CSS impications. can you help? I've tried to incorperate the Slide and hide function I found here http://www.iwdn.net/showthread.php?t=5637 into my website. I found it works...

I've tried to incorperate the Slide and hide function I found here http://www.iwdn.net/showthread.php?t=5637 into my website. I found it works well to a point. the div seems to slide to zero hight as intended, but it remains visible and the result is overlapping text. Do I need coloured...

Some time back I found and used the following function. Recently I've found that this will not copy all info from a given cell. i.e. is a cell holds large amounts of text only some of this will be collected by the function. Can you suggest a fix or an alternative? Private Function...

The network connection icon has 'buggered off' from my system tray. has this happened to anyone else? Why did this happen? How do I get it back? Never knock on Death's door: ring the bell and run away! Death really hates that!

I'm refrencing the Active DS Type library and using ADO to query active directory with an LDAP syntax. All it well for the most part. However for some attributes I get the error: -2147463155 "The directory property cannot be found in the cache." I've tried using the IADsUser object and the...

Hi, I'm still very new new to javascript, but I'm trying. I wrote the following to be called from a rollover event: function roll() { var p var a = 1 while (a <= 16 ) { a++ p = a + ".jpg" document["sub_but"].src = p; if (a>=16) { a=1 } } } but this is...