Recent questions tagged VBA

0 votes

736 views

1 answer

My question is simple: Is it possible to, like I would do in C++, to retrieve two parts of an array in VBA ... this, I then have not found it. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Multiple Variable Arguments to Application.OnTime

I am working on a data acquisition frontend for Excel 2010. I can't figure out the syntax for passing multiple ... of the strings being passed. See Question&Answers more detail:os...

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

0 votes

834 views

1 answer

vba - Chart won't update in Excel (2007)

I have an Excel document (2007) with a chart (Clustered Column) that gets its Data Series from cells containing ... fix the problem? Thank you See Question&Answers more detail:os...

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

0 votes

772 views

1 answer

vba - How to determine if a date falls on the weekend?

Given a date as input, how can I determine whether the day falls on a weekend? See Question&Answers more detail:os...

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

0 votes

807 views

1 answer

vba - How can an Excel Add-In respond to events in any worksheet?

Our workbooks are server-generated SpreadsheetML, which cannot include any VBA code. Creating native Excel files or ... worksheet. Any ideas? See Question&Answers more detail:os...

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

0 votes

812 views

1 answer

vba - Effect of Screen Updating

I have been playing around measuring code execution times to gauge differences between executing my scripts locally ... codes execution time? See Question&Answers more detail:os...

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

0 votes

775 views

1 answer

vba - Copy an entire worksheet to a new worksheet in Excel 2010

I have found similar questions that deal with copying an entire worksheet in one workbook and pasting it to another ... or ideas would be great. See Question&Answers more detail:os...

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

0 votes

792 views

1 answer

vba - Excel Select vs Activate

What is the difference between the VBA code wb.Sheets(1).Cells.Select and wb.Sheets(1).Activate? See Question&Answers more detail:os...

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

0 votes

915 views

1 answer

vba - Use getElementById on HTMLElement instead of HTMLDocument

I've been playing around with scraping data from web pages using VBS/VBA. If it were Javascript I'd be away as ... ("tr") would be awesome... See Question&Answers more detail:os...

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

0 votes

901 views

1 answer

vba - Calling Excel macros from PowerShell with arguments

Using Powershell it's rather easy to call Excel macro's from a script, for example with a script like this: ... the macro will read when called? See Question&Answers more detail:os...

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

0 votes

688 views

1 answer

vba - Is there a way to make UDF that gives a description like the native Excel functions have when user clicks the Fx button?

If I type =vlookup( (or any other native Excel function) in the formula bar and then click the little Fx ... that native Excel functions have? See Question&Answers more detail:os...

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

0 votes

749 views

1 answer

vba - Delete all data rows from an Excel table (apart from the first)

Just recently I've been trying to delete all data rows in a table, apart from the first (which needs to just ... useful to others in the future. See Question&Answers more detail:os...

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

0 votes

805 views

1 answer

vba - Insert line break in wrapped cell via code

Is it possible to insert line break in a wrapped cell through VBA code? (similar to doing Alt-Enter when entering ... it also through VBA code. See Question&Answers more detail:os...

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

0 votes

719 views

1 answer

vba - Insert line break in wrapped cell via code

Is it possible to insert line break in a wrapped cell through VBA code? (similar to doing Alt-Enter when entering ... it also through VBA code. See Question&Answers more detail:os...

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

0 votes

645 views

1 answer

vba - Exporting MS Access Forms and Class / Modules Recursively to text files?

I found some code on an ancient message board that nicely exports all of the VBA code from classes, modules ... of modules that need grepping. See Question&Answers more detail:os...

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

0 votes

716 views

1 answer

vba - How to name an object within a PowerPoint slide?

So I know how to name a textbox, or a like object in PowerPoint with VB, but I was wondering if there was ... an easier way through the Ribbon? See Question&Answers more detail:os...

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

0 votes

831 views

1 answer

vba - Display milliseconds in Excel

I am trying to display milliseconds in an Excel macro. I have a column of integers which are timestamps ... minutes, seconds, and milliseconds? See Question&Answers more detail:os...

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

0 votes

712 views

1 answer

vba - Excel telling me my blank cells aren't blank

So in excel I'm trying to get rid of the blank cells between my cells which have info in them by using F5 to ... in advance for your help! :) See Question&Answers more detail:os...

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

0 votes

767 views

1 answer

vba - Open word from excel

I can't open Word from Excel macro (Office XP). If I use this code, it will stop on line Set wdDoc ... wordapp.Quit Set wordapp = Nothing Next See Question&Answers more detail:os...

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

0 votes

854 views

1 answer

vba - How can I install/use "Scripting.FileSystemObject" in Excel 2010 for MAC?

I am using Excel for Mac 2011 which has VBA version 14.0. I am trying to use this code which accesses the ... from an Excel sheet via VBA? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

vba - Convert RTF (Rich Text Format) code into plain text in Excel

I exporting a database query as Excel and I am getting rows with RTF formatting. How can I convert these fields ... if anyone knows a way. See Question&Answers more detail:os...

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

0 votes

628 views

1 answer

vba - Change length of For loop while in the loop

I have a bunch of code that goes through a set of data and then finds the row where the data goes to the ... confusing. Thank you for your time. See Question&Answers more detail:os...

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

0 votes

857 views

1 answer

vba - How do I open an outlook .msg file from my harddrive that is NOT in outlook?

I have searched high and low for this seemingly simple task, but all references I come across are either ... more familiar with outlook vba. See Question&Answers more detail:os...

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

0 votes

713 views

1 answer

vba - Extract Data from Word Document to an Excel SpreadSheet

I have a requirement to extract a value from a word document on a daily basis and write it to an excel ... and wanted to thanks in advance See Question&Answers more detail:os...

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

0 votes

821 views

1 answer

vba - Procedure Too Large

I received this error message -Procedure too large - in VBA. What is the reason and way out for this error? See Question&Answers more detail:os...

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

0 votes

568 views

1 answer

vba - Switching the FROM Inbox

I currently use a code that generates an email fine with certain fields like To, CC, BCC, but I am not sure how to switch ... = Len(file_name) - Len(Replace(file_name, ";", ""))...

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

0 votes

576 views

1 answer

vba - Handling errors in math functions

What is good practice for error handling in math-related functions? I'm building up a library (module) of ... I'm open to suggestions! See Question&Answers more detail:os...

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

0 votes

706 views

1 answer

vba - Windows().Activate works on every computer except one

I have encountered a strange problem, I made macro about a year ago and it is being used every month without ... 9': Subscript out of range. See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags