Search results for query: *

Hi Skip, adding to Mike's suggestion: choos "Transform", then "Rectangle". This should basically leave your optics unaltered but give you an option to stretch/compress. You might need to play a bit because of automatic wrap. Hope this helps. MakeItSo "Knowledge is power. Information is...

Your output data does not match your query. state='TN' and you expect outputs with states FL and CA? Please clarify what exactly it is you need. "Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan) Oppose SOPA...

Hi Tony, Sounds more like a SQL question to me; perhaps forum183 or forum436 would be a better suited forum? Depends on your DBMS. In that case you also might want to rethink your DB structure. You should not hold multiple values in one field. Hope this helps. MakeItSo "Knowledge is power...

Following a hunch, I used bugger translate to have this sentence translated into Chinese and back. Replacing "ting" with "thing" did not yield anything meaningful but replacing it with "Ting" led me to this: With "Ting" possibly referring to Shu Ting, a Chinese poet associated with the Misty...

Hi Chefe, please use English in these forums to make sure others also understand your needs and the solutions provided. [smile] That said, you can download a release package including the specification for ZUGFerD 2.x here: https://www.ferd-net.de/standards/zugferd-2.1.1/index.html Best...

Hi Ilya, Sounds like you are thinking of a class. Take a look at the following. It is C# but then again that is also .Net and can easily be converted/translated into VB.Net: https://www.tek-tips.com/viewthread.cfm?qid=370520 Hope this helps. MakeItSo "Knowledge is power. Information is...

Hi Ilya, my guess is the problem lies here: Meaning: your gcStrINI="" and your gcStrINI = loStreamReader.ReadToEnd() are not in the same scope and therefore two different variables, albeit with the same name. Can you post a larger portion of your code? P.S: When using a StreamReader or other...

You could try a quick workaround using OpenOffice / LibreOffice. open the csv there, save as csv with "adjust filter settings" option checked. Enclose in quotes. "Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi...

Can you please clarify? Site looks pretty identical to me in FF, IE, Chrome. "Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan) Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever...

First of all: LOL! Secondly: https://www.cambiaresearch.com/articles/15/javascript-char-codes-key-codes ;-) Oh, for point 2): You could try with a cookie as counter. A simple if / switch case should suffice for the rest. "Knowledge is power. Information is liberating. Education is the...

Hi Ilya, the usage of "using" is similar to that of "if" or "for": if only one statement follows, no need for braces, even if that one statement following is another "using" statement. Therefore, your code is equivalent to something like this: using (XmlWriter writer = XmlWriter.Create(result...

Hi Ilya, I though the other acronyms were explanatory enough: ACTA ;-) "Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan) Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name...

Hi Ilya, I'd make use of "StartsWith" instead of Contains: If cJustFileName.StartsWith("CD") OrElse cJustFileName.StartsWith("GH") Then End If This is assuming you got something like this: cJustFileName = Path.GetFilename(cFile) or cJustFileName = Path.GetFilenameWithoutExtension(cFile)...

Howdy! [ol a] Don't worry about InternalStartup. That's normal Are you using 64-Bit Office or 32-Bit? That's important Is your solution local or on a network drive? Addins need to be compiled and added locally I believe your code in Application_WorkbookBeforeSave is not quite OK [/ol]...

Glad to know it worked right away. Removing unnecessary physical action is what a script is for. [bigcheeks] "Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan) Oppose SOPA, PIPA, ACTA; measures to curb freedom...

Hi Hugo, I normally don't simply provide code as this is not the purpose of this forum. Also, such a script stopping to work might have various reasons that may not have to do with code at all, e.g. file server change (new name?), new security policies that prohibit VBScript execution, ...

You could simply do something like newTxt = Replace(txt, "'", "'" & Chr(13) & Chr(10)) "Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan) Oppose SOPA, PIPA, ACTA; measures to curb freedom of information...

Hi Mike, sounds like your best option would be to simply replace your Normal.dotm with your own template. [ol 1] open your .dotx via File=>Open save your .dotx as a .dotm close Word in Explorer, browse to %appdata%\Roaming\Microsoft\Templates rename Normal.dotm to "Normal.old" or similar copy...

Hi Mike, "New documents based on this template" means, that if you save this document as a .dotx or a .dotm, you can use it as a template for new documents. To use such a template, simply double click it. This will make Word create a new, blank document based on the template. No fear of...

Killed a user" - Sounds like your DBA is a proper BOFH: http://bofh.bjash.com/bofh/bofh6.html [bigcheeks] "Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family." (Kofi Annan) Oppose SOPA, PIPA, ACTA; measures to curb freedom of...