I have a VSTO add-in 开发者_StackOverflowthat is able to match against specific codes in the body of a document. The codes themselves are just strings that I syntactically match for validation.
I wrote macro in Excel that uses dynamic array. Users will add elements to that array. Is it possible to store elements permanently, so the elements will be available even after workbook was closed?
I have the following code, which should simply open a workbook from a master workbook to allow me to paste some information which I will later retrieve from a database. I receive the error in the titl
I want to get the PlotArea width and height in order to calculate t开发者_JAVA技巧he proportion.
I\'m using Access VBA to parse a string with regex.Here\'s my regex function: Function regexSearch(pattern As String, source As String) As String
I have a folder with over 200 Powerpoint files and I have been have been struggling with a Macro that opens each of these files, edits them, saves them and closes them in a loop.
I have the following script tha开发者_JAVA技巧t adds columns to and table in an Access database. I don\'t know how to set the \"required\" property of that column to \"NO\", the default is yes. Here i
Good morning. I have a Microsoft Excel Macro Enabled Workbook with two worksheets: let\'s say Sheet1 and Sheet2. In Sheet2 I have a combo box (form control) that works as a table sorter. This table wi
I am wondering if it is possible to add an image to a messagebox in VBA mainly, but if not 开发者_C百科any other languages.
I have a report that is dynamically generated depending on the button pressed on my main form, in order 开发者_运维知识库to change the filter, the query used, etc. I have DoCmd.Rename working to renam