Recent questions tagged VBA

0 votes

1.3k views

1 answer

vba - OLEObject Height and Width are not consistent

I am currently attaching PDF files and images to my excel sheet as OLE Objects, and trying to control the size ... 15 End Select Next End Sub See Question&Answers more detail:os...

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

0 votes

776 views

1 answer

vba - Insert Data from Excel into Access

I've made some code to insert data from an excel table in to an access database - my code is as follow ... . Any help is much appreciated. See Question&Answers more detail:os...

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

0 votes

832 views

1 answer

vba - Function to count distinct values in a column range

I am attempting to create a function in VBA that, when given a range of values, will return a Count Distinct of ... values in column A == 6. See Question&Answers more detail:os...

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

0 votes

935 views

1 answer

vba - Using Pre-Made Stringbuilder Class

I am trying to learn how to use stringbuilder functions in VBA, but am having trouble finding resources ... , m_strDelimiter) End Function See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Check if value exists in range without looping

I'm used to python syntax where to check if 7 is in list1 you simply type 7 in list1 and it returns a ... 2).EntireRow.Delete End If Next i See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

vba email embed image not showing

I have an odd experience here. I have had loads of problems embedding a logo or image to emails using the src= ... Set oApp = Nothing End Sub See Question&Answers more detail:os...

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

0 votes

812 views

1 answer

vba - Can I use / access the app.config from .net code, when called via COM

I have an existing set of .net libraries that I wish to call from Excel VBA (that part is working fine). These ... + "'", vbOKOnly 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 - Automation error when getting ReadyState of InternetExplorer object

I get two different errors on the same line. Sometimes this one: Automation error: object invoked has disconnected from ... How do I fix this? See Question&Answers more detail:os...

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

0 votes

842 views

1 answer

vba - Copy cells between workbooks

Could someone please help me with some VBA code. I am trying to copy 2 ranges of cells between workbooks (both ... Next iRow End With End Sub See Question&Answers more detail:os...

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

0 votes

853 views

1 answer

vba - VLOOKUP by Combining 2 Columns to Form a Unique Key

For the following table, I want to look up the value in col C. Since the values in col A and col B ... in combinations of numbers and strings. See Question&Answers more detail:os...

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

0 votes

901 views

1 answer

vba - Is there a way to see which filters are active in Excel, other than just the funnel icons?

This question is actually for the Excel GUI, rather than Excel "programming", per se. However, if this is ... are actively filtered. Thanks. See Question&Answers more detail:os...

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

0 votes

957 views

1 answer

vba - Determine Object Type

Is there a way to determine the Object type, when passing a reference to a function? I'm using a security permissions ... a way to do that? MTIA See Question&Answers more detail:os...

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

0 votes

873 views

1 answer

vba - Programmatically determine if a named range is scoped to a workbook

I am attempting what I thought would be a fairly simple vba statement to test whether a named range is scoped ... get this to run successfully? See Question&Answers more detail:os...

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

0 votes

931 views

1 answer

vba - Programmatically determine if a named range is scoped to a workbook

I am attempting what I thought would be a fairly simple vba statement to test whether a named range is scoped ... get this to run successfully? See Question&Answers more detail:os...

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

0 votes

794 views

1 answer

vba - Write each Excel row to new .txt file with ColumnA as file name

I would be extremely grateful for any help as I have just begun to look into writing Excel macros. I have ... files Thank you for any help! See Question&Answers more detail:os...

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

0 votes

892 views

1 answer

vba - Events IE11 on change

My code launches an IE 11 page, clicks on a link and then attempts to fill in two dropdown lists. The first ... </option></optgroup></select> See Question&Answers more detail:os...

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

0 votes

901 views

1 answer

vba - pasting from excel into a word document

i am copying cells from excel into an open word document. the way i am doing this is just copying the contents ... only on the paste of a blank See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Passing arguments from command line in excel 2010

I have found several snippet of code out there that allows me to pass arguments into excel from command line ... this error : Outside procedure See Question&Answers more detail:os...

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

0 votes

852 views

1 answer

vba - Detect whether cell value was actually changed by editing

Worksheet_Change triggers when a cell value is changed (which is what I want), but it also triggers when you enter ... 's something I'm missing. See Question&Answers more detail:os...

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

0 votes

802 views

1 answer

vba - Fastest way to read a column of numbers into an array

Say if I have a column of numbers (how many of them could vary, but could be anywhere between 1000-10000) and ... way that's faster than 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 - If Statement With Multiple Lines

I have an if statement with multiple conditions. I cannot see them all in a single window view. Is there a way ... be written all in one line? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Copy files with progress bar

So I am trying to do something in visual basic I start learning but still that is not enough. Mostly I am ... used some parts to make this work See Question&Answers more detail:os...

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

0 votes

885 views

1 answer

vba - Collection Object - ByRef - ByVal

I am using VBA in Access 2013. In a regular module there are 2 procedures, RunProc() and PopulateCollection() ... altered 'how would I proceed? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Using base64 data stored in CustomXMLPart as image in Office

As a followup to this question about using images stored in an Excel file on a button in the ribbon: Is it ... will only load files from disk). See Question&Answers more detail:os...

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

0 votes

876 views

1 answer

vba - How To Deploy Word 2010 Macros To Others?

I have a macro that I developed in Word 2010. How do I send this to others to use? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Determine if application is running with Excel

Goal Have an Excel file with a "Search" button that opens a custom program. This program is used for researches. If ... put the focus on it... See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - What is a story?

In MS Word VBA, what is the unit of measure "Story" and where does it fit into the hierarchy of units in ... that explain what I'm looking for. See Question&Answers more detail:os...

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

0 votes

931 views

1 answer

vba - Funny notation with #

what does this mean? if CDbl(Trim(Range("M" & r).Text)) > 0# then... what does the # do?? and what does cdbl do? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags