Recent questions tagged VBA

0 votes

1.5k views

1 answer

vba - With a Word ContentControl DatePicker how do i get the value?

I have a ContentControl that is a DatePicker in a word document. I'm trying to use it to populate ... date from the DatePicker ContentControl? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Instead of typing up a bunch of "Or" statements, how can I implement a function in this code?

Sub test() Dim DataRange As Range Dim LastRow As Integer Dim i As Integer Dim SplitVal() As String Dim ... function? Thanks so much everyone! 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 list all files of a given folder (recursively through sub-folder)?

I'm writing a microsoft word macro and having difficulty with vb.net. Please help. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Dictionary is populated with an empty item after checking dictionary item in watch window

Recently I've encountered a rather odd dictionary behaviour. Sub DictTest() Dim iDict As Object Dim i As ... empty item in the dictionary? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

vba - Looping through report filters to change visibility doesn't work

I'm trying to select one report filter, in this case Canada. That means the rest must be made invisible. This ... that and got the same error.) See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Email Macro Pauses every 40 - 50 emails

I have a semi-working macro that Loops through a list of Managers Generates a email body for each manager ... TempWB = Nothing End Function See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Merging excel spreadsheets into one spreadsheet

Okay, I tried to look for similar questions but I didn't understand much of what was being discussed since it's the ... . Let me know if I did! 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 Programmatically Wait For Shell Command To Finish Running?

I am sending emails in a program like so: Call Shell(smtpPath, emailInput...) This works great, except if I call ... , sleep it, then try again? 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 import a zipped csv hosted online into Excel

I have a simple link www.example.com/file.zip Inside there is a csv file There are no login forms required to ... ? (All via one button VBA) See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Finding the Last Row and using it in a formula

I am dealing with a sheet of data that has multiple rows ans columns. Each time the macro runs, the number of ... TIME SERIES'!D2-1" 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 - How to copy tables from multiple Word files to separate worksheets in Excel, naming the worksheet the name of the Word doc?

I have used the VBA macro below to put multiple tables from multiple Word documents into one worksheet in Excel. ... WordApp = Nothing 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 - Reference a folder by name

I need to get a folder by name, not by folder number counts. I tried getting with various methods. ... Session.GetDefaultFolder("Vijay Baswal") See Question&Answers more detail:os...

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

0 votes

923 views

1 answer

vba - Find a string in a document and delete everything after it

I want to find a string in a word document and delete everything after it. What is the best way to do this without using the Selection object? See Question&Answers more detail:os...

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

0 votes

942 views

1 answer

vba - Does Excel have a built in method for parsing formulas? (ie: to obtain a list of included RANGE references)

For a given Excel formula in a cell, I'd like to be able to parse the formula in order to get ... .com/develops/2004/12/excel_formula_p.html 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 delete entire row when case sensitive duplicates are found in Excel (for 100k records or more)?

This is a follow up question from How to remove duplicates that are case SENSITIVE in Excel (for 100k records ... cASE1 Are all unique records. 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 Copy shapes from one worksheet to another

I am trying to use a macro to copy all the shapes (images) from a worksheet to another. I used the record ... don't know the name of shapes. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Drag file into Access, how to check the file details?

I like to drag a file from Windows Explorer or an attachment from an Outlook mail into MS-Access. I discovered ... want to do. Any ideas? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

vba - Set Email Flag Status in Outlook 2007

Is there a way in Outlook 2007 to set a follow-up flag on an email object? It looks like it was supported in ... I can't find it in 2007. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

vba - Pulling data from SAP using Excel Macros

So I am trying to pull data from SAP using excel macros. I am new to VBA so please bear with me. I found a ... an act of God to get it fixed. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Loop through each word in a word document

I know how to get every paragraph in a word document. But I am looking for a way to loop through each ... .Print lineText Next apara End Sub See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Not understanding why WinHTTP does NOT authenticate certain HTTPS resource

I'd be extremely grateful for any kind of help that may help me resolving the problem. From Excel VBA code ... in advance for your suggestions! See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Excel macro "Run-time error '1004"

I am new to scripting and I am trying to improve a existing Macro. I recorded a macro to remove dupliate and ... :=xlNo End Sub Thanks, Kiran See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Copying strings over floats in 'Do While' loop

I'm attempting to create a macro that copies a string over a float/integer in the next few cells ... .com/photos/hillsindustries/12198631954/ See Question&Answers more detail:os...

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

0 votes

945 views

1 answer

vba - combo box to select value w/ multiple duplicates & populating textbox in form w/ value from each duplicate record, line by line?

I'm currently trying to do as said in the title, but cannot find a reliable and working vba code to use. The ... I could think of. Thank you! See Question&Answers more detail:os...

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

0 votes

959 views

1 answer

vba - Transpose a set of values in rows to columns in Access 2010

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

0 votes

1.0k views

1 answer

vba - Skip one worksheet and process the remaining worksheets

I was working with a vba code which remove all the rows which dont have word "Statement No" in it from all ... True End Sub Thank you All! 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 to copy rows to new sheet(s) based on column value

My query is below: Each month my telecom provider gives me an excel list of all subscribers in the following ... for your very kind help. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Check a range is not the entire sheet?

I have this function which is trying to detect when a particular cell value changes. The problem is, if the ... clear the whole worksheet etc)? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags