Questions tagged as 'vba'

Tagged questions
0
answers

Select in VBA Error 1004

Good evening My spreadsheet has a button where it will open a Form. This Form has a LIST VIEW where the data of a worksheet sheet is loaded. So far so good. Also in Form has a button to filter the LIST VIEW data, based on the values selected...
asked by 29.06.2017 / 03:41
0
answers

VBA x IE - collect data from a table

I'm programming in VBA a collection of information on the central bank's website. It turns out that the page does not load fully and when the macro ends only a few records have been loaded in the worksheet. I believe the page has some event that...
asked by 09.06.2017 / 16:47
1
answer

How to run macro with project locked?

Hello, I have a spreadsheet whose project has a password, but I want the macros to work and if the user tries to enter the macros they will have to enter the password (which I put in the project). I put a code that unlocks the spreadsheet upo...
asked by 21.06.2017 / 16:17
1
answer

How to convert multiple .XLSL sheets to .CSV from a book and export it individually to the desktop?

I want to save multiple sheets by the name itself. And that are converted from .xlsx to .csv (separated by commas).     
asked by 31.05.2017 / 21:59
1
answer

How to convert Pounds into Euros VBA?

CONVERSION: The conversion will be the value in Pounds x 1.17 = Amount in Euros. To be able to add a percentage the formula will be Pounds x 1.17x (1 + percentage). METHOD APPLIED: Substitution of the column of pounds 200% with% 50 to 250%...
asked by 01.06.2017 / 12:35
3
answers

Pick up the selected value in a cell and subtract with the value of combobox in vba

Good afternoon, I have the cell selected and now I want to get the value of that selected cell and subtract it from the value of the combobox and then pick up that result and put it in the selected cell. So far I've made this part of the c...
asked by 22.05.2017 / 13:24
1
answer

Excel vba: Saving data from a spreadsheet in .txt format

Good afternoon. I have the macro below and it already does almost what I want (it creates a txt file with the data of the Historico worksheet, always rewriting the file, that is, it does not create several copies), however this History sheet con...
asked by 22.05.2017 / 20:03
1
answer

How to implement in VB .ASPX the action of the ENTER key as TAB?

I would like to know how to implement in the boby onKeyDown event of the .aspx file so that when the ENTER key (code = 13) is pressed it behaves like the TAB key (code = 9). This is generic so it can be reused on other screens.     
asked by 16.05.2017 / 17:07
2
answers

Querying Data With VBA Filter

Good evening, good evening I have a problem with VBA, can you help me, please. Following: I have excel with Sheet1 and Sheet2. On Sheet2 I have a list of clients where I have the following data: Name, City and Age. InVBA,Ineedtocopythe...
asked by 31.05.2017 / 06:21
4
answers

Excel transpose row to column and preserve columns and replicate them online

Good morning! Next, I have a csv as follows A; B; C; D; 1; 2; 3; 4; 5 E; F; G; H; 6; 7; 8; 9; 10 The columns of letters have a regular structure, and those of a number not but it could explode them and put them in columns but it will...
asked by 10.05.2017 / 16:59