Questions tagged as 'vba'

Tagged questions
0
answers

Macro Slicer runtime error '1004' application-defined or object-defined error vba excel

I need to create a slicer that affects all the pivot tables that belong to certain types of work orders. For that first I create the slicer from a pivot table, and then I try to add the other pivots by means of a macro Sub Button13_Click()...
asked by 24.08.2018 / 23:55
1
answer

VBA Acess - List Box (ListBox)

I want to make a List Box (ListBox) in Access 2010 not have any element selected by clicking on a button on the form. What VBA code could you give to do this?     
asked by 13.08.2018 / 13:37
0
answers

Configure printer profile of the word VBA

Does anyone know how to access this VBA parameter? Or using a .bat file. I've already tried to record the macro but I do not take it ... The one in orange Thank you very much.     
asked by 14.08.2018 / 15:21
0
answers

SELECT query * FROM Does not bring all the data

I'm doing a query from one excel file to another. Through a recordset with the method SELECT I bring the columns that I want to my base, the problem is that I have a column Date de Facture with data type DATE (04/01/2018)...
asked by 09.08.2018 / 12:43
0
answers

Play MP4 files, without creating a playlist

I am creating a learning system for children through cards that have an animal and a bar code. The idea is to play an initial video, in LOOP, asking the child to choose a card and pass it through the reader. Then the system shows you a video of...
asked by 12.08.2018 / 20:48
0
answers

property oleobjectblob in TBcould not be set vb.6, property oleobjectblob in TB could not be set vb.6

Inherit an application in vb6 in the office, that is created by another person and when I try to open everything is fine, but I get two problems and in the log it tells me that:    Property oleobjectblob in tbtn could not be set...
asked by 02.08.2018 / 17:12
0
answers

How can I pass a file with txt extension to excel? (Visual Basic)

I need a code that allows me to select a specific txt file from a path and pass it to a selected excel sheet. The problem arises with that I want a specific txt file and that code is done so that it grabs several files of the same route...
asked by 25.07.2018 / 17:36
0
answers

Macro error print chips in pdf

I'm working on a code to execute a macro that prints different sheets of a book in Excel based on a series of variables. Step by step, the macro executes correctly at 100% but from its assigned button, the cards are printed correctly, except...
asked by 31.07.2018 / 14:58
0
answers

Question VBA Sub paste within sub paste VBA

I am working on a macro to copy and paste data into a table and into the blank cell that is available consecutively. However, there is data in another sheet that I want you to paste the data after the first SUB that ran. I mean I want you to...
asked by 20.07.2018 / 18:39
1
answer

Access 2010 - VBA Load Memo-type data in a text box of a report. Insufficient space

To load some data into an Access report, I use the following VBA code: Private Sub Report_Load() Call Acceso_Informacion Dim basica As DAO.Database Dim tabla_ejemplo As DAO.Recordset Dim Texto As String Set basica = CurrentDb Set tabla_ejemp...
asked by 11.07.2018 / 17:13