Recent questions tagged VBA

0 votes

776 views

1 answer

vba - Dynamically insert macro into a new excel workbook

How can an existing macro be inserted into a new excel workbook? I want to create a new WorkBook (with vba ... macro into the new WorkBook. See Question&Answers more detail:os...

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

0 votes

967 views

1 answer

vba - Run Time Error 5 - Invalid Procedure Call or Argument

I need help with this macro. Every time I run it, I get the error below. I thought it was a simple macro ... ) & " Indicator", xlSum End Sub See Question&Answers more detail:os...

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

0 votes

999 views

1 answer

vba - Excel to PowerPoint PasteSpecial and Keep Source Formatting

I'm trying to copy and paste a range from an Excel document into a PowerPoint slide. It is copying ... .Selection.ShapeRange.Top = 150 See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - FileSystemObject.CreateFolder to create directory and subdirectories

I would like to create a directory and a subdirectory with the following code: Public fso As Scripting. ... using Excel VBA 2007/2010 See Question&Answers more detail:os...

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

0 votes

880 views

1 answer

vba error handling in loop

New to vba, trying an 'on error goto' but, I keep getting errors 'index out of range'. I just want to make ... or how to avoid using the loop. See Question&Answers more detail:os...

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

0 votes

730 views

1 answer

vba - How use the combobox keydown event without selecting the listed item

I have in my Excel VBA project, a combobox which uses a range of cells as it's list of items. I have ... item, but only scroll through them? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Macro to save selected emails of Outlook in Windows folder

I am trying to save outlook emails to windows folder, but the macro which i had is not working properly, at each email ... , "|", sChr) End Sub See Question&Answers more detail:os...

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

0 votes

860 views

1 answer

vba - Determining whether an existing Outlook instance is open

After reading how to use automation to send a message, I'm unclear of whether it's possible to avoid opening a ... .Application") End If End Sub See Question&Answers more detail:os...

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

0 votes

889 views

1 answer

vba - INSERT data from Excel into SQL DB

I have created an Excel Sheet that does some lookups to format data that needs to be inserted into another table ... then insert the data back. See Question&Answers more detail:os...

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

0 votes

742 views

1 answer

vba - Why can't I do a "with x as (...)" with ADODB and Oracle?

I fail to execute an SQL query with a with clause via ADODB and Oracle. That is, the following snippet works ... on this is highly appreciated. See Question&Answers more detail:os...

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

0 votes

832 views

1 answer

vba - How to disable access security notice "A Potential security concern has been identified"

i have a shared access application, i created an accde file for 32-bit machine, when user open the application ... to the users thank you See Question&Answers more detail:os...

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

0 votes

768 views

1 answer

vba - Creating a Class to Handle Access Form Control Events

I'm trying to create a Class which will handle multiple Control Events in Access. This is to save the repetition ... how I would go about this? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

vba - edit chart data in powerpoint

I would like to edit the values of a chart within a powerpoint file. I can't seem to find the ... methods in the conventional DataTable method. See Question&Answers more detail:os...

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

0 votes

760 views

1 answer

vba - How can I supress the Outlook warning while sending mail using macro in excel

I am trying to send an email using macro in excel. But when I run this code my mail client i.e. MS ... email should be sent without any problem? See Question&Answers more detail:os...

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

0 votes

827 views

1 answer

vba - "ThisWorksheet" equivalent?

In Excel, I have some macros that are part of a Worksheet module. In the code, I want to make sure that ... the code running is stored in? See Question&Answers more detail:os...

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

0 votes

854 views

1 answer

vba - How to export an Excel sheet range to a picture, from within R

We are trying to automate the creation of some picture files within an R Script. We have the Excel files ... this would be much appreciated! See Question&Answers more detail:os...

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

0 votes

710 views

1 answer

vba - What is causing "Automation error Unspecified error" on Worksheet_Activate?

I have a worksheet named "Dates" (object name is A_Dates) that needs to be calculated when it is activated ... Objects Recordset 2.8 Library 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 extract substring in parentheses using Regex pattern

This is probably a simple problem, but unfortunately I wasn't able to get the results I wanted... Say, I ... because it relies on brackets... See Question&Answers more detail:os...

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

0 votes

883 views

1 answer

vba - Clear filter from Table

I'm trying to run a macro that replaces data in a table in Excel, when the data might initially be ... WITHOUT removing filters from the table? See Question&Answers more detail:os...

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

0 votes

750 views

1 answer

vba - Build a tree like representation of data in Excel?

I have a bunch of raw data in this fashion: Parent | Data --------------- Root | AAA AAA | BBB AAA ... any easy way to do this using only VBA? See Question&Answers more detail:os...

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

0 votes

735 views

1 answer

vba - Adding sheets to end of workbook in Excel (normal method not working?)

This is the VBA code im using to try add a new sheet to the last place in the workbook mainWB.Sheets.Add(After ... done. What am I doing wrong? See Question&Answers more detail:os...

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

0 votes

819 views

1 answer

vba - Find the directory part (minus the filename) of a full path in access 97

For various reasons, I'm stuck in Access 97 and need to get only the path part of a full pathname. For example ... must be a better way, right? See Question&Answers more detail:os...

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

0 votes

701 views

1 answer

vba - Search a website with Excel data to extract results and then loop

I have 8000 values in an Excel spreadsheet. I need to search a website and then record a specific line of data from the ... B3>C3, B4>C4, etc.). See Question&Answers more detail:os...

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

0 votes

745 views

1 answer

vba - Transpose Excel column to rows

I have an Excel sheet that looks like the first picture and I want to convert it to the second picture: I have ... 1 Loop Next y Wend End Sub See Question&Answers more detail:os...

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

0 votes

603 views

1 answer

vba - Writing a macro that writes a macro to another Excel-file

I have some VBA code that I need to copy to a lot of worksheets (it's Event-handling, so it's located ... of all of the selected workbooks? See Question&Answers more detail:os...

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

0 votes

798 views

1 answer

vba - How to sort emails by date and open the latest email found?

I'm wondering if there is a way to sort emails by date and then open the latest email found. I'm trying to ... so that I can reply to it. See Question&Answers more detail:os...

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

0 votes

951 views

1 answer

vba - Advance AutoFilter to exclude certain values

I want to filter a large list of names in a Sheet in excel. In another sheet I have contained a list of names ... :H3"), Unique:=False End Sub See Question&Answers more detail:os...

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

0 votes

667 views

1 answer

vba - How to iterate over multiple Word instances (with AccessibleObjectFromWindow)

I need to iterate over all Word instances, no matter if opened by users, by automation, zumbis, etc. I ... ) -2147467259 Any ideas? directions? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags