Recent questions tagged vba

0 votes

856 views

1 answer

vba - How to put an ampersand in a header/footer in Excel?

I am working on a header which needs an ampersand to separate two words. Hello & World But it ignores the & ... escape an ampersand in a header? See Question&Answers more detail:os...

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

0 votes

666 views

1 answer

vba - Potential Duplicates Detection, with 3 Severity Level

I wanna make a program that detect a potential duplicates with 3 severity level. let consider my data is only in two ... how to do this in VBA? See Question&Answers more detail:os...

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

0 votes

783 views

1 answer

vba - Reference an excel sheet from another workbook without copying the sheet

Im wondering if it's possible to reference an excel sheet from another work book without making a copy of ... from a different workbook? Thanks See Question&Answers more detail:os...

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

0 votes

673 views

1 answer

vba - How do I make a "setAlwaysMoveConversation" that works properly?

In Outlook, if I activate "always move messages in this conversation", it will: Move all of the ... alwaysMoveMessages" function? Thank you! 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 populate an array from text file in Visual Basic for PowerPoint 2010

I'd like to define an array like: sample_array = Array( _ "foo", _ "bar", _ ... "dog", _ "cat ... ascii strings) directly into an array? Thanks! See Question&Answers more detail:os...

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

0 votes

863 views

1 answer

vba - Copy Text from Range in Excel into Word Document

how do you: 1) copy text from a range in an Excel Document. 2) Open a Word Document. 3) inserts the ... Nothing Set wrdApp = Nothing End With See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - VBScript GetElementsByClassName not supported?

I am trying to convert some of my working VBA code to VBScript, but keep getting errors in VBScript when trying ... this to work in VBScript. See Question&Answers more detail:os...

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

0 votes

815 views

1 answer

vba - IE 9 not accepting SendKeys

I posted on IE 9 not accepting SendKeys to download a file, but this problem is separate enough from the ... IE would be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

872 views

1 answer

vba Excel 2010: convert string array into int array

Dim myarray(2) as Variant myarray(0)="3" myarray(1)="4" myarray(2)="5" myarray(3)="9" I want ... stringArray , Function(str) Int32.Parse(str)) See Question&Answers more detail:os...

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

0 votes

762 views

1 answer

vba - generating a random number between 1 and 20

The code I previously used was Randomvariable = 1 + Int((20 - 1 + 1) * Rnd()) I'm a bit concerned it ... + 1 Was my way equivalent to this? See Question&Answers more detail:os...

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

0 votes

833 views

1 answer

vba - How to reverse a For loop

I have a problem with my macro. It deletes row that fullfil certain criteria. But when few consecutive rows ... best regards, Artur Rutkowski See Question&Answers more detail:os...

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

0 votes

758 views

1 answer

vba - Printing faster in Excel

The print functionality of Excel (using VBA) is extremely slow. I'm hoping someone has a way of ... .PrintOut Application.ScreenUpdating = True See Question&Answers more detail:os...

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

0 votes

909 views

1 answer

vba - How to create controls at run time Access VB?

How can you create controls at run time with VB code in Microsoft Access? after some digging I found ... will greatly help my understanding. See Question&Answers more detail:os...

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

0 votes

849 views

1 answer

vba - How can I use VBScript to effectively refresh the external data of several Excel spreadsheets?

I have a macro in one XLSM workbook's module that refreshes all the external data, then saves and closes that ... in the VBScript file) TIA. See Question&Answers more detail:os...

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

0 votes

768 views

1 answer

vba - How can you run an Excel macro through a schedule task

I need to run a macro in an Excel spreadsheet through a schedule task. I've defined the job as below: "C ... to manually click on enable macro? See Question&Answers more detail:os...

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

0 votes

914 views

1 answer

vba - Import CSV files into Excel

I would like to ask for your help with the following: I have CSV files exported from a software application ... help will be much appreciated. 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 to Launch an Excel macro from command line (Without Worksheet_Open Event)?

Is it possible to launch an Excel Macro from command line? I don't want to use the Worksheet_Open event and ... exists in the Excel WorkBook. See Question&Answers more detail:os...

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

0 votes

695 views

1 answer

vba - How do optional Parameters in Let/Get Properties work?

I am using vba with Excel 2007, and am writing code for a class module. 1) Is the following code even ... accept a parameter into an object? See Question&Answers more detail:os...

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

0 votes

749 views

1 answer

vba - Hide Access Options

I have noticed that even though when you disable the Use Access Special Keys , disable the Display Navigation ... in Access 2007 and 2010? See Question&Answers more detail:os...

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

0 votes

954 views

1 answer

vba - autofill down according to adjacent column

I'm looking for VBA code that will autofill data down according to the length of an adjacent column. I know there ... it so what am I missing? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Decimal to binary conversion for large numbers in Excel

I have some large numbers in an Excel sheet and I want to convert them to binary. e.g. 12345678 965321458 -12457896 See Question&Answers more detail:os...

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

0 votes

835 views

1 answer

vba - How to align duplicates on the same rows in Excel

This is a simple question that I cannot answer. I have two columns like these in Excel: Col1 Col2 A C B I C ... a little help? Thanks a lot. See Question&Answers more detail:os...

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

0 votes

793 views

1 answer

vba - How to activate a specific worksheet in Excel?

I just need to activate a certain worksheet. I have a string variable that keeps the name of the worksheet. See Question&Answers more detail:os...

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

0 votes

772 views

1 answer

vba - How can I color dots in a xy scatterplot according to column value?

Consider the following worksheet: A B C D 1 COMPANY XVALUE YVALUE GROUP 2 Apple 45 35 red 3 Xerox 45 38 ... How can I do this automatically? See Question&Answers more detail:os...

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

0 votes

976 views

1 answer

vba - Refer to Excel cell in Table by header name and row number

I'm trying to refer to a cell in an excel table by using the table header name and the row number using VBA. How can I do this? See Question&Answers more detail:os...

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

0 votes

721 views

1 answer

vba - Return multiple values from a function, sub or type?

So I was wondering, how can I return multiple values from a function, sub or type in VBA? I've got this ... I return multiple ones to a sub? See Question&Answers more detail:os...

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

0 votes

760 views

1 answer

vba - Unmerging excel rows, and duplicate data

I have been given a fairly large database stored in Microsoft Excel, which I have to try convert into something ... ! Any help is appreciated. See Question&Answers more detail:os...

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

0 votes

977 views

1 answer

vba - Fill blank cells (Variation)

I have an issue with filling blank cells of a column. I have 3 Column headings in A, B, C. Under that I have ... where the last "A" value is. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags