Recent questions tagged VBA

0 votes

1.1k views

1 answer

vba - How can one iterate through the subfolders of a subfolder of a shared mail inbox folder?

Building up on this one, here, how can one iterate through the subfolders of a subfolder of the inbox folder of ... we'll find an answer. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Filter using array and xlFilterValues

I have written a code which defines an array and then uses that array as criteria to filter a range. ... ary, Operator:=xlFilterValues End With See Question&Answers more detail:os...

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

0 votes

773 views

1 answer

vba - Inserting a Unique ID in Specific Row Locations for Multiple IDs

I have a number of identical XML reports stored in excel. In these reports, each item in one of the tables ... above anywhere close to correct? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Cells.find error 91

I have problems with this code. I tried to figure it what is wrong with this code, but cannot find the solution ... what I need to do. Cheers 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 can I get a unique set of values?

Given some sort of collection of values (an array or a collection of some kind), how can I generate a set of distinct values? See Question&Answers more detail:os...

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

0 votes

733 views

1 answer

vba - To move the cell values in a group from right to left if any group of cells are blank using VBScript without using any Looping technique?

Is there any faster process to move the cell values in a group from right to left if any group of cells are ... output as desired.But too slow. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Excel Macro - Rows to Comma Separated Cells (Preserve/Aggregate Column)

Based on this Data: <- A (Category) -> <- B (Items) -> 1 Cat1 a 2 Cat1 b 3 Cat1 c 4 Cat2 d 5 Cat3 e 6 Cat4 ... c 2 Cat2 d 3 Cat3 e 4 Cat4 f, g See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Run an Excel Macro from SSIS

So Im busy making an SSIS package and I need to run a macro in an excel document, I just don't know VB or ... than what I am trying to do. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Run-time error 91 using Range.find

SOLVED Nathan_SAV had the right idea. For anyone looking at this for reference later I changed the code to For x = 3 ... 6 End If End If Next x See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Capturing keydown event of MS Word

I want to capture the backspace event, just do the backspace's action, then add other action, but I am not ... = "DefaultStyle" End If End Sub See Question&Answers more detail:os...

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

0 votes

882 views

1 answer

vba - How to get a particular InnerText from a specific class?

<tbody> <tr> <td> <a href="/denmark/1st-division/">1st Division 2016/2017</a> </td> <td> </td> </tr> ... i have to change the code? Thanks :) See Question&Answers more detail:os...

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

0 votes

786 views

1 answer

vba - VSTS - uploading via an excel macro and getting @mentions to work

I am using VSTS and would like numerous people to get sent the notification when a work task is created. I ... figured this out? Cheers Dave See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

vba - Error from VB excel macro code - msxml3.dll -2146697211 The system cannot locate the resource specified

I am using an MSXML.HTTPRequest object in a VB macro (excel) to communicate with an HTTP server. The problem is ... but that's not the case. See Question&Answers more detail:os...

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

0 votes

940 views

1 answer

vba - Loop through all worksheets in workbook

I want to repeat this code on all the worksheets in a workbook. There may sometimes be 1-2 worksheets sometimes ... Range("G1").Select End Sub See Question&Answers more detail:os...

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

0 votes

815 views

1 answer

vba - Faster Way to Import Excel Spreadsheet to Array With ADO

I am trying to import and sort data from a large excel report into a new file using Excel 2007 VBA. I ... insert data into the new worksheet. See Question&Answers more detail:os...

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

0 votes

813 views

1 answer

vba - Changing the formula of cell in all the sheets of the archive

I have an Excel archive that contains about 100 sheets i want write VBA macro so that cell A1 of each sheet will ... is a sheet of my archive See Question&Answers more detail:os...

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

0 votes

850 views

1 answer

vba - In a dual-monitor system, finding out on which monitor a PowerPoint slideshow is displayed

In Powerpoint 2007/2010 run on a multiple monitor system, we can select the monitor on which the slideshow will be ... . How can I do that? See Question&Answers more detail:os...

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

0 votes

784 views

1 answer

vba - Get corresponding Range for Button interface object

I want when I click the button "Sélectionner un poste" it will tell me the position. (The button which I ... Here is my example Excel sheet: See Question&Answers more detail:os...

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

0 votes

777 views

1 answer

vba - How to filter items sendername from Items_ItemAdd Events?

Private WithEvents Items As Outlook.Items Private Sub Application_Startup() Dim Ns As Outlook.NameSpace Dim Folder As ... and thanks in advance! See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Pasting Chart into Outlook Email from Excel

Tried all other codes on similar pages but failed to work. This is my current version. Works only if I ... Set OutApp = Nothing End Sub See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

vba - Find the Window handle for a Chrome Browser

I have found some code to bring the browser to the front, even if it was minimized. I don't however know how ... a chrome browser (using VBA)? See Question&Answers more detail:os...

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

0 votes

909 views

1 answer

vba - Deleting Duplicate Visible Rows

I am trying to use the following VBA code to do two things. Count the number of unique visible rows in a ... (D).Delete Next D End Function See Question&Answers more detail:os...

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

0 votes

827 views

1 answer

vba - Adding command buttons to worksheet at run time and also define events

I am trying to add an ActiveX command button in my work sheet at run time. The number of command buttons will depend ... me which row is it in. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - How do I keep the necessary decimal places when using the DoCmd.TransferText command to export a table to a .csv?

I am using the DoCmd.TransferText in MS-Access-2010 VBA to export a table to a .csv file. However ... .Path & "AllMetersAvgRSSI.csv" See Question&Answers more detail:os...

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

0 votes

935 views

1 answer

vba - Print certain pages only

I have the following code which works fine: Application.PrintOut FileName:="", Copies:=2 This prints my 10 page ... 2 and pages 6 through 10 See Question&Answers more detail:os...

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

0 votes

980 views

1 answer

vba - Drag a formula down with Row changes by another interval other than one

I have been trying to figure this out for hours now. I have this formula: =PROMEDIO.SI.CONJUNTO(Flankers!C15 ... modify it for future analyses? See Question&Answers more detail:os...

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

0 votes

759 views

1 answer

vba - Type mismatch when passing string variable into Variant parameter, and assigning result of Array function to parameter

I have the following two procedures: Sub OuterSub() Dim s As String s = "Lorem ipsum dolor sit amet" InnerSub s ... prm = Array((prm)) End Sub See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - runtime error 5854 string parameter is too long

I use following macro and sometimes it gives parameter is too long error. how can I solve it? Sub ... End If Next End Sub See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags