Questions tagged as 'vba'

Tagged questions
1
answer

Prevent Macro Using MAC Address on the Network

Is a spreadsheet available on the network, can be prevented from running a macro if the machine is not "authorized"? I need to block certain users or PC's by using the MAC address for example.     
asked by 24.02.2016 / 22:58
1
answer

Excel VBA - Change cell between True and False

I am making a code but as I am still very green in VBA I do not know how to get this working. It's very simple, I want to load a cell and it will change a boolean between True and False. When I load it, it gets TRUE, but after pressing it aga...
asked by 04.08.2015 / 16:12
1
answer

Problem using common controls 32 bit in 64 bit

I'm having a problem with the common controls in excel 64-bit (checkbox for example), they are required to run a VBA code but in 64 bit version I can not select them. NOTE: common controls have been deployed in 32 bit excel     
asked by 30.01.2015 / 19:39
1
answer

How to send only one spreadsheet per email in VBA and not the whole file using the code below

Option Compare Database Option Explicit Public Const C_Title As String = "ef3.Cinco" 'Metodos Public Sub SendMail(obj As MailClass) 'Nome da classe... Dim appOutLook As Outlook.Application '"Importando" Outlook Set appOutLook = CreateOb...
asked by 26.05.2015 / 23:16
1
answer

Use property R1C1

I want to use the Range.Formula R1C1 property on a check copy form to fill in a nominal check. How could I use this property for this purpose? I found a code described as follows: Sub Para() ' ' Para Macro ' Macro gravada em 4/9/2006...
asked by 10.06.2014 / 10:55
2
answers

How to delete data from a table in VBA Access

I need a command in vba to delete the records from my table REPETIRTEL the moment I close my form. This form does not have this table as the data source, so I need the command to call this table and then disable the delete commit messag...
asked by 13.03.2014 / 20:35
1
answer

Visual Basic Programming in Excel

Using Excel's Visual Basic mode, I'm creating a customer master record form. It has a button called " new ". In this button it would add a value to the Code field that is in the excel worksheet. However, when I test it it displays the following...
asked by 17.04.2014 / 20:58
1
answer

Use the Excel Application object within Access

I am creating a VBA script that exports a table into several excel shared worksheets in a specific directory. The problem is that Excel issues a warning to confirm the save of the file for each file. I would like to delete this confirmatio...
asked by 28.04.2014 / 15:31
1
answer

Problems closing another worksheet by VBA

I'm running the code below for comparing data from different worksheets. It is running correctly, but I am not able to close the data source spreadsheets. I have already tried with '.Close', '.Quit' and '= Nothing', in all ways the 'subscript ou...
asked by 13.06.2018 / 19:36
1
answer

VBA Events in PowerPoint

Hello, Exit some Powerpoint event that allows you to run a subroutine by selecting a slide. For example, the presentation is running ... When you get to slide 120 it has to execute a routine or a macro without any user action or button....
asked by 11.01.2018 / 12:08