Questions tagged as 'excel'

Tagged questions
2
answers

Create ComboBox in Excel cells with VBA (not with UserForm)

I have a question, I'm a bit of a rookie with Visual Basic for Excel but I've done something, but now I have a question. First I want to create a Select or Drop-down List or ComboBox (as you want to call it) but I do not want to do it with Us...
asked by 10.02.2018 / 02:08
0
answers

Form an excel to another excel

I would like to see if you can help me with this doubt that I have, you will see I have two excels one formulated and another one that sends me a company as a report. I explain the report they send me is a total of accumulated from a company...
asked by 19.02.2018 / 20:25
1
answer

Blueprism, put current date as the name of an excel in Blueprism

I'm new to BluePrism. I have a file "file.xlsx" and I need to move it from folder and change its name. The name must have the format "file_ddmm.xlsx" ("ddmm" Current day and month). I hope you can help me or give me an idea of how to do this, in...
asked by 29.01.2018 / 15:56
0
answers

Load Excel in DatagridView

using the package nuget ExcelDataReader v.2.1.0 Excel upload button: using (OpenFileDialog ofd = new OpenFileDialog() { Filter = "call_center|*.xlsx",ValidateNames = true }) { if (ofd.ShowDialog() == DialogResult....
asked by 05.02.2018 / 23:22
1
answer

Increase Box Spout speed

I have an Amount or load with Box Spout but I do not see the difference in speed increase with PhpExcel, Can someone tell me if I'm doing something wrong? <?php error_reporting(E_ALL ^ E_NOTICE); ini_set('display_errors', TRUE);...
asked by 26.01.2018 / 21:29
1
answer

Error importing an excel file into VB.NET

Greetings to all, it turns out that I am doing an importer that consists in uploading data from an Excel file to a table made in SQL Server (In an app made in VB.NET), I am adapting a code according to my needs and when importing the Excel file...
asked by 24.01.2018 / 00:24
1
answer

Fix column in excel with php

I have the following lines $objPHPExcel->getActiveSheet(0)->freezePaneByColumnAndRow(0,4); $objPHPExcel->getActiveSheet(0)->freezePane('A'); which gives me the following result: I intend to fix column A but I think that the lin...
asked by 24.01.2018 / 17:03
1
answer

Error #Value based on excel

Good morning I am creating a formula that when writing a number called RTN, I returned the name after a web query, for example I put the number 08019002275485 in the RTN box and it returns the results of which I need the name "CONSULTING COMP...
asked by 19.01.2018 / 12:28
1
answer

MACRO TO FEED AN XLS FILE FROM N ARCHIVES

Macro to feed an xls file from several (the amount may vary) xls files contained in a specific directory. The format is the following: Source files: Contain a header and a single record below it. (A1: I2) Destination file: Must contain...
asked by 08.01.2018 / 21:14
0
answers

Search and replace all in Word with data from an Excel spreadsheet

I have a long document in Word that has a lot of data with the format ES- and 4 numbers that are changing ( ES-0006 , ES-0015 , ES-0164 , etc.) , and I need to change them for others that I have in an Excel sh...
asked by 27.12.2017 / 23:20