Questions tagged as 'excel'

Tagged questions
2
answers

Excel form (Block fields)

I have a question as to which formula I can use. I have a box with 3 options (Example: 1, 2, 3) and if I select the option 1 I can fill in the field 1 and the > options 2 and 3 . If you select option 2 , I can fill in the field 2 an...
asked by 21.12.2017 / 13:13
1
answer

Convert numeric data into date

I would like to know if you have how to convert a scientific Excel number with PHP. The number is this "43067" would like to make it into a date.     
asked by 04.12.2017 / 12:07
1
answer

Excel change only part of a cell text

In an excel document I want a given text in a cell to automatically enumerate when I copy the entire group of cells. Example of explanation. - What I want is to copy the entire text and just modify the cell that says "text, 50, Num" so that it i...
asked by 17.08.2017 / 15:12
2
answers

How do I display button properties in VBA from an excel sheet?

I have a spreadsheet with buttons that hide and re-display fields as the data set is populated. When I try to view or change the properties of the controls, I can not. VBA only shows the properties of the worksheet.     
asked by 13.04.2017 / 16:46
2
answers

VBA Code Adapter to fetch photos from a folder

Good afternoon. I have a macro, which searches a worksheet for the name of the photo (eg IMG0102.JPG), searches the predefined folder for a related photo, and inserts it into the cell that is the name of the photo. However, I need to updat...
asked by 23.05.2017 / 18:34
1
answer

Update table dynamically last. VBA

I created a spreadsheet connected to my ERP via ODBC and I have some dynamic tables in the same spreadsheet. I'm trying to create a macro that updates all data, but using ActiveWorkbook.RefreshAll the command is updating the pivot tabl...
asked by 13.02.2017 / 12:10
2
answers

Which function to use

As a beginner in Excel, I'm having trouble using a function that I believe is the solution to what I want, the function (SE). This is the following, I have a sum of values that start from 54 and goes to 317. I want to break these values into 8...
asked by 10.10.2016 / 20:20
1
answer

Are there security issues when implementing and using "add-ins" in VBA (Excel)?

Due to macro security issues in VBA / Excel , I have doubts about whether it's the same (or something similar) when adding a add-in and use it later in VBA projects. Would this impact a user who "wheels" a system made in VBA with thi...
asked by 12.07.2016 / 19:42
1
answer

Automation Development in VBA - Error Handling in Loop

I'm developing a VBA automation that accesses a certain site and takes some information from it, but I'm having a problem with it. The site (Santander - Benner) is very badly done, many parts were built in a way that seems to mend with what t...
asked by 19.06.2018 / 15:15
1
answer

Change array structure [closed]

How to change the structure of an array? It can be using excel or via programming. I already did my solution with Java but it was a damn gambiarra :). Plus it's not generic enough. Is there a design pattern that solves this? The final goal is...
asked by 28.08.2017 / 20:13