Questions tagged as 'excel'

Tagged questions
1
answer

Highlight TextBox if the value loaded is the same in the worksheet

In a registration form when clicking search the textbox are filled. And if any of those TextBoxes has a value that appears in plan1 from the "AS" column then that TextBox has the highlighted text (eg Green). I got a code but it is not working....
asked by 28.06.2016 / 19:23
1
answer

Open another instance of Excel while VBA runs

I created an application in Excel that extracts information from the internet, directly to it through the Selenium IDE Webdriver. However, while this application runs, I can not open a new worksheet, or a new instance of that macro, is there a p...
asked by 20.01.2017 / 19:39
1
answer

Error generating excel file

When the system runs on the server this error occurs: ERROR: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT...
asked by 20.05.2016 / 17:54
1
answer

VBA. I try to convert a txt to excel

I have this macro to convert several txt to excel , but when converting it does not separate the file by column ";" Sub Convert_Csv() Dim File_Names As Variant Dim File_count As Integer Dim Active_File_Name As String D...
asked by 15.07.2016 / 23:08
1
answer

Is it possible to use a "SOMARPRODUCT" to calculate values in several worksheets?

I have some tables with names of stores and I would like to know the sums of values of these stores that are in different spreadsheets. Is it possible to do this using "SOMARPRODUCT" or "SOMASE"? I tried this but it's not right: =SOMARPRODUTO(...
asked by 25.11.2015 / 21:07
3
answers

Function = VLOOKUP (MAX ($ B $ 5: $ B $ 11); $ A $ 5: $ A $ 11; 1; 0) Excel 2010

I'm using the function: = VLOOKUP (MAX ($ B $ 5: $ B $ 11); $ A $ 5: $ A $ 11; 1; 0) in cell B23 in Excel 2010. Result: # N / A! Can anyone help me correct my formula? Very grateful, Silvio.     
asked by 25.10.2015 / 01:55
1
answer

VBA returns wrong date string

I made a code to return a string from the first day of the month acts: Dia = "1/" & CStr(Month(Now)) & "/" & CStr(Year(Now)) Then I put it in a cell Cells(rowx,colx).value = Dia The pasted value change position the day with...
asked by 02.02.2016 / 21:15
2
answers

How to search for information from another worksheet in Excel

I have a system that generates .xls spreadsheets daily, for example "array_070120150900.xls". Where the numbers represent the day and time 07/01/2015 at 09:00. I've created a worksheet for managing this data called gestion.xls. How do I manage.x...
asked by 07.01.2015 / 13:15
1
answer

ADO Command / Parameter in Excel (VBA)

Hello, I'm developing a code in VBA in Excel 2010 in conjunction with an Access 2010 bank. In this code, I use ADO Command to manipulate the data in the database, however I am getting an error message in a particular piece of code. The...
asked by 06.04.2015 / 21:29
1
answer

Exporting currency formatting with ExcelBuilderJS

I am using ExcelBuilderJS to produce an Excel spreadsheet on demand and download it to the customer. Ideally, this needs to be done on the client, not the server, and the library works very well in that respect. However, I encountered a pro...
asked by 25.07.2014 / 16:57