Questions tagged as 'excel'

Tagged questions
1
answer

Effect "Fade in and Delete - VBA"

I am having a question in VBA - MS EXCEL 2016 I need to create a macro that when I trigger it, it searches for an image.png on my computer and inserts it on the worksheet with the gradual effect of Fade-in. After that, the image should appear...
asked by 12.08.2018 / 04:51
0
answers

Keep formatting when exporting XLSX file through ExcellentExport.js

Good morning, I have a question about using ExcellentExport.js version 2.0.3 I can export my table without problems to download the xls file, however when I open it, the following message is displayed. ByclickingYes,Excelwillnormallyop...
asked by 30.07.2018 / 17:21
0
answers

give update in excel sheet with c #

I need to make a system that enters a website and enter the cpf, if cpf is registered in this site he can get the client's email and phone, after that impute this data in an excel worksheet. It takes the cpf's from a worksheet in excel as it...
asked by 25.07.2018 / 17:42
1
answer

VBA code to delete line

Well, I have a code that checks the line if there is a word or phrase and deletes the line: If Mid(Cells(i, 10), 1, 50) <> "Defeito" Then Rows(i).Delete Shift:=xlUp But in the spreadsheet there are phrases like "Defect + broadband" or...
asked by 07.05.2018 / 21:12
1
answer

PHP Application - Problems downloading files in xlsx

Hello, I have an application that is having problems downloading files in the latest Excel format Displays the IntheapplicationcallthisfileinphpIntheuploadIhavenoproblemssavingthefilesinsidetheapplication,inafoldercalledfiles..andwhenIaccess...
asked by 09.07.2018 / 16:03
0
answers

Excel VBA with Array's slow taratar data

I am developing a code to be applied in excel that summarizes the number of defects in a summary table. The data is imported from an xml file, which is opened by excel and created the "layout" by it. As it is the first time I work with array's a...
asked by 25.06.2018 / 03:23
0
answers

How to replicate information from an Excel to another Excel?

Good afternoon, In the company where I work with several Forms in Excel, I would like to know if you have to replicate information from: (Client Name / Company Name / Address ...) would import this information through the process number becau...
asked by 21.06.2018 / 22:07
0
answers

EXCEL - How to remove ALL duplicates - not just the duplicate

I have a problem that is getting worse every time .. I have a spreadsheet of user data for a company - where the key is the email of the official. I need to update this listing on a monthly basis including the NEW contractors and EXCLUDE t...
asked by 15.06.2018 / 17:44
0
answers

Criterion for breaking list in excel

I have a list that comes with data from other spreadsheets. Make a MAJOR to go back to the 1st major, then the 2nd, and so on. Then I make a PROCV to get the name for that value. Until then, OK. The problem and the doubt: How to break...
asked by 14.06.2018 / 21:31
0
answers

Exporting html to excel does not work in Firefox

I'm trying to export my table to excel, but I'm not sure how to do it.
asked by 19.06.2018 / 22:50