Questions tagged as 'excel'

Tagged questions
1
answer

Macro Excel - Save image to chart export to directory and import to form

I upgraded my version of Office to 2016 and some macros stopped working properly. The routine when executed in isolation works properly, but when it goes into a process it stops working. The macro in question makes the following precedents. Copy...
asked by 18.08.2016 / 15:42
2
answers

Values based on the last day of each month (Excel)

Edited: Personal, this is my Excel file. I want the last value of each month of column A to be referenced by column C, that is, for the month and year of each row of column A I must find the value of what would be referring to the last day of...
asked by 24.06.2016 / 00:06
1
answer

Imprecision of the column sum result

Environment: Excel 2013 Example: When adding the values of a column with 1110 lines, the result obtained is 302.204.548,38 If you add the value of 249.998.78 from line 1111 of the same column, you should get 302.454.547,16 but instead of this va...
asked by 10.05.2016 / 17:56
1
answer

Tool to convert Excel to Json [duplicate]

I have an excell table and I need to generate a graph with Charts.js which uses json to mount the database. So how can I convert an excel table with 50 rows and 10 columns into JSON data.     
asked by 07.04.2016 / 15:35
1
answer

Problem with CSV import to Mysql

I am importing csv file information into the mysql database some spreadsheets have been imported correctly, however some spreadsheets when importing into the database appear a double quotation mark that does not exist in the spreadsheet so affec...
asked by 15.06.2016 / 16:07
2
answers

How to compare the values of one interval with another, following a formula?

I have my championship leaderboard, which has a line " Number of laps per race " and below " laps completed ". I want to go through all the values in the line " Completed laps" and compare with " Number of laps per race ", with the following...
asked by 30.03.2016 / 00:10
1
answer

Why do ASCII characters differ from Excel for presentation through code in VBA?

Does anyone know why this occurs? I need to use characters from the " Wingdings 3 " font in Labels dynamically created in a VBA If these Labels are created directly on the form the problem does not occur, for example, when creating a...
asked by 18.03.2016 / 16:35
2
answers

How to delete dynamically created objects based on vector? (VBA / Excel)

The code below creates Labels dynamically based on a vector, it happens that I did not succeed in trying to delete (destroy) these objects. I tested the 'Nothing' and other features indicated, but none worked, that is, the Labels remain on th...
asked by 17.03.2016 / 23:42
1
answer

Save an image pasted to Excel worksheet through VBA

The code below copies a range of cells from a spreadsheet that is pasted to another worksheet, but I have not found a way to save it as an image file to a folder, or even select it to work with it image by VBA. Range("D19:H25").Select Applica...
asked by 01.02.2016 / 23:45
1
answer

Problem with VBA integration and Internet Explorer

I'm trying to use VBA to collect data directly from the internet. I have seen several examples of using the InternetExplorer Object, as below: Dim IE as Object Set IE = New InternetExplorer IE.navigate "http://www.minhapagina.com.br" html =...
asked by 29.07.2015 / 00:50