Recent content by katerina

To be clear, that's what the codes are in VBA. Both the encoded text, and the javascript functions uncode/decodeURIComponent have it as %D1%8F

Hi all, I think the problem lies in the HTML-encoded text I'm receiving. For example, the letter Я has a character code of 1071 and a hex code of 42F. Changing Chr to ChrW allows greater than the standard 0-255 Chr range (except on Mac). So both of ?DisplayUnicodeMessage(chrw(1071))...

Hi, Thanks for the response. I know it doesn't like it - I'm hopeful I can pass it through OK - for example I can send Cyrillic from a table out to a unicode msg box fine: Private Declare Function MessageBox _ Lib "User32" Alias "MessageBoxW" _ (ByVal hWnd As Long, _...

Hi All, Am having trouble decoding URL-safe Cyrillic characters back to Cyrillic. e.g. %D0%A2%D1%8E%D0%BC%D0%B5%D0%BD%D1%81%D0%BA%D0%B0%D1%8F%20%D0%BE%D0%B1%D0%BB%D0%B0%D1%81%D1%82%D1%8C is Тюменская область The javascript fuction decodeURIComponent works fine (check the URL decoder on...

I can send the link to the actual file via PM (except I can't see a PM system?!?) if you're OK with that - I'd need to post the ftp pw which I don't overly want to publicly

There should be more tags - but I guess the principle remains that it did it, which is what matters. How did you 'know' it was working? - when I ran against a large file and stepped through the code, it didn't wait on the 'oxmldoc . Load importfile' line at all. After that I did wait a while...

Hi, Thanks for your time! Not sure which file that is, and I'm not on the machine which has a link to my actual file, but at springer dot com > Services > Booksellers > Datafeeds there is a 'sample files' zip under the Format Samples header. In this is an xml file, albeit only a Mb. C&Ping...

I'm happy to post the link by circumventing the restriction, but don't want to if it'll get me banned..?!

Yea other than that it worked well, very nice. Variants of the file can be found from here: [wanted to insert link!] they're ONIX-format xml files. Hmm, can't post the link as have less than 10 posts... Any ideas?! The file can be FTP'd from Springer (publisher)'s website.

Hi, Thanks for that. Although it works fine for a smaller file, it simply doesn't load the 96Mb. It passes over the 'oxmldoc.Load importfile' line much too fast (when stepping through), and the oxmldoc.xml value is either empty, or rarely, just the XML decs pre-header. Any ideas? ps Just...

Hello everyone :-) I have a large (90Mb) text file in xml format to import into Access. I can’t simply use the XML importer, because the xml is in this format: <record> <recordid>id</recordid> <attribute.1>value</attribute.1> <attribute.n>value</attribute.n> <group1...n>...