Questions tagged as 'excel'

Tagged questions
0
answers

How to use the same .xla add-in on two machines on the same worksheet?

I created a file with functions in VBA .xla that can be configured as an excel add-in, but after using the functions in any spreadsheet on my machine and sending the spreadsheet to someone else it can not visualize the function return is that #N...
asked by 08.12.2017 / 13:21
1
answer

Create image in another form

I have the following project: WhenIclickthebuttonitworksperfectly,noproblem,butIwantedtheQRCodetobegeneratedinSheet2forexample.BelowthemacrocodeSubGenQRCode(ByValdataAsString,ByValcolorAsString,ByValbgcolorAsString,ByValsizeAsInteger)OnError...
asked by 01.09.2017 / 13:19
0
answers

How to read an excel and insert data into a table?

I wanted to send data from a file Excel to a table in Sql . I've tried using bulkcopy.ColumnMappings.Add but you're giving me an error.    System.InvalidOperationException The given ColumnName does not match   up with a...
asked by 17.10.2017 / 13:37
2
answers

Move only part of a text to another column

I have a spreadsheet according to the attachment that in the backyard column is the address and the number, however, I want to separate, that is, remove the number of the addresses that are in the backyard column and move to column number at one...
asked by 07.07.2017 / 15:42
2
answers

Excel: Create scale with 2 known points

Hello, I have a problem - which I believe to be much more mathematical than a formula in Excel. I have a list with percentages of results and I need to "stagger" those values according to two known points. o MINIMUM VALUE = 25 POINTS...
asked by 23.06.2017 / 14:52
0
answers

Generate an excel file in vb.net without excel installed

Hello, I have an application that generates Excel spreadsheets, however some users are having several problems (users without a license or without the office). Today I use the COM method (using the office dll). I would like to know if there i...
asked by 22.08.2017 / 14:55
1
answer

VBA macro for automatically inserting images based on a code column

Good afternoon, I have a spreadsheet, which has a column with the code of the photos and the other column next to it with spaces to insert the images. I would like to know if there is any way to elaborate a macro, in which it recognizes the c...
asked by 30.03.2017 / 18:58
0
answers

Machine Learning using R and excel [closed]

Hello I have some data that I tab in excel monthly, which is very repetitive. I would like to know if there is any way to use machine learning in R to teach an algorithm, based on the data I already have, to fill in the new incoming data. Basica...
asked by 15.02.2017 / 12:25
1
answer

Excel - Match rows in another file

The question is: The question is: I have 2 csv files, one of them has only one email column with several lines of valid emails, I also have another file that has the same emails and some more, in this file there are other columns like Country...
asked by 31.07.2017 / 18:23
2
answers

The conversion failed to convert the varchar value 'No' to the data type tinyint

I am trying to solve an error I think of converting a variable created by me to store data that is in an Excel sheet. The error happens when I try to insert the data that is in this variable in the SQL Server , that is in the (query)....
asked by 03.03.2017 / 18:11