Recent questions tagged VBA

0 votes

856 views

1 answer

vba - Faster way to delete rows 40k+ rows at once

Is there a faster way to delete rows ? I just need to delete rows with odd row numbers from row 3 to ... If Next toDelete.Delete shift:=xlUp See Question&Answers more detail:os...

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

0 votes

681 views

1 answer

vba - Sort range without sorting it in a spreadsheet

Question is about sorting data in VBA. Suppose I have a Range("A1:A10") which I want to sort in ... Has someone ideas about this problem? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - InfoBox.Popup Refuses to Close on Timer Expiration

Cobbled this test procedure together in an Outlook 2013 module from other posts, which should display a popup box, ... Sub End Select End Sub See Question&Answers more detail:os...

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

0 votes

645 views

1 answer

vba - MS Access / Outlook 2010 - how to choose which account to send email from?

I am trying to send emails from a specific account but it always sends from my main no matter how much ... Set olAccountTemp = Nothing 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 - Import lines of code

Can we read scripts or lines of code to a module in vba? Like we have the include function in php. ... another macro and pass the parameters. See Question&Answers more detail:os...

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

0 votes

662 views

1 answer

vba - Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

I am trying to use the ADO to read in a series of text files into a worksheet. I am running into problems when the majority ... P,0 1,1 5,2 6,3 See Question&Answers more detail:os...

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

0 votes

694 views

1 answer

vba - How do you extract email addresses from the 'To' field in outlook?

I have been using VBA to some degree, using this code: Sub ExtractEmail() Dim OlApp As Outlook.Application Dim ... the 'To' Textbox. Thanks See Question&Answers more detail:os...

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

0 votes

764 views

1 answer

vba - Overflow when multiplying Integers and assigning to Long

If I type the following into the immediate window I get Runtime error '6': Overflow. MsgBox 24 * 60 * 60 ... 60 = 86400 should comfortably fit. See Question&Answers more detail:os...

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

0 votes

614 views

1 answer

vba - How can I post-process the data from an Excel web query when the query is complete?

As a spreadsheet developer, I am trying to stitch together two sets of rows: one from a web query to a web ... there another way to do this? See Question&Answers more detail:os...

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

0 votes

731 views

1 answer

vba - excel indirect function to read dates and return dynamic values

looking through the forum and can't find what I need. I have 100+ sheets with unique sheet names and data ... maybe a vlookup wrapped around it? See Question&Answers more detail:os...

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

0 votes

926 views

1 answer

vba - How to add an embedded image to an HTML message in Outlook 2010

I have Office 2003 VBA code that uses the technique described here to embed an image in an HTML message using ... the Outlook 2010 object model? See Question&Answers more detail:os...

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

0 votes

894 views

1 answer

vba - Application.Quit command not closing the entire Excel Application

I have following code under a button. When clicked it just closes the current Excel sheet but not the ... The following window still appears. See Question&Answers more detail:os...

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

0 votes

672 views

1 answer

vba - How do I avoid run-time error when a worksheet is protected in MS-Excel?

The code snippet below changes the data validation state of a cell and runs when the Excel-2003 worksheet is unprotected ... code ' ... End With See Question&Answers more detail:os...

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

0 votes

685 views

1 answer

vba - Hiding active workbook programmatically in Excel

I'm working on a VBA project based in a workbook. The code opens a new workbook and calls an external ... prevent this from happening? Thanks! See Question&Answers more detail:os...

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

0 votes

621 views

1 answer

vba - How to stop ActiveX objects automatically changing size in office?

This thread discusses a problem I've been having with ActiveX objects in an Excel spreadsheet. It's a mess ... much prefer a better solution. See Question&Answers more detail:os...

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

0 votes

804 views

1 answer

vba - Working with current open email

I would like to get the active opened MailItem (whether it's a new mail or a received mail) ... Application.ActiveInspector.currentItem End Sub See Question&Answers more detail:os...

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

0 votes

705 views

1 answer

vba - Iterating through files in folder via FileSystemObject

Ok, so I consider myself an Excel VBA expert (even though I've not done much with it for a while) but I'm ... "For Each" method hasn't worked. See Question&Answers more detail:os...

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

0 votes

728 views

1 answer

vba - Is it possible to use auto-filter or find on a dictionary?

so I have a userform with comboBox serving as a dynamic-search box. The data needed to be searched is located ... Set emplDict = Nothing End Sub See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - How to filter listbox values based on a Textbox value

I have a textbox and a listbox on userform. I want to filter the values in listbox based on the value I enter in ... = i + 1 Next fCell End Sub See Question&Answers more detail:os...

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

0 votes

686 views

1 answer

vba - Loop through cells and add to a range

How would I loop through cells B1 to J1 and add them to a range if they meet a certain criteria. For example ... to Range1. Thanks for the help! See Question&Answers more detail:os...

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

0 votes

741 views

1 answer

vba - Debugging an Outlook 2007 script fired by a rule

I'm trying to debug an Outlook 2007 VBA script that's fired by a rule. I've set a breakpoint in the ... get the script to stop on breakpoints. See Question&Answers more detail:os...

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

0 votes

707 views

1 answer

vba - Escaping ' in Access SQL

I'm trying to do a domain lookup in vba with something like this: DLookup("island", "villages", "village = ... same. Have I missed something? See Question&Answers more detail:os...

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

0 votes

654 views

1 answer

vba - How to highlight selected text within excel

I would like to write a VBA function to highlight specific text within an excel cell. Is this possible? I've been ... = vbRed End If End Sub See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - ms access browse for file and get file name and path

I am using ms access and i want to add a button to browse for a file, get the name of the file and ... Right$(strPath, 1) End If End Function See Question&Answers more detail:os...

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

0 votes

853 views

1 answer

vba - Excel - Using COUNTIF/COUNTIFS across multiple sheets/same column

I am trying to "COUNT" the number of a certain object in column I (in this instance) across multiple sheets. ... advance for your time and help. See Question&Answers more detail:os...

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

0 votes

881 views

1 answer

vba - To find and replace a text in the whole document in MS Word 2010 (including tables)

I have an MS Word document including a table. I am trying to find and replace text via VBA using the ... of the content within the table. See Question&Answers more detail:os...

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

0 votes

779 views

1 answer

vba - What's the difference between Dim As New vs Dim / Set

In VBA, I can create objects one of two ways: 'First way Dim myCol1 As New Collection 'Second way Dim ... between the myCol1 and myCol2 objects? See Question&Answers more detail:os...

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

0 votes

840 views

1 answer

vba - Check if a certain pdf file is open and close it

I use this code to export a pdf file from a word document. Before exporting I need to check first if a ... = Nothing Set adbPageView = Nothing See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags