excel Archives - Page 2 of 3

How to return a result from a VBA function

How do I return a result from a function? For example: Public Function test() As Integer return 1 End Function This gives a ...

May 15, 2022
0 Comments

Add leading zeroes/0’s to existing Excel values to certain length

There are many, many questions and quality answers on SO regarding how to prevent leading zeroes from getting stripped when importing to or ...

May 15, 2022
0 Comments

Shortcut to Apply a Formula to an Entire Column in Excel [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question ...

May 15, 2022
0 Comments

How to create strings containing double quotes in Excel formulas?

How can I construct the following string in an Excel formula: Maurice “The Rocket” Richard If I’m using single quotes, it’s trivial = ...

May 13, 2022
0 Comments

Setting mime type for excel document

MS Excel has the following observed MIME types: application/vnd.ms-excel (official) application/msexcel application/x-msexcel application/x-ms-excel application/x-excel application/x-dos_ms_excel application/xls application/x-xls application/vnd.openxmlformats-officedocument.spreadsheetml.sheet (xlsx) Is there any one ...

May 8, 2022
0 Comments

What is correct content-type for excel files? [duplicate]

This question already has answers here: What is a correct MIME type for .docx, .pptx, etc.? (9 answers) Closed 7 years ago. I ...

May 2, 2022
0 Comments

Is there a way to crack the password on an Excel VBA Project?

I’ve been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there’s a lack of ...

May 1, 2022
0 Comments

Is it possible to force Excel recognize UTF-8 CSV files automatically?

I’m developing a part of an application that’s responsible for exporting some data into CSV files. The application always uses UTF-8 because of ...

May 1, 2022
0 Comments

Stop Excel from automatically converting certain text values to dates

Does anyone happen to know if there is a token I can add to my csv for a certain field so Excel doesn’t ...

April 30, 2022
0 Comments

How to avoid using Select in Excel VBA

I’ve heard much about the understandable abhorrence of using .Select in Excel VBA, but I am unsure of how to avoid using it. ...

April 30, 2022
0 Comments