VBA
Change font color for specific char in a cell range
I would like to change the font color for a specific character within a range of cells. I figured out how to do this for a single cell (code attached), but I can\'t figure out how to do it over a full[详细]
2023-04-13 09:35 分类：问答MSAccess Error: Class does not support Automation or does not support expected interface
The issue is that it\'s looking for the OLE Automation reference in C:\\Windows\\SysWOW64\\stdole2.tlb[详细]
2023-04-13 07:34 分类：问答if Excel Workbook is open then...... VBA
How could I write code to say. Dim xlApp As Excel.Application Dim xlWorkbook As Excel.Workbook Dim xlWorksheet As Excel.Worksheet[详细]
2023-04-13 07:32 分类：问答Preset the "save as type" field while using Application.FileDialog(msoFileDialogSaveAs) with MSAccess
I searched all over for a way to do this. I want to open a Save As dialog box so the user can choose the location to save a file. But, I want the \"Save as type\" field to be preset with \"comma sepe[详细]
2023-04-13 05:57 分类：问答Prevent user from deleting certain rows based on contents of a cell in that row
I have a template file that I want to protect so that users cannot modify formulas. As the sheet is protected, I have written a macro to allow the user to insert rows. I also want a macro to allow the[详细]
2023-04-13 05:41 分类：问答Setting VBA Excel Chart Legend Position Property in MS Access not working
This is a very strange issue I am facing for a while now, when creating some Excel worksheets programmatically from MS Access 2003.[详细]
2023-04-13 05:40 分类：问答How do I grab this integer from a date in VB?
txtDate = 3/7/1994 Basically I want my button to calculate the \'month\' digit (in this case 7) and display it into txtMonth.[详细]
2023-04-13 03:20 分类：问答Access: run-time error '2176' - The setting for this property is too long, but it is not
I\'m not an experienced vba programmer and working with access is not my cup of tea. I\'ve been asked to fix some errors in an MS Access 2010 VB application.[详细]
2023-04-13 02:33 分类：问答Visual Basic in Word 2010 - Open Dir - Relative Path
I\'m creating a word document and I\'m having trouble working out the code to open a specific directory.[详细]
2023-04-13 02:14 分类：问答Pushing 2-d Variant data into FormulaArray
I originally had a VBA function that returned a two dimensional variant array: Public Function SplitIntoCells(some_data As String) As Variant()[详细]
2023-04-13 01:27 分类：问答
加载中,请稍侯......