Recent questions tagged VBA

0 votes

754 views

1 answer

vba - Rename Worksheet Event in Excel

What is the best way to get some VBA code to run when a excel sheet is renamed? See Question&Answers more detail:os...

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

0 votes

805 views

1 answer

vba - How to script Excel 2013's Spreadsheet Compare?

I'm trying to incorporate the fancy new Spreadsheet Compare function from Excel 2013's Inquire Add-in, into ... Spreadsheet Compare, from VBA? See Question&Answers more detail:os...

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

0 votes

954 views

1 answer

vba - How good is the RAND() function in Excel for Monte Carlo simulation?

I'm implementing a Monte Carlo simulation in 3 variables in Excel. I've used the RAND() function to sample ... much about them) Many thanks. See Question&Answers more detail:os...

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

0 votes

632 views

1 answer

vba - Excel Select Case?

i want to create the "cases" formula for excel to simulate Select case behavior (with multiple arguments and ... exciting and truly educative! See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

vba - Hover preview over excel image link

I wanted to know is it possible to preview image links by hovering mouse cursor over image urls in excel, ... , or any spreadsheet editor. See Question&Answers more detail:os...

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

0 votes

597 views

1 answer

vba - Differences between XMLHTTP and ServerXMLHTTP

I'm trying to write an Excel add-in that can get data from a web service into Excel. To use ... differences between XMLHTTP and ServerXMLHTTP? See Question&Answers more detail:os...

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

0 votes

826 views

1 answer

vba - How to delete row based on cell value

I have a worksheet, I need to delete rows based on cell value .. Cells to check are in Column A .. If ... Here. UPDATE Sample of Data I have See Question&Answers more detail:os...

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

0 votes

496 views

1 answer

vba - Variable iterating on itself - different behavior with different types

Please take a look at the latest updates at the end of the post. In Particular, see Update 4: the Variant comparison ... = y ' False ! End Sub See Question&Answers more detail:os...

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

0 votes

781 views

1 answer

vba - Write contents of immediate window to a text file

I'm writing a macro which goes through a document and tries to parse it by Style. Right now, anything in the ... they opened up VBA, correct? See Question&Answers more detail:os...

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

0 votes

795 views

1 answer

vba - Open Windows Explorer and select a file

Is there a way to open a Windows Explorer window from a vba form, navigate to a specific file and select it so ... is placed in a text box? See Question&Answers more detail:os...

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

0 votes

966 views

1 answer

vba - Export all MS Access SQL queries to text files

I have to document an MS Access database with many many macros queries, etc. I wish to use code to extract ... the clicking, doing saveas etc. See Question&Answers more detail:os...

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

0 votes

830 views

1 answer

vba - Call web service in excel

In a VBA module in excel 2007, is it possible to call a web service? If so, any code snippets? How would I add the web reference? See Question&Answers more detail:os...

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

0 votes

834 views

1 answer

vba - Registering .Net COM DLLs without Admin rights / regasm

Recently, I wrote a class library in C# for use in Office applications, including a critical Access ... , without administrative privileges? See Question&Answers more detail:os...

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

0 votes

857 views

1 answer

vba - Writing into Range.FormulaArray gives me a #NAME! error

Nothing really fancy here, altough I need to split the formula in 2 because it is longer than 255 characters ( ... the Web but no solution. See Question&Answers more detail:os...