Questions tagged as 'excel'

Tagged questions
1
answer

How to concatenate variable with formula in Excel?

Is it correct for me to concatenate a variable to an Excel formula? Excel complains about closing the concatenation: Sheets("FATURA").Select Dim variavel As Double variavel = InputBox("Digite Valor da Tarifa caso nao souber Digite 0,35")...
asked by 13.04.2017 / 21:57
1
answer

Using TransferSpreadSheet via VBA

I'm finalizing my improvement project and have something that intrigues me a lot. I needed to make a report based on the result of an SQL query, which I even asked in Exporting SQL query data to Excel , and now I need to do the opposite and...
asked by 06.04.2017 / 21:55
1
answer

Problems transferring date type from MSProject to Excel

Hello. I'm having trouble transferring some Baseline Start, Baseline Finish, Actual Start, Current Finish dates from MSProject to a worksheet in excel. Here is the snippet of code. Dim xlSheet As Excel.Worksheet Dim wb As Workbook Dim Prog As...
asked by 23.02.2017 / 14:30
1
answer

Filling and importing data with VBA in excel, help in code?

Hello, the situation I am trying to automate in excel, through VBA is as follows: I have two spreadsheets (different excel files), where both have the same heading (with information like ID, Name, Description ... ), but with the columns in differ...
asked by 02.02.2017 / 04:24
1
answer

Java Poi does not download

I'm using the poi 3.15 library to generate excel on a web system, but I'm having a hard time downloading the file locally, but when I do it does nothing. I put it in the beginning like this: String caminho = System.getProperty("user.home");...
asked by 14.02.2017 / 22:11
1
answer

Join data from two worksheets in Excel

I have two spreadsheets in Excel. At first I have the following data, for example: ID | NOME -----|---------- 100 | Luiz 101 | Pedro 102 | Aline In the second worksheet, I have: ID | CATEGORIA -----|------------ 100 | Livros 10...
asked by 14.02.2017 / 13:50
1
answer

How to color column type date according to the current date

I have an Excel table of schedules, which I need the color to change according to the date, the current date will be red. If the date is greater than the current date, it will also be red (Scheduling expired). I tried the conditional forma...
asked by 22.11.2016 / 18:09
1
answer

Excel - VBA: I need support to link the Max function

How can I reference a column of a certain sheet using the below command in VBA? Application.WorksheetFunction.Max     
asked by 29.09.2016 / 23:00
1
answer

Generate an XLS without using Excel (BIFF)

How to generate a .xls file without using Excel? I do not want to use OLE , but I would like to enter the information in binary format, using the BIFF8 structure or something like this. The problem is that I can not find doc...
asked by 26.09.2016 / 16:11
1
answer

how to establish a numeric interval for averaging

I want to calculate the mean of a variable with the following formula: = MEASURE (M2: M487; "> = 20
asked by 04.09.2016 / 00:10