VBA
How do you select an image that was just pasted to MS Word via VBA
Just pasted an image to MS Word in VBA using the following wordApp.Selection.PasteSpecial DataType:=wdPasteMetafilePicture, Placement:=wdInLine[详细]
2023-04-10 22:18 分类：问答Change font size in form combo box in MS Excel
I need to change the font size in an Excel combo box because the default font size is way too small. Is there a way to do this?[详细]
2023-04-10 22:01 分类：问答How to distribute VBA code in Excel? [duplicate]
This question already has answers here: What is the best way to share/distribute Excel macro? [closed][详细]
2023-04-10 21:06 分类：问答Find method keeps on missing the search string in an excel's workbook using VBA?
I am searching for text/strings in an excel sheet provided by the customer. The problem is that sometimes the excel Find function works and sometimes it does not. For eg if the excel sheet looks like[详细]
2023-04-10 20:37 分类：问答Opening New File using VBA on Mac
I am using Excel 2011 for Mac and trying to open a new file. However, I keep getting an error that file not found even though the file is there. The code I am using is below:[详细]
2023-04-10 18:15 分类：问答Open Arbitrary File from Access VBA as Read-Only
I have an Access application that\'s currently using the fhandlefile() procedure here: http://access.mvps.org/access/api/api0018.htm[详细]
2023-04-10 18:09 分类：问答Generate a flat list of all excel cell formulas
I have a massive program written with VBA and cell formulas. I am tasked to reverse engineer it into C# winforms. I figured for a start, I need to see all the cell formulas in a flat list.[详细]
2023-04-10 17:14 分类：问答Finding Active cell's column header name using VBA in excel
I have a table created from List of data. How to find the header text of each column When I select the activecell\'s header is high lighted to orange but I want to retrieve that value using visual[详细]
2023-04-10 17:10 分类：问答Combine multiple exclusion (<>) criteria in AutoFilter
I have worked around my issue by using this dirty hack: \' Filter managerial functions ActiveSheet.Range(\"$A$1:$BW$2211\").AutoFilter Field:=36, Criteria1:=\"<>Head*\", _[详细]
2023-04-10 16:23 分类：问答Return an object in VBA
I\'ve built a custom DLL which, for this example, has a function login. In C++ I use it by creating an object and then accessing the function through the object pointer, like so:[详细]
2023-04-10 16:07 分类：问答
加载中,请稍侯......