Solved
May 3, 2011
Code to loop through all records in MS Access
I need a code to loop through all the records in a table so I can extract some data. In addition to this, is…
thumb_up 46
trending_up 19
VBA Core
<p>General-purpose VBA techniques spanning the Office suite.</p>
Solved
April 25, 2011
Converting PPT to SVG using Microsoft Office 2010 PIA
I'm trying to convert a powerpoint presentation to seperate svg files (1 for each slide), Is it possible to do so by using the…
thumb_up 8
trending_up 7
Solved
April 19, 2011
User Defined Functions NOT recalculating
I recently took a large, stable XLSM file, and split it apart into an XLAM and XLSX. Thousands of cells in the XLSX call…
thumb_up 4
trending_up 8
Solved
April 17, 2011
How do I declare an array variable in VBA?
I need to add the var in array Public Sub Testprog() Dim test As Variant Dim iCounter As Integer If test = Empty Then…
thumb_up 25
trending_up 17
Solved
April 13, 2011
Using VBA to get extended file attributes
Trying to use Excel VBA to capture all the file attributes from files on disk, including extended attributes. Was able to get it to…
thumb_up 15
trending_up 11
Solved
February 22, 2011
How To Disable “The document being saved contains tracked changes” Word Dialog Using C#
Microsoft.Office.Interop.Word.ApplicationClass msDoc = new Microsoft.Office.Interop.Word.ApplicationClass(); msDoc.Visible = false; msDoc.Application.Visible = false…
thumb_up 9
trending_up 4
Solved
January 25, 2011
32 and 64 bit interoperability on 64-bit Windows
Is there a good thorough authoritative reference that discusses interoperability between 32-bit and 64-bit processes? Based on googling I have deduced that: A 32-bit…
thumb_up 5
trending_up 8
Solved
December 29, 2010
How do I get regex support in excel via a function, or custom function?
It appears that regex (as in regular expressions) is not supported in excel, except via VBA. Is this so, and if it is, are…
thumb_up 26
trending_up 17
Solved
December 6, 2010
What does the ‘x’ in the extensions aspx, docx, xlsx, etc. represent?
Or at least describe about.aspx
thumb_up 11
trending_up 4
Solved
November 26, 2010
Does Dir() make any guarantee on the order of files returned?
I am trying to clean up some existing code Sheets("Control").Select MyDir = Cells(2, 1) CopySheet = Cells(6, 2) MyFileName = Dir(MyDir & "wp*.xls") '…
thumb_up 6
trending_up 8