Recent questions tagged vba

0 votes

977 views

1 answer

I found numerous examples of VBA scripts to automatically move attachments to my hard drive. This one I've found ... objOL = Nothing 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 - Convert a string containing hours, minutes, seconds to decimal hours

I have an automatically generated Excel sheet that has a column containing string values representing time spans. The values ... can I do that? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Run time error '1004' Unable to get the Match propertyof the WorksheetFunction class

In my macro, I have the following code : i = Application.WorksheetFunction.Match(str_accrual, Range(Selection, ... error doesn't appear. See Question&Answers more detail:os...

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

0 votes

953 views

1 answer

vba - Deleting Worksheets Based on Multiple Worksheet Criteria

I am continuing to build on macros related to data retrieved from mainframe, similar to what is mentioned in my ... regard to this list issue. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Get a WeekNumber's end date using excel macro

I have 3 columns: Year, Weeknum, WeekRange. i'd like the WeekRange column to display the Start and End Dates ... Appreciate any help i can get. 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 button to change change cell values

Any ideas on how to get a button to change cell values based on a table. Say cell A1 is the active cell and i ... Range("B1:B10").Value End Sub 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 query combo box of only current record/row in Access data entry form?

I have created a data entry form in Access that uses combobox for entering farmer name. The combobox is used for ... .name" End If 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 - Sending an auto-filled Outlook email template from Excel with multiple cell text body and additional text formatting

I have an email template saved in Outlook. I send this email out many times a day. Each email I send is ... copy, I need to CC someone. See Question&Answers more detail:os...

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

0 votes

984 views

1 answer

vba - Loop Pivot Table Filter based on values in column

very new to this but I'll try to make my question simple to understand. I have an Excel sheet with a pivot table ... I want to save the file as. See Question&Answers more detail:os...

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

0 votes

884 views

1 answer

vba - Using code to delete code

I have googled this and found multiple solutions for this but none of them have worked for me. I am ... . ActiveWorkbook.Close False 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 - Refresh entire Excel workbook (all data connections and calculations) every 15 minutes?

I have the following macro to refresh my workbook. This is the same as clicking on the refresh all ... () ActiveWorkbook.RefreshAll End Sub See Question&Answers more detail:os...

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

0 votes

955 views

1 answer

vba - Open Hyperlinks in Access

I have a table of products where there is say a pdf for a specific products user manual. I'm storing ... Any help would be greatly appreciated! See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

vba - Refresh MS Access Form/Query Based On Combobox Value

Pretty simple explanation. I have a table with 10 entries, 5 entries with the year 2010 and 5 entries with 2011 ... form, all done within 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 - Add Module code of BeforeDoubleClick_event to dynamically created worksheets

I have this code: For a = 1 To 5 strFoglio = "SheetName" & a Sheets.Add ActiveSheet.Name = strFoglio ... ...Next loop and not manually. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Click Event in Class Module Not Firing

I have a user form that displays line-by-line validation errors (in text box) that I want to supplement with user ... "!" & WhichRange) 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 handle wild characters in Macros?

I have wrote a piece of code to replace any characters, but it doesn't work fine with *. Can some ... :=False, _ ReplaceFormat:=False See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Run macro when email is sent

I am trying to write a macro that looks at the subject line of an email whenever the user hits the Send button. ... fire a macro on the click. See Question&Answers more detail:os...

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

0 votes

887 views

1 answer

vba - How can I convert a selection of emails from RichText to HTML Format?

Background: My work location has a default email format of RichText. Many people are adding images to their ... myMailItem = 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 - Find and Replace in just the selection

I have the following macro. It changes numbers of the form x.x to x,x. It was recorded and I added the ... document and not just the selection. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Suppress dialog warning that a program is trying to access my mails

I am following the code from this page: How to create a script for the Rules Wizard in Outlook This is what I ... and VB.net but none for VBA. 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 send email in Outlook on behalf of a Delegate?

I'm writing a VBA script that will fire off emails to our customers. I've made similar systems before, but the ... email, I can do that too) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Sending email from excel automatically based on date

I have an excel sheet with dated scheduling information. I would like to send daily updates on how many calls ... sent. Is this possible? 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 uniquely identify an Outlook email as MailItem.EntryID changes when email is moved

My company uses a single email address for customers to send requests and orders to. we created an Access ... s primary key field value. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Unable to get the vlookup to work

I run this set of codes and it returns an error: Run-time error '1004' Unable to get the Vlookup ... MsgBox policynum MsgBox policybox 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 can I call Workbook_Open on Workbook A from Workbook B?

My situation is that I am trying to open Workbook A from Workbook B and run the Workbook_Open subroutine. The ... ("Workbook A").Workbook_Open) See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Remove protected view from Excel sheet opened programmatically in Access

I have a spreadsheet I open programmatically using the VBA in Access: Set xl = CreateObject("Excel.Application") ... achieve what I'm after? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - Paste clipboard in outlook email in normal order

I have 5 userforms for an email. The workflow goes like this: create new email userform1.show user selects the ... VK_V, 0, KEYEVENTF_KEYUP, 0 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 find max and min date in a range of another sheet?

I am writing VBA code to find the minimum and maximum dates in a Range. When I execute it, I get an error: ... columns, Column 5 and 8 are dates See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags