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 seem to have solved it, and it was thanks to strongm : "although I'd probably not bother with objXSD at all, and simply add the schema directly" Lessons learned: listen to any advice given, in full.

Many thanks, "urn:oecd:ties:fatca:v1" was indeed the namespace and specifying .6.0 ref has has given a fuller script error message: FatcaXML_v1.1.xsd#/schewma/complexType[4][@name= 'CorrectableOrganisationParty_Type']/complexContent[1]/extention[1]Undefined Undefined<complexType>...

Thanks again, I'll try it when I'm back in the office.

Strongm, Thanks for replying. I'm not sure I fully understand the concept of NameSpaces. As per the header in the OP would I need include multiple NameSpaces or just first? Also without the objXSD Wharf anything would be the second parameter fir the .Add method?

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...

Andy, many thanks. I did it with: ActiveSheet.Columns.AutoFit ActiveSheet.UsedRange.WrapText = True ActiveSheet.Rows.AutoFit

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...

Sorry I don't understand the question. A single hyphen is allowed, what do you mean 'pretend'?

One further amendment. I found the pattern I posted last was restricting a hyphen by the end of the string. so I now have : <xs:pattern value="([a-zA-Z\s\d_\. !$%^*\[\]()_+={}|:;,?~/£€@\\]|-([a-zA-Z\s\d_\. !$%^*\[\]()_+={}|:;,?~/£€@\\]|$))+[-$]?"/>

Fantastic! I've made a slight amendment to include characters I'd missed from the pattern in the OP and removed the anchors, but this seems just the ticket. <xs:pattern value="([a-zA-Z\s\d_\. !$%^*\[\]()_+={}|:;,?~/£€@\\]|-([a-zA-Z\s\d_\. !$%^*\[\]()_+={}|:;,?~/£€@\\]|$))+"/>

atlopes, at first test that pattern works however, as k5tm points out it allows the unwanted characters to follow a hyphen. but it's still a step forward from what I had yesterday.

Both, thanks for your input, this has taken up the majority of my day. K5tm, I tried grouping. several variations. I think it was the greedy " that was the route of my problem but I just couldn't find a way around it. atlopes, many thanks. I've left the office for the day but will give that a...

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...

Hi guys thanks for the time you've taken to respond. I've stuck with the second pattern I posted. This is to reduce the risk of matching errant strings such as UK postcode parts, and other random strings of the text I working with. I'm happy that this is now providing the required results...

Ok I seem to have found the answer with (Y00)([A-z]*\s|[A-z]*\.) however if you have any suggestions to improve this I'd be greatfull for your input. Never knock on Death's door: ring the bell and run away! Death really hates that!

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...

http://msdn.microsoft.com/en-us/library/00wf8zk9(v=vs.90).aspx Never knock on Death's door: ring the bell and run away! Death really hates that!

How about using Space()? Never knock on Death's door: ring the bell and run away! Death really hates that!