excel

Good afternoon Community, I am trying to work with VBA in Excel to try to apply this knowledge in my master's thesis, but I ... ne camera, I'll probably get to other cameras of different areas and placed at vertices different. Thank you for helping me.

Hello! I am going through great difficulty with a problem using VLookup in Excel VBA. First of all, I am not an expert in VBA ... t when inserting the example "91T", the code deletes from the table all rows that include smaller letters and larger numbers.

I need to copy a chart and paste it as an image in the same worksheet. I'm trying to select the range that contemplates the ... wdPasteMetafilePicture End With And the error 1004, Erro de definição de aplicação ou objeto occurs. Can anyone help?

I need to copy a track from an Excel spreadsheet that contains a graphic schema made with borders around some cells, with som ... t needs to present the current image, how many times the user wants to refine this image. How to solve this the way I need?

I own the worksheet below with the following columns: I would like to generate a second spreadsheet based on the above in ... nce the original worksheet is exported from another site in the format .CSV, where I used the Convertio to generate the .XLS.

I created two Labels dynamically based on a vector according to the code below, however, in the form only the last Label crea ... With NewLabel(1) .Caption = "NewLabel1" .Top = 20 .Left = 20 End With ... ... ... NewLabel(0).Delete NewLabel(1).Delete

We are setting up a routine where when filling in a cell (C1, for example), date (A1) and time (B1) are automatically populat ... 2).Locked = True ' aqui devia bloquear ' religa a captura de eventos Application.EnableEvents = True End If End Sub

I want to generate a file .xlsx, with the records that were not imported, from another table .xlsx, but I can generate the fi ... nt-Disposition: attachment;filename="teste.xlsx"'); header('Cache-Control: max-age=0'); $objWriter->save('php://output');

I want to import data from a sheet but from sheet 2 and I'm not getting it. I indicated sheet 2 (index 1) as active in this w ... scape($val['3']) . "', phone = '" . $db->escape($val['4']) . "', company = '" . $db->escape($val['5']) . "'"); }

I have some tables with store names and I would like to know the sum of values of these stores that is in different spreadshe ... not right: =SOMARPRODUTO(('2014:2015'!C3:C3069=Tabela1[@LOJA])*('2014:2015'!D3:D3069="RESULTADO")*('2014:2015'!E3:E3069))

How to make excel Procv function in javascript; Ex: I have a table with 2 columns (name and code) and I have a list only ... {"Numero":45678,"Nome":'Joao'}, {"Numero":8907,"Nome":'Paulo'}, {"Numero":340,"Nome":'Maria'}]

I have two spreadsheets in Excel. In the first I have the following data, for example: ID | NOME -----|---------- 100 | ... | Livros 101 | Pedro | Games 101 | Pedro | Móveis 102 | Aline | Filmes Is there such a possibility? Thanks.

I have a table of banks and codes in two columns. Ex.: Banco do brasil S / A 001 State Bank of Rio Grande do Sul-Banrisu ... t of the name is written, How do I look in an entire column for an expression within the one text of each cell of the column?

I'm in doubt and I can't get a plausible answer. I have a spreadsheet in which I would like to make a comparison between two ... aid value is not found in Column " B " it can be moved. I am very grateful if anyone can help me with a VBA or even Formula.

How to program one macro to delete another? Would it be something like, when, do I need to call? Ex.: Sub callmacro() Call ... ro1() Dim i as... For i = 0 to... ... Next 'e aqui, depois de uma serie de comandos, a macro se auto excluiria.' End sub

I found no reference about the event that is triggered by the right mouse button on a frame object. With the Left Mouse Butto ... s there a corresponding event when right-clicking to the frame object? Update See the solution found in the answer below

I'm starting to use VBA with the Office package, as I still know little I'm having a hard time picking up this functionality. ... o cell B2 and so on. I know you can do this with formulas, but I need the VBA syntax to start doing something more advanced.

First, I have a newsletter system that I modified for email marketing, it is all in PHP (obvious) and first, I add the emails ... I use phpmyadmin no I know if it helps to specify... If you do not understand you can comment that I try to explain better.

I have a list of items in a dropdown in excel. These values must be selected by the user and from dai, edit it as requested. ... dropdown values. Can anyone help me? Below follows example of two items that must be selected and then changed by the user.

I need help. I have a query in php and Mysql and I would like to add to this query the option to export the data also to exce ... "; $qr = mysql_query($sql) or die(mysql_error()); while($exibe = mysql_fetch_array($qr)){ //Todos os dados a serem mostrado