Questions tagged as 'excel'

Tagged questions
1
answer

Merge Excel cells via Delphi code

I'm updating an old Delphi system that uses a class to create an Excel file without the need to use OLE objects or have Excel installed. The Class works normally using the code that is just below. Now there is a need to add information in...
asked by 03.11.2015 / 22:43
1
answer

Visual Basic Excel - Delete an array name

I'm here with some problems, I never moved in Visual Basic and was seeing if it helped me to make a listing that I have in Excel faster (Through Visual Basic Excel). It's very simple, I just want to look in the array if you have a word that h...
asked by 29.07.2015 / 19:12
1
answer

Excel How to find the address of the current cell

I have a column in my table where I place the date of arrival of a product. I would like to create a conditional formatting (put the cell in red) when it is 15 days or less before the product arrives. The formula I used was =$B$7-HOJE()<...
asked by 10.10.2014 / 14:52
2
answers

How do I set the width of columns in an Excel spreadsheet generated as HTML?

I need to convert an HTML table and generate the file in excel. How to set the width of columns in excel? I create the HTML file using PHP and export using: header ("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); header ("Last-Modified: " . gmdate(...
asked by 17.02.2014 / 21:13
2
answers

How to access a value that was put via JavaScript from a site via VBA?

I'm trying to access the values that appear on the site: link I was unable to access the values either by direct hyperlink in excel, or by creating a querytable via VBA. Of the two modes the values do not return. Searching the internet, I s...
asked by 10.06.2015 / 21:09
2
answers

Create excel table based filter

Hello, I have a table in Excel of 3 columns: Pessoa | ID | País João | 1 | Flórida Maria | 2 | Flórida Ana | 3 | Miami Ana | 4 | Califórnia Pedro | 5 | Califórnia João | 6 | Flórida etc ... I would like to build a ta...
asked by 07.02.2017 / 02:29
1
answer

VBA Download pdf

I'm developing a macro in excel that through a list of ids and passwords in excel logs into a website and tries to download a pdf. I can log in to the site and navigate to the button that generates the pfd. The problem is that the button trigger...
asked by 26.05.2016 / 17:07
1
answer

Excel spreadsheet word search and full line return containing that word in PYTHON

Hello, is everything good? I am a beginner in Python and would like to run a script that given a spreadsheet in excel, the user could search for a word within that worksheet and if the word was found return "Found File and display all lines. For...
asked by 27.01.2016 / 14:50
2
answers

Delete a macro using another

How to program one macro to exclude another? It would be something like, like when, do I need to call? Ex.: Sub callmacro() Call macro1 End sub And, even better, if I want to program it to self-delete? Eg: Sub macro1() Dim i as... Fo...
asked by 17.02.2016 / 16:35
2
answers

Is there an Excel function that associates letters with numbers (A = 1, B = 2, C = 3 etc.)?

Is there an Excel function that associates letters with numbers in alphabetical order (that is, f(A) = 1, f(B) = 2, f(C) = 3 and so on)?     
asked by 01.11.2018 / 13:52