Questions tagged as 'excel'

Tagged questions
1
answer

SendKeys does not work with accented word in VBA - Excel

I'm developing a script in VBA, in Excel. This code will populate another program, using the data collected in the cells. But cells that contain a word that has accents are not working. I'm using Application.SendKeys as in the follow...
asked by 06.01.2017 / 01:37
0
answers

Excel with more than 300 thousand lines

Good evening, I have a problem with Excel. The spreadsheet has more than 300 thousand lines and when I run the application with 30 thousand lines I have no problem. The error only happens with files that have many lines. Exception in thr...
asked by 27.10.2016 / 01:55
0
answers

multiple index control tables [closed]

I need to mount a control table of as many tables, it's basically a multiple index control that informs the position of these tables of data. Edition: after several attempts until using SQL directly I think I came to a basic conclusion using...
asked by 06.12.2016 / 17:11
0
answers

Send Excel macro message to Skype for Bussiness [closed]

I have a code that sends messages via lync but the system has been migrated to Skype for Bussiness . Could someone help me how to mute the code to send. When you try to run the macro it displays the error "Compile error: Can´t...
asked by 10.10.2016 / 15:48
0
answers

Problem when exporting data to Excel

I have a problem when exporting the data to Excel, the Residence Number fields and misinterpreted by EXCEL Example: if the client places in the field number of residence 100 A, it goes normal, more if it puts below 24, type 23 A, EXCEL interp...
asked by 06.10.2016 / 19:18
1
answer

Change width and height of Excel cell using xlwt

I need to change height and cell width of Excel I'm using the xlwt library. I did not find any references, can anyone help me?     
asked by 21.09.2016 / 22:19
1
answer

Compare rows of a file with data from a worksheet

I'm new to Python and I have a problem that's getting me out of the way ... It is as follows, I want to get the strings from a file and compare its elements with the phrases written in the spreadsheets of my .xlsx file. Only the...
asked by 13.10.2016 / 21:37
1
answer

How to merge multiple Excel tables into one?

I have 3000 tables as in this example: IneedtomergethemintooneandI'musingthecommand:=ÍNDICE(TXT!$B$1:$B$200,CORRESP(MAIOR(SE(TXT!$A$1:$A$200="Last Name:",TXT!$B$1:$B$200,""),1),TXT!$B$1:$B$200,0)) The problem is that it just shows me the f...
asked by 12.08.2016 / 13:05
1
answer

Select column with value *** of Excel

Good morning, friends! I need some help. I'm doing a "Select" from an Excel spreadsheet in VB.Net to import the data into the bank however a column is not bringing the data properly. This column has both numbers as * 's; when they are numb...
asked by 14.07.2016 / 15:28
0
answers

Need to Update a Pivot Table in an Excel Web Access

I have a Sharepoint application that uses a graphical element of a Pivot Table in an Excel Web Access (Web Part). The issue is that I can not get a very viable way to update the data, I have tried the following ways to update: 1- Using the Da...
asked by 03.08.2016 / 00:33