Questions tagged as 'excel'

Tagged questions
1
answer

Excel VBA - Change cell between True and False

I am making a code but as I am still very green in VBA I do not know how to get this working. It's very simple, I want to load a cell and it will change a boolean between True and False. When I load it, it gets TRUE, but after pressing it aga...
asked by 04.08.2015 / 16:12
1
answer

How to calculate value of one cell only what exceeds the other

What formula would you use to calculate a value above a given number? Example: Area to calculate above 2.00M ². The multiplication value gave 2.75. How do I register in the cell only the 0.75 - and in the same formula there is a value less...
asked by 18.08.2015 / 06:21
1
answer

Problem using common controls 32 bit in 64 bit

I'm having a problem with the common controls in excel 64-bit (checkbox for example), they are required to run a VBA code but in 64 bit version I can not select them. NOTE: common controls have been deployed in 32 bit excel     
asked by 30.01.2015 / 19:39
1
answer

Error exporting to Excel (Corrupted file)

I am making an application to export the result of a sql query to Excel. After the file created the time I'm going to open it it gives a corrupted file error. SaveFileDialog sfd = new SaveFileDialog(); sfd.Filter = "Execl files (*.xls)|*.xls...
asked by 26.01.2015 / 15:23
1
answer

Problem with encoding in Excel file reader for Java

I have a relatively "common" problem. I have a Java program that makes importing an Excel spreadsheet and one of the column fields has words with accents, cedillas, etc. At the time of reading the variable, you are always marking with a black...
asked by 20.03.2015 / 17:46
1
answer

How to send only one spreadsheet per email in VBA and not the whole file using the code below

Option Compare Database Option Explicit Public Const C_Title As String = "ef3.Cinco" 'Metodos Public Sub SendMail(obj As MailClass) 'Nome da classe... Dim appOutLook As Outlook.Application '"Importando" Outlook Set appOutLook = CreateOb...
asked by 26.05.2015 / 23:16
1
answer

Use property R1C1

I want to use the Range.Formula R1C1 property on a check copy form to fill in a nominal check. How could I use this property for this purpose? I found a code described as follows: Sub Para() ' ' Para Macro ' Macro gravada em 4/9/2006...
asked by 10.06.2014 / 10:55
1
answer

Visual Basic Programming in Excel

Using Excel's Visual Basic mode, I'm creating a customer master record form. It has a button called " new ". In this button it would add a value to the Code field that is in the excel worksheet. However, when I test it it displays the following...
asked by 17.04.2014 / 20:58
1
answer

Use the Excel Application object within Access

I am creating a VBA script that exports a table into several excel shared worksheets in a specific directory. The problem is that Excel issues a warning to confirm the save of the file for each file. I would like to delete this confirmatio...
asked by 28.04.2014 / 15:31
4
answers

Breaks row in table cell in CSV format to be read by Excel

I have the following code that inserts a value into an excel cell for export context.Response.Write("aa\r\nbb\r\nccc"); o / r / n breaks the line but writes in the cell below, I would like to break the line but continue with the text in the...
asked by 03.04.2014 / 17:41