Recent questions tagged VBA

0 votes

703 views

1 answer

vba - Instr condition doesn't work with 2 or more conditions

I have the following INSTR condition in Excel VBA which doesn't work (all the time) STR_TEXT="SKU1234 $100/10' ... an IF inside another IF ? See Question&Answers more detail:os...

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

0 votes

983 views

1 answer

vba - Access Outlook default folder

I working on an Outlook VBA application and I need to access my inbox but I seem to be having some trouble. ... , vbCritical, Err.Number End Sub See Question&Answers more detail:os...

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

0 votes

803 views

1 answer

vba - Subscript out of range error with an array - no idea why?

I have declared an array as such Dim rArray() As Variantbut when i try and use the values that is stored ... be declared and used in Functions? See Question&Answers more detail:os...

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

0 votes

696 views

1 answer

vba - How can I modify conversationTopic so emails with different subjects are put in the same thread?

I want to help Outlook 2010 thread my emails. My understanding is that it bases the conversation view off of ... .Save End If End Sub See Question&Answers more detail:os...

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

0 votes

710 views

1 answer

vba - How to get list of all files with ESY extension in a directory?

In VBA, how do I get a list of all the files with a specific extension in a specific directory? i am unable ... , because i am using excel 2007 See Question&Answers more detail:os...

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

0 votes

824 views

1 answer

vba - MS Access RunCode Macro cannot find my procedure

I'm only posting this since I wasn't able to find a solution anywhere. I finally figured it out. Kind of ... procedure name Still didn't work! See Question&Answers more detail:os...

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

0 votes

957 views

1 answer

vba - Macro - delete rows based on date

I am very new to VBA and macros in Excel. I have a very large excel spreadsheet in which column A holds ... error... can somebody help please? See Question&Answers more detail:os...

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

0 votes

970 views

1 answer

vba - Create comma separated file (csv) from access - scheduled daily from windows

I would like to create a vbs file to export an access table in a csv file (comma separated). I saw this ... rs.GetString f.WriteLine a f.Close See Question&Answers more detail:os...

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

0 votes

746 views

1 answer

vba - Assigning the value of a worksheet cell to a constant

I am trying to assign the value of a worksheet cell to a constant variable in a VBA macro. The logic behind ... a constant like this in VBA? 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 use powershell to copy several excel worksheets and make a new one?

I have about 70 excel files I want to combine into a single document. Each document has only one sheet and ... excel Any suggestions? Thank you. See Question&Answers more detail:os...

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

0 votes

714 views

1 answer

vba - Excel: Recalculating every x seconds

One of my spreadsheets deals with various calculations involving, among other things, the current date and ... of manipulating spreadsheets.) See Question&Answers more detail:os...

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

0 votes

908 views

1 answer

vba - Find all used references in Excel formula

Below is the example set in Excel, [column1] [column2] A1 =C3-C5 A2 =((C4-C6)/C6) A3 =C4*C3 A4 =C6/C7 A5 = ... A2, I need to get the C4 and C6. See Question&Answers more detail:os...

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

0 votes

945 views

1 answer

vba - Error 1004 when trying to get AutoFilter criteria of date filtering

I'm working on a piece of VBA code which should save & restore the current AutoFilter state in Excel. I' ... to avoid the extra complexity. See Question&Answers more detail:os...

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

0 votes

802 views

1 answer

vba - Number of elements in a single dimension variant array in excel

Is This code correct for determining the number of elements in a single dimension variant array in Excel VBA. ... Integer n = UBound(Array1) See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - reading and writing a csv file using FileSystemObject

Is it possible to read and write csv files using FileSystemObject in VBA? See Question&Answers more detail:os...

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

0 votes

810 views

1 answer

vba - Fetch specific table only from website into Excel

I need to fetch the table from http://www.zillow.com/homes/comps/67083361_zpid/ into Excel using VBA. I just ... row data into Excel properly. See Question&Answers more detail:os...

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

0 votes

989 views

1 answer

vba - Checking for broken hyperlinks in Excel

I have a large list of hyperlinks (plus a few cells of nonsense) that I need to check. I need to ... /advice would be very much appreciated! See Question&Answers more detail:os...

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

0 votes

754 views

1 answer

vba - Restrict type in a Collection inside a class module

I have a collection inside a class module. I'd like to restrict the object type that is "addable" to this ... then that's the only way. See Question&Answers more detail:os...

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

0 votes

760 views

1 answer

vba - running a macro from an add-in

i have an add-in called book1. inside the addin there is a module called module1 which has a sub called addin1 i ... that is within an add-in ? See Question&Answers more detail:os...

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

0 votes

956 views

1 answer

vba - How to get Ribbon custom Tabs IDs?

I am working with a Custom Ribbon in Power Point, I need to iterate through all tabs and get the ID of ... Ribbon using VBA? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

978 views

1 answer

vba - How to update excel embedded charts in powerpoint?

I have 30 charts that were created from excel and were pasted onto powerpoint slides. Every month, I ... assistance is greatly appreciated. See Question&Answers more detail:os...

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

0 votes

890 views

1 answer

vba - What is the correct `XlFileFormat` enumeration for Excel 97-2003

In regards to Excel VBA Interop, what is the correct XlFileFormat enumeration for saving an Excel 97-2003 ... correct selection is. Thanks See Question&Answers more detail:os...

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

0 votes

954 views

1 answer

vba - Excel Macro - Select all cells with data and format as table

Is it possible to write a macro that can format a table out of any active selection? For instance, I have a ... " End Sub Thanks in advance. See Question&Answers more detail:os...

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

0 votes

658 views

1 answer

vba - How to prevent showing backing private fields of class properties in the Locals window?

Although an experienced VBA programmer it is the first time that I make my own classes (objects). I am surprised ... some way get rid of pName? See Question&Answers more detail:os...

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

0 votes

936 views

1 answer

vba - Iterate all email items in a specific Outlook folder

How can I in an Outlook VBA macro iterate all email items in a specific Outlook folder (in this case ... Resume ProgramExit Next Item End Sub See Question&Answers more detail:os...

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

0 votes

711 views

1 answer

vba - How to Consolidate Data from Multiple Excel Columns All into One Column

Lets say I have an excel sheet with 4 columns of data & 20,000 rows of data in each column. What is ... do I implement that solution? Thanks! See Question&Answers more detail:os...

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

0 votes

827 views

1 answer

vba - MS Access call SQL Server stored procedure

I have an MS Access application that contains all tables linked to SQL Server, so in MS Access VBA code or ... ? Appreciate any help. Thanks! See Question&Answers more detail:os...

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

0 votes

870 views

1 answer

vba - Debug a bad DLL calling convention

How do I debug a bad DLL calling convention error in MSAccess VBA code? I made some changes to a ... function statement of the function. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags