Recent questions tagged VBA

0 votes

701 views

1 answer

vba - Excel filter a column by the first letters for more than 2 values

I am very new at vba, and now fighting with one macro which will filter a Column by the first exact ... ), Operator:=xlFilterValues End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

896 views

1 answer

vba - How to save a Unicode character to a text file

This is in Word for MAC VBA. I want to save the Unicode character from a text box to text file. For ... text file with the Unicode format? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

646 views

1 answer

vba - Row data for specific column headers based on row ID

I have a worksheet with a few hundred rows of employee data. At its most basic level it lists EmployeeID' ... . Example of spreadsheet layout: See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

737 views

1 answer

vba - Excel Fully Qualifying Range (Cells(),Cells())

I know many people have talked about fully qualifying ranges. I just want to know how deep you need to go ... second way is more trustworthy! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

866 views

1 answer

vba - Excel 64-bit and comdlg32.dll custom colours

I'm trying to adapt the code in either here or here to open the custom colour palette in Excel 2010 ... imageshack.us/img851/2057/unlednvn.png See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

725 views

1 answer

vba - MS Access Form Bound to ADO Disconnected Recordset

I seem to be clueless on this subject. I can attach an ADO recordset to a form, but I am not sure how ... modified records for logging? End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

vba - How to get selected value in multicolumn listbox

I have a multicolumn listbox in my userform and I would like to get all the values of the elements which ... = ListBoxResultatFind.Text End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

770 views

1 answer

vba - Get shape by Id or Name

Is there any way to get a shape if you know its Id? For example: Dim myshape As Shape myshape.Id = ... " myshape = getShapeByName(myshape.Name) See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

709 views

1 answer

vba - Recent rash of Microsoft Access database files in an inconsistent state

A large number of our clients operating a split front end/back end Microsoft Access application we built are ... anybody else encountered this? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

698 views

1 answer

vba - Write large collection object (parsed from json) to excel range

I am trying to convert a json api to excel table. I tried different parsing methods but currently using VBA-JSON ... work, how would it perform. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

675 views

1 answer

vba - Weird behaviour of NOT

I'm experiencing some weird behaviour of boolean variables; the following code prints both "Hello" and "There", meaning ... do I get around it? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

739 views

1 answer

vba - Update an Access linked table to use a UNC path

I have an Access 2010 database A.mdb with a list of tables, one of which is a linked table, linked from another ... write a "Module"? "Macro"? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

783 views

1 answer

vba - How can I check if a string only contains letters?

I'm using a function that allows me to review a string of text and evaluate if it is composed of letters. ... SetFocus Exit Sub End If End With See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

vba - Can't add items to a combobox

I have tried these sites for help: excel-easy.com sitestory.dk ozgrid.com stackoverflow.com contextures.com microsoft. ... " End With End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

697 views

1 answer

vba - Does the bitness of the OS ever matter, or is it just the application I need to worry about?

Some assumptions: (correct me if wrong) Ignoring 16-bit stuff, VBA can be run on 32 or 64-bit Office hosts. ... is running on 64-bit Windows... See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

800 views

1 answer

vba - Excel.Application.Cells.SpecialCells(xlCellTypeLastCell) returning bottom of worksheet, not last data cell

I'm writing a method in VBA in Excel 2013 to loop through the rows in two worksheets and compare the text in a ... into a new one. Any ideas? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

661 views

1 answer

vba - Rich text format (with formatting tags) in Excel to unformatted text

I have approx. 12000 cells in excel containing RTF (including formatting tags). I need to parse them to get to ... in the right direction. TNX! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

vba - Restrict Outlook Items by Date

I have an Outlook macro that filters email objects by date and returns items based on an array. The filter for ... do not return any errors. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

827 views

1 answer

vba - Trying to open a Workbook and a run a macro in that file

I have a workbook which opens up another workbook (filename is based on a cell value) and then runs a macro ... Run ("Single_sector") End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

874 views

1 answer

vba - Modeless form that still pauses code execution

Is there anyway to have a userform that acts modeless, while still pausing code execution like a modal form? I'd ... after the user form is done See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

667 views

1 answer

vba - how to build parent-child data table in excel?

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

902 views

1 answer

vba - DoEvents doesn't do the events... Why?

I'm using DoEvents to force an update of a progress indicator in the status bar (or in some cell in the ... //Turn on screen updating End Sub See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

756 views

1 answer

vba - How to change value of an item of a collection

With this code (in excel-vba) I add to a collection a number of items depending on an array. I use the value ... ) Coll("String1") = "myString" See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

740 views

1 answer

vba - Getting a value from the update query prompt

When we run a update query we get prompt saying that 'these many records are going to be updated. do you ... of records going to be updated. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

vba - Excel - Copy Conditional Formatting, Remove Rules, Keep Format

I know you usually show what you've tried in a question, but this is more of a "Do you have a good routine ... share?? (Excel 2010) THANKS!!!! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

716 views

1 answer

vba - cycling through values in a MS Access list box

I have a list box that populates with different sets of data based on user selections. How can I cycle through ... For Each statement, or what? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

vba - Check if ADODB connection is open

I use the following from within some excel procedures to establish a connection to our database. Private Const ... Error Resume Next rs.Close See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

859 views

1 answer

vba - Return background color of selected cell

I have a spreadsheet which cells in are colored meaningfully. Does any body know how i can return the ... current cell in Excel sheet? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags