Questions tagged as 'excel'

Tagged questions
1
answer

In EXCEL, How to use bold formatting of a cell and apply in a "concatenate" function in another cell

I have a small table, I intend to use the bold formatting of the cell "A20" of the number '2001-T' and apply in the function "concatenate" of the cell "F20", however any type of formatting that I do in cell " A20 "does not apply also in cell" F2...
asked by 10.10.2018 / 18:18
1
answer

Running time error '91' The object variable or the with block variable has not been defined

I do not know how to work very well with excel, I have to make a graph using buttons and gave this error Sub logs_acumulador() ' ' logs_acumulador Macro ' ' ActiveChart.SetSourceData Source:=Range( _ "db_performance.producao[[#All...
asked by 02.04.2018 / 14:56
1
answer

AutoFilter Excel VBA

I have a problem, when trying to make an autofilter in vba it is trying to filter the values I chose but it does not filter value, I searched a lot and found no explanation. The code is as follows: Dim nomeArquivo As String Dim gd As I...
asked by 19.09.2017 / 20:52
1
answer

Load excel data on the screen [closed]

I have a problem loading data from a worksheet on the table. The system is done in C # MVC5 with razor and entity framework, I need the user to choose an already filled excel file and with the data of that file I have to present it in a html...
asked by 28.07.2017 / 21:25
2
answers

Excel form - incompatible types

I know this should be a simple question to answer, but I'm starting to program in VBA now. The code below should transfer the data from one worksheet to another, it should be something very simple, but it gives compilation error. Sorry if I u...
asked by 11.09.2017 / 23:40
2
answers

Importing EXCEL data for PHP!

Hello, I've come to ask for help regarding EXCEL and PHP; Shortly after I joined a company, where there is a dashboard made in VBA in EXCEL, however, I realized that it gives a lot of trouble. So I decided to develop a new dashboard, remove from...
asked by 08.06.2017 / 15:59
1
answer

Count the number of selected items in a ListBox

I have a ListBox1 list in a userform configured for multiple item selection. Is there a function, statement or way to return the number of selected items?     
asked by 27.04.2017 / 20:21
1
answer

Excel Formula to format tables

Is there any formula to string the colors of a table? I do not want the "normal" (eg red | white | red). What I intend is always that the name of a certain cell is equal, then the background is of color A, when the name of the cell is different...
asked by 16.05.2017 / 11:27
1
answer

Display return of a SQL query in Excel

My question is divided into two parts. The first one, it is possible to perform SQL command by Excel, as I need to display certain information from my MySQL database in a table in Excel. Note: I do not want to connect via ODBC, I need the q...
asked by 07.04.2017 / 14:37
1
answer

Add photo in excel from local folder

Hello, I followed the steps all the steps here - Add photo in excel worksheet from local folder And everything worked fine. But I wanted to resize the images and align them to the center of the cell - horizontal and vertical. As I did...
asked by 24.11.2016 / 19:24