Questions tagged as 'vba'

Tagged questions
1
answer

How do I change a cell based on the value of another cell?

Problem: Importing data does not come with leading zeros I imported data from a text file, however, even if I configured it to import in TEXT format, the cells of a column that were in the 08 file are only imported as 8. As I'm going to use t...
asked by 03.11.2014 / 18:11
2
answers

Moving images in VB6

Option Compare Database Private Sub Command0_Click() Do Until Me.Width < 4000 Let Image1.Left = Image1.Left - 5 DoEvents Loop End Sub As this allows you to move the image from right to left, how do the image to rotate t...
asked by 05.06.2014 / 14:00
0
answers

How to extract data from the internet by VBA

I'm trying to extract a specific table from a site and paste it into a worksheet to update a database on a daily basis. But as it is impossible to download the table as excel or csv, I should extract the table directly from the site....
asked by 03.01.2019 / 14:40
0
answers

How to select files through list by vlookup or VBA

I need to parse multiple files in .XLSX that are in several folders and generate the data graphs, all .xlsx files have the same amount of rows and columns in a spreadsheet with a specific name. I've created another file so that...
asked by 21.12.2018 / 15:52
1
answer

Error when pasting data in Excel with VBS

I have a simple spreadsheet in Excel (3 cols and 2 lines) and I'm trying to create a script to open it, copy its data and insert it into other worksheets with the same structure using a form. Private Sub UserForm_Initialize() Call AddWorkB...
asked by 01.12.2018 / 12:17
1
answer

VBA - How to identify last active line, when has formula

The code below identifies the last active row of the worksheet. When column A is populated manually it works. But when I put a formula to fill that column according to another worksheet. The code does not stop. For example: the spreadsheet h...
asked by 05.12.2018 / 14:53
2
answers

VBA Copying Brazilian Standard Date in American Standard

I have the code below in a macro, to copy a separate TXT file with semicolons to an Excel file: Sub Atualizar_Dados() Application.ScreenUpdating = False Application.DisplayAlerts = False 'Abre o arquivo do servidor (mudado para txt ao in...
asked by 23.11.2018 / 11:36
1
answer

Add information that is per row in a column in excel

Good morning My goal is to transpose these 2 lines into vba (in this case 6 lines) That is, what I want is to repeat the whole information but then I just want to have a privileges column even if I have repeated all the rest of the informa...
asked by 21.11.2018 / 12:10
0
answers

VBA - Generate a PDF file of various Excel

I'm trying to make a code to generate a PDF for every Excel file I have in a folder. First of all my code generates a PDF each excel file and then generates a PDF that would be the cover of all these files. The problem I am having is that it...
asked by 14.11.2018 / 16:45
0
answers

VBA Programming - Recursion, Boolean Backpack

I have a situation similar to Boolean backpack. I have a table with N lines. Column 'A' contains a footage (m²), column 'B' contains a price (R $). I need to get all possible sums of column 'A' up to a certain value in meters (x) and, the bes...
asked by 07.11.2018 / 16:23