130 reputation
7
bio website uk.linkedin.com/in/…
location London, United Kingdom
age 46
visits member for 1 year, 10 months
seen 16 hours ago

I am a developer at a retail bank in London, UK.

I mainly work in SQL Server (with SSRS and SSIS), c#, and VB.NET, but love using Excel and Excel VBA as well as tinkering with XML/XSLT when the opportunity arises


Mar
17
awarded  Critic
Oct
13
comment Command line to search for all word files using wildcards in filename
is there a way of counting all the files without listing them, or do I have to output them to a (text) file?
Oct
13
awarded  Scholar
Oct
13
accepted Command line to search for all word files using wildcards in filename
Oct
13
comment Command line to search for all word files using wildcards in filename
thanks, so is there a way of just getting a count of all the files with a name like ALPS*2013*.doc ?
Oct
13
asked Command line to search for all word files using wildcards in filename
Sep
16
comment folder only search with Windows Search in Windows Server 2008
@TECHIE007: good point, they may not be indexed - I guess we'll have to manage with an alternative option like building a batch file or vba tool to list the folders and move them to a place where they will be off the network file server and on backup...
Sep
16
asked folder only search with Windows Search in Windows Server 2008
Jul
9
awarded  Teacher
Jul
9
awarded  Excavator
Jul
9
awarded  Editor
Jul
9
revised How can I speed up my macro in Excel 2003?
described the links
Jul
9
comment How can I speed up my macro in Excel 2003?
maybe even worth copying the sheet data to an array then working on it in memory
Jul
9
comment How can I speed up my macro in Excel 2003?
have you considered copying the sheet data to an array and working on it in memory?
Jul
9
comment How can I speed up my macro in Excel 2003?
in a addition to the useful and informative answers below, are you selecting cells or ranges explicitly within your loop? This is a big performance no no NO, try just using the Range object with variables...
Jul
9
suggested approved edit on How can I speed up my macro in Excel 2003?
Jul
9
answered Writing VBA code to fill down to the end of a range which varies in length
Jul
1
comment How to import this data set into excel? (column headings on each row delimited by a colon)
why not open it from the text file, then use Copy> PasteSpecial - Transpose to transpose the data
Jul
1
comment Table of contents formatting
not really, in the end I had a document that was 250MB, so I started a new one, and copied everything over... thanks anyway
Jun
25
awarded  Supporter