Recent questions tagged vba

0 votes

875 views

1 answer

vba - How to Trap Outlook Events from Excel Application

I have a workbook that at least 15 people use and update periodically that contains client information with emails ... Any help is appreciated! See Question&Answers more detail:os...

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

0 votes

922 views

1 answer

vba - Com DLL In VB6?

I have a class in an Excel file and my boss wants me to create that class into a COM DLL. I don't want ... direction and help me out with this? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Worksheet change event for every sheet in the workbook

Is there a way to globally install a change event that triggers on every single sheet? I have a workbook ... module didn't Trigger anything. See Question&Answers more detail:os...

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

0 votes

816 views

1 answer

vba - Reading data from text file and delimiting

I have an Excel 2010 spreadsheet, and I am reading in information from a .txt file (and another .xls file in ... me like a novice for this. See Question&Answers more detail:os...

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

0 votes

869 views

1 answer

vba - Customizing the PowerPoint Ribbon at Run-Time

I am developing a PowerPoint add-in and would like to temporarily disable some of the Ribbon controls while ... applicable to Visual Studio? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Rule that runs macro when an email is opened

I have created a macro, that does certain things, to an opened mail. I would like to create a rule, that does ... rule on each mail I receive. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Select first visible cell directly beneath the header of a filtered column

I am trying to select the first visible cell directly beneath the header of a filtered column. The code I am ... 3)" Selection.FillDown End Sub See Question&Answers more detail:os...

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

0 votes

800 views

1 answer

vba - Event Handler for switching from other applications to Excel?

I want to activate a workbook when switching from other applications. I'm using Excel 2010. In the ThisWorkbook ... this workbook is not active. See Question&Answers more detail:os...

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

0 votes

939 views

1 answer

vba - How to access the label of a control in code

Often a label control is bound to a textbox or similar other control. I know that there is a way to access the ... the user where the error is. See Question&Answers more detail:os...

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

0 votes

940 views

1 answer

vba - How to format column to number format in Excel sheet?

Below is the VBA code. Sheet2 contains all of the values in general format. After running the code, values in column ... 1 End If Next End Sub See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Excel trailing comma bug in csv files

I have an XLS file creates a CSV file with a macro on Excel 2003, I have 40+ columns and the last 3 ... feasible to change the whole process. See Question&Answers more detail:os...

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

0 votes

991 views

1 answer

vba - Which way is faster? If elseif or select case

For the following code, If Sheets("sheet1").Range("A1").Value = "option_1" Then Sheets("sheet1").Range("A1" ... way to circle value from array? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Mod with Doubles

Am I doing something wrong or does the VBA Mod operator actually not work with floating point values like ... solves my particular issue. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Removing All Spaces in String

I created a macro for removing all whitespace in a string, specifically an email address. However it only removes ... , but are skipped over. See Question&Answers more detail:os...

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

0 votes

829 views

1 answer

vba - Very large excel file - how to copy data between sheets?

I need to to import some csv files into excel 2010 and create a very simple, but very large database. The whole ... be the size of the file? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Saving webpage as PDF to certain directory

I have it where it will open Internet Explorer give the user the save as box and then exit. However, I would ... Quit Set IE = Nothing End Sub See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

vba - Downloading Images from URL and Renaming

I have an excel sheet with 2 columns, A and B. Column A has a name, and column B has the image ... appreciate and love any help regarding this! See Question&Answers more detail:os...

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

0 votes

908 views

1 answer

vba - Linked Table in MS Word

I would like to refresh Excel tables in a Word template report programmatically using VBA. The tables are written to ... is done as shown below: See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Clicking a hyperlink in Excel to set autofilter on a different sheet

I have an Excel workbook with two sheets, basically a one-to-many setup between the two sheets. The first sheet ... to solve this. Many thanks. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - How to make Microsoft Web Browser object work in Excel 2016

When I try to insert it, I constantly get the "Cannot insert object" error. It seems to be a known issue ... this work? Here are screenshots: See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Create a query dynamically

Hi I need to create a query in MSAccess 2003 through code (a.k.a. VB) -- how can I accomplish this? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Selecting multiple sheets using a range

I have sheet names in cells C2 to C5, which are dynamic. I would like to select them at the same time using ... "Sheet3","Sheet4","Sheet5" etc. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Class_Terminate not firing on object from form

I have a very simple form, that uses a very simple class to handle some things. And that class has a ... hard-crashes without any error message! See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - How to run a macro in Word before save?

How to make Microsoft Word to run a VBA macro every time before any document is saved? Could it be done ... macros into the document itself? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - How to check if a Paragraph is in a Table or not in MS-Word macro?

The paragraph object in the Word has a property called Range. Within this Range object has a property called Cells. ... I test for this? thanks See Question&Answers more detail:os...

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

0 votes

884 views

1 answer

vba - How to get property values of classes that implement an interface in the Locals window?

This is really bothering me and hindering my development/debugging. Whenever I declare a variable type of the interface ... y.Name Stop End Sub See Question&Answers more detail:os...

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

0 votes

915 views

1 answer

vba - Schedule Outlook 2003 Macro

I have an Outlook 2003 macro written in VBA. I would like to schedule it so that it automatically runs at a ... which suggests how to do this. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Compile error: End If without block If

I am currently running the below loop to pull out information from another spreadsheet, but keep getting the following ... If End If Next r See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags