Questions tagged as 'excel'

Tagged questions
1
answer

Import data from Mysql to Excel

I want to import data from Mysql to excel using Python, when I try to make it a tuple error. Can anyone with more experience help me? I followed the code and the error: # coding=utf-8 from Tkinter import * from os import popen import tkM...
asked by 21.09.2016 / 19:11
1
answer

How to add value of a conditioned cell to the value of another?

I'm trying to do this sum in excel. I have the products with prices and the kits of which they participate, but I do not know how to calculate the total value for each kit automatically. I would like to be able to include and take the products...
asked by 28.07.2016 / 15:12
1
answer

"Trace" in (VBA / Excel), how do I get the name of a subroutine?

How do I get the name of a subroutine (VBA / Excel) within itself to use in a "Trace" type code? ( See basic code in the UPDATE block after the sample code ) The idea is to use something like "ME.Name", which takes the name of the project....
asked by 25.11.2015 / 23:56
1
answer

Copy a range of Excel cells to an "image" object by VBA

I need to copy a strip from an Excel spreadsheet that contains a graphic layout made with borders around some cells, with some background colors and text, and visualize this layout in a VBA image. With the code below the cell range that makes...
asked by 01.02.2016 / 20:21
1
answer

Get value of steps

I wanted to know which formula (s) to get a value of a rank from a predefined table. For example, consider that in a worksheet I have the following table: | A | B | |-----|------| | 245 | 4,5% | | 256 | 6% | | 300 | 7% | So, whe...
asked by 23.12.2015 / 12:11
1
answer

Error putting other parameters in the Shell () function

I am trying to use the Shell() function of Vba in office 2010 , however it is returning me the following error:    Compile error       Expected Error: = My code looks like this: Dim programa As String: programa = "c...
asked by 10.06.2015 / 15:45
1
answer

Is there a way to remove the close forms button in VBA / Excel?

I want to get the close button of some forms in VBA / Excel. For example, I'm customizing the presentation of some messages to differentiate from VBA options that are unattractive. In addition to using different images, colors and fonts, i...
asked by 23.08.2016 / 01:22
1
answer

Read and write xlsm file in php

I have a fairly large hand problem which is as follows: I have an xlsm file with macros to read, write, and then download. It is a 4 MB file with formatting and embedded images. I have used PHPExcel just because I have not been able to rea...
asked by 13.04.2015 / 12:24
2
answers

Error canceling file import in Excel

I'm building a Macro to import a file into Excel. At some point, when the file's location is requested, if the Worksheet user cancels the import option, the following error message is returned:    Excel can not find the text file to r...
asked by 13.01.2015 / 17:26
1
answer

Do you have a macro to create another macro?

I have a spreadsheet of analysts, however, when the analyst changes or some new one comes in I need to copy everything just like the other analysts just changing the name of it. I would like to know if there is a possibility of creating a macro...
asked by 29.06.2015 / 15:19