Questions tagged as 'excel'

Tagged questions
0
answers

Doubts in excel

I'm creating a macro where I send emails, but I'm stuck in a process. I would like to know if it is possible to create a column where I select a pending reason, for example "lack of rg" that when selected, it has a script ready and is automat...
asked by 29.05.2018 / 19:13
1
answer

Excel (VBA) - Copy file data

I'm trying to gather data from multiple files into a single worksheet. In some searches I did for the network, I found several suggestions, and below is the code I found and met the need. I made some adjustments to adapt to what I needed but I'm...
asked by 29.05.2018 / 17:13
0
answers

How to get Excel formula in C # using OleDb?

I need to get the formula contained in an Excel cell. I'm using OleDb to access the spreadsheet, would you like to know if you have how to use it to access the formula of a cell?     
asked by 05.06.2018 / 19:41
0
answers

Java - Apache POI for Excel

I need to extract information from an Excel (xls) file in Biff4 format, and Apache POI, although great for reading Excel 97-2003 files, does not help much with these older versions. What other library can I use to read these older files?    ...
asked by 05.06.2018 / 21:06
1
answer

How to load a listview with more than 30 columns?

I'm trying to load a ListView with more than thirty columns using the following code: With ListV_P Sheets("BANCO").Select Dim UltimaLinha As Variant Dim Linha As String '.GetFirstVisible = True 'Abilita as linhas de Grades '.View = lv...
asked by 22.05.2018 / 02:28
1
answer

VBA code to insert images into excel can not recognize images that have letters and special characters in the image name

I use the following VBA code to grab images from a folder and insert it into a spreadsheet, but the VBA code can not recognize images that have letters and special characters in the image name, eg: (SP20-TP02), if the name of the image is just n...
asked by 09.05.2018 / 14:03
1
answer

Skip digits when running

I have a problem, I got a script here to insert the ninth digit if the phone starts with 6,7,8,9 .. Function ValidarCelular(Myrange As Range) As String On Error GoTo ErrHandler: Dim regEx As New RegExp Dim strPattern As String...
asked by 04.05.2018 / 16:29
0
answers

Connection parameter of the PivotTableWizard () method

Hello, could anyone give me an example of using the appropriate parameter connection of method PivotTableWizard() ? When I use this parameter I get the error: The PivotTableWizard property of the Worksheet class can not be obtaine...
asked by 25.04.2018 / 22:41
2
answers

Chronologically order date and time VBA

Good afternoon, I would like to know how I do to sort by date and time for excel. It would be 1 hour column and one date column. My question is how do I sort the schedules chronologically without affecting the dates ?? Here's the example of h...
asked by 15.03.2018 / 20:50
0
answers

Duplicate record when saving data from a form in vba / useform

Good afternoon, friends, How do I duplicate a record in a worksheet with data saved from the useform. Being more specific, I will use an example of a health plan where I have a form that I register holder and dependents and need to save each...
asked by 13.03.2018 / 17:08