Questions tagged as 'excel'

Tagged questions
0
answers

Signing to a web page using macros

I'm trying to do the following: I'm creating a macro that links me to a web page. Sub Reporte() Dim ie As Object Set ie = CreateObject("Internetexplorer.Application") ie.Visible = True ie.Navigate "https://paginaweb.html"...
asked by 14.06.2018 / 17:30
0
answers

Access (Do not open exel files from macros)

I have a macro that brings me the information of a cell X , the macro goes through a list of files and I indicate that I take the value of said cell, but as that file has read key, in the execution of the macro shows me the window requesti...
asked by 06.06.2018 / 03:48
0
answers

Avoid excel messages VB.net

I have an application that makes EXCEL imports, but I get messages that I want to prevent them from coming out. For this, I use xlsApp = New Excel.Application xlsApp.Visible = True xlsApp.DisplayAlerts = False xlsWB =...
asked by 01.06.2018 / 07:37
0
answers

import query with sql pivot to excel

I have a query in sql with pivot that returns the dates in columns, I want to make that query empty in an excel sheet to be able to do operations but for some reason excel it does not matter the data can guide me and more than anything know if p...
asked by 08.06.2018 / 01:31
0
answers

Check values of a cell and insert data according to that value

I'm doing a quote in excel with vba. I have a concern with the following: I need by means of a macro, get me to verify the value of a cell or cells (depending on how many data have been inserted) and then rectify that value in another sheet of t...
asked by 31.05.2018 / 04:30
1
answer

How to search the characters of a cell for a list of values

I have several cells with random characters 123456- foo # 1 -rfjas1 123456rfja- foo # 1 -s1 1- foo # 2 -23456rfjas1 123- foo # 3 -456rfjas1 123456rf- foo # 3 -jas1 I should look for the values foo # N these I have stored...
asked by 01.06.2018 / 16:45
0
answers

excel does not open book

I try to open a book that has been passed to me, and when I try to open it, the Excel (2007) goes gray with everything disabled. The rest of the books do open them. The book that gives problems, does not open in other 2 computers with other op...
asked by 29.05.2018 / 10:01
0
answers

HSSFWorkbook and FileOutputStream java

Good I have a problem in a code of java that I have with these two class when writing in the file it is eliminated what I had before somebody knows some solution not to overwrite the excel file in java, thanks and a greeting. dbf = javax.xml.p...
asked by 22.05.2018 / 11:21
0
answers

How do I personalize the excel that I export from my datatable?

What I want is to update the excel of my datatatable since it contains all the data except one that I must recover from another side and put it in one of its columns. Then I want to do the personalization, jquery code for personalizatio...
asked by 22.05.2018 / 21:37
0
answers

Help with getting data from two excel sheets and compare them

Hi, I'm doing an application to read excel sheets, and I need to know if what I'm doing is the best or if someone else comes up with another idea, tell me before I get into this. I explain the process, first I take the excel file and I transf...
asked by 22.05.2018 / 21:57