Questions tagged as 'excel'

Tagged questions
3
answers

VBA: Use Excel to rename files in a folder

I'm thinking of using Excel Visual Basic to standardize the name of 6000 files in a given folder. These files are mixed between photos and documents, so there are a variety of extensions (DOC, DOCX, PDF, TIF, TIFF, JPG, JPGEm BMP, PNG, MSG ...)....
asked by 06.04.2017 / 20:17
2
answers

Last cell line and column Epplus - C #

I want to select a range from the first to the last cell filled in the row or column. In VBA the code stays as below using Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select How could I do it th...
asked by 02.03.2017 / 17:41
1
answer

Executing text as code in VBA

The code below calculates the formula contained in the Text (String) variable: Private Sub CalculeFormulaNoTexto() Dim Texto As String Texto = "= 90 / 3 + 7 + COS(0) + 1/7" ' A variável Texto recebe a fórmula que quero calcular ' Observe qu...
asked by 29.11.2015 / 20:19
3
answers

Excel - Extract only numeric fields from a selection containing texts and numbers

Using Excel, I need to extract numerical data from a selection. Example: Coluna 1 123 456 Bom Ruim 789 Ótimo From the above data, I need to extract the following data: Coluna 2 123 456 789     
asked by 05.10.2015 / 21:43
2
answers

Split file from EXCEL

I have a base in an excel with 1 million emails in it, and I need to split 4 files of 250 thousand emails each, does anyone know how I can do this with some excel function? Thank you     
asked by 12.06.2015 / 15:27
1
answer

How to format Numbers in Excel programmatically in C #

I'm setting up a C # Requests report, I'm using the Microsoft.Interop.Excel library and I'm facing a problem: It is necessary to include the Order number in this report and when it is presented in Excel it comes in Exponential Format:...
asked by 12.04.2016 / 17:52
1
answer

Generate random number when activating worksheet in Excel

I am here because I believe that only with the help of VBA I will achieve what I intend to do, which is the following: I'm developing a small game in Excel and I have to use random numbers, so every time I load, remove, or write something, th...
asked by 27.11.2014 / 22:18
1
answer

Use the "if" formula to calculate a certain time interval

I'm trying to create a condition but I'm having difficulty, can anyone help me? If cell number c15 is between -00: 10 and 0:10 (minutes) cell d15 should appear 0:00, otherwise cell d15 should show the same cell number c15. How to measure this...
asked by 27.07.2016 / 15:11
1
answer

Average function does not work

Hello, I created several random numbers with ALEATÓRIOENTRE() and concatenated them with CONCAT() I copied those values and pasted them in another part of the spreadsheet. I was trying to make the media with MÉDIA() But it r...
asked by 27.07.2016 / 00:14
1
answer

Macro email range + signature

Good morning. I need help with a macro for sending emails in Outlook 2007. I have a macro that selects a certain range of cells (everything to the right and everything down from a referenced cell) and pastes into an email, along with the i...
asked by 19.04.2018 / 16:07