Best answeres tagged with vba

answers

Select ABA - SAP SCRIPT

Good afternoon, folks, How can I select my open tab in SAP. In the format below it selects the first open tab of the sap, how do I choose the tab that should open, or at least activate, when a new ABA is opened: If Not IsObject(applicati...

asked by 26.07.2018 / 22:48

answer

VBA code to delete line

Well, I have a code that checks the line if there is a word or phrase and deletes the line: If Mid(Cells(i, 10), 1, 50) <> "Defeito" Then Rows(i).Delete Shift:=xlUp But in the spreadsheet there are phrases like "Defect + broadband" or...

asked by 07.05.2018 / 21:12

answer

VBA Module that stores data from one cell and moves it to another cell and moves to the cell below

Good evening people, I created a folder with macro where I have two spreadsheets, Query and games. In the games spreadsheet I put game names and their respective values in real, already in the query I created a list to do the autocomplete with c...

asked by 08.08.2018 / 22:54

answers

Excel VBA with Array's slow taratar data

I am developing a code to be applied in excel that summarizes the number of defects in a summary table. The data is imported from an xml file, which is opened by excel and created the "layout" by it. As it is the first time I work with array's a...

asked by 25.06.2018 / 03:23

answers

Doubt about Excel textbox control

Everyone, good night! Reason for my coming here: I have a Textbox control in an Excel Form (VBA). This form is configured to accept line breaks with ENTER and multiline. However, when sending this information to a javascript control it does not...

asked by 26.05.2018 / 04:25

answer

Year / Month / Day ... how to do

But I need it to generate a folder for year, month and day Can someone help me? follow ... ' informacoes Public cDay, cMonth, cMonthName, cPath Function identificarData() ' Identificar o caminho na rede cPath = "caminho para salvar o a...

asked by 29.05.2018 / 19:50

answers

Which alternative can be used to DSN in Windows 10?

Previously in VB it was possible to create DSN connections via code, Microsoft has currently disabled this option, is there any other similar connection that replaces this form of data source?

asked by 22.05.2018 / 19:23

answer

_ _ erkimt Search for items that are in within a given month of the year ____ qstntxt _

I need to mount a macro for a spreadsheet I'm working on. I have a table with several columns in the %code% tab (in the date column there are several dates with day month and year type "22/02/2018), and I needed a macro to, when typing a month and year (" 02/2018 ") in a cell in the billing tab, copy the rows whose date cell is within this month.

I do not need to copy the whole line, just certain columns that I will determine as needed.

____azszpr300707_
Your code will be something similar to the one below. Change the columns of the %code% object to the columns you want.

Note: I put two dates: one for the first day of the month and one for the last one, to mark the interval. Then you will either want to enter two dates instead of one month.
%pre%

___

I need to mount a macro for a spreadsheet I'm working on. I have a table with several columns in the ordem tab (in the date column there are several dates with day month and year type "22/02/2018), and I needed a macro to, when typing a m...

asked by 16.05.2018 / 17:59

answers

PRODUCT REQUEST in Excel with Product Photos via VBA

I am developing a PRODUCT REQUEST in Excel via VBA. In this request, besides the description of the Product - item by item, I have the sizes of the same (I already did); However I am not able to bring to this PRODUCT ORDER, the photos of the pro...

asked by 08.05.2018 / 15:19

answers

How to loop in VBA from autofilters using value "differing from"

Good afternoon, doing an automation in VBA in which I need to loop through filters on different lines (sequential values from 1 to 95) but my selection will be with the filter criteria "other than". Copy the excel tab to a new worksheet, sele...

asked by 08.05.2018 / 22:45

Questions tagged as 'vba'