Questions tagged as 'macros'

1
answer

Error 1004 in a macro

I created the following macro: Sub Extraer1() 'Definir origen y destino que utilizaremos Dim OrigenHoja As Excel.Worksheet, _ DestinoHoja As Excel.Worksheet, _ OrigenCelda As Excel.Range, _ DestinoCelda As Excel.Range 'Definir las...
asked by 08.05.2018 / 14:27
0
answers

Can you create docm files with javasacript from jsp?

I have a web page that shows the data of a server in tables format. The idea is to save these tables in a master document. Each table being a different document. So far everything works for me. What happens to me is that when you download the...
asked by 07.05.2018 / 09:56
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
0
answers

Copy notes at the end in Microsoft Word

I want to copy the notes at the end of a Word document and paste them into the body of the text without losing the numbering. With this code I can do it (copy the notes at the end and change each reference number in the text) but I can not copy...
asked by 04.02.2018 / 15:48
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

Add rows with macros in EXCEL without having to set a base row to generate the others

I made the following code in VBA (visual basic for application) in EXCEl so that through an associated MACRO, it can generate rows from "copy" a "base" row. The code that I have elaborated is the following: Sub Afilacalcderegulacion() Active...
asked by 17.07.2017 / 19:33
0
answers

Pacman in visual basic for applications

I have a drawback I'm doing pacman in visual basic of excel , what I have is that when I press the keys the pacman moves me the image. I have problems with the walls issue, I have the code so far Select Case KeyCode Case 37 '...
asked by 02.07.2017 / 06:45
0
answers

Copy 2 rows once found a different value

I would like to copy the values from A to D: (2 rows of values per date) to another sheet For example copy the values A2: D2, A6: D6, A7: D7, A13: D13 .... I'm new to programming. I managed to find when the date changed, but then I g...
asked by 09.07.2017 / 11:57
0
answers

Is it possible to send an email, which contains buttons in the body, and with these buttons can be processed actions and how? in ASP.NET

The idea is that from C # you can send an email containing buttons in the body. And the receiver, who reads the mail, can press the button and perform some action, such as opening an application, and even send data to a database. I would like...
asked by 05.06.2017 / 23:10
0
answers

How to activate the paragraph marks in Excel 2013 to visualize the end of the CRLF line in a * .csv file?

I need to activate the paragraph marks in Excel 2013, in word I already identify how to do it, adding this functionality to the ribbon. But in Excel I did not show the option Display (Display) to be able to activate the visualization. Could some...
asked by 04.10.2017 / 23:26