Questions tagged as 'excel-vba'

Tagged questions
0
answers

Error in search box blocked worksheet

The command is great, but I include a search command with box box and every time I search if the worksheet is locked with password the search does not work. Well, informs that you need to unlock the worksheet, can you help me? Private Sub Codi...
asked by 06.12.2018 / 19:03
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
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

Get the username of a login in Excel

Good afternoon. I have a login in excel that generates a Users log. I can put in a worksheet cell the name of who logged in, but when another user logs in, the name of the previous User also changes. I need every record to keep the name of who l...
asked by 13.11.2018 / 13:48
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
2
answers

Add paragraph in vba

I have several cells that I want to concatenate to send an email through excel It turns out that every cell I would like to have line breaks but I am not able to I have already used WrapText and Chr () but it is not working, can someone he...
asked by 26.10.2018 / 14:00
1
answer

VBA to send email

I have a VBA code to send a range as an image, through outlook. But it does not always paste the image into the email body, but rather a part of the spreadsheet. Is there something wrong with the code? Thank you Sub EnviarEmail() Dim outApp...
asked by 18.10.2018 / 22:11
0
answers

Exporting objects in Qlikview

I know that for objects of type / ID = TXT, we export as follows: set cs = ActiveDocument.GetSheetObject("TXT111") set XLApp = CreateObject("Excel.Application") set XLDoc = XLApp.Worbooks.Add XLDoc.Sheets(1).name="Export text object" setXLShee...
asked by 18.10.2018 / 22:25
1
answer

Save php parameter in vba variable

I have form that I pass one parameter and at the same time opens an Excel worksheet.  Here's an example: <?php if (isset($_GET["param"]) && !empty($_GET["param"])) { $param = $_GET["param"]; exec("START teste.xlsx $...
asked by 15.10.2018 / 23:05