Questions tagged as 'vba'

Tagged questions
1
answer

Excel tabs that have been saved in html: how to take it up

I made a spreadsheet in excel with several tabs and then saved in html because I want to use it on my site. The tabs on the worksheet are at the bottom, the site user would have to scroll down to change the tab you want, I'd like the tabs to...
asked by 14.09.2018 / 01:25
1
answer

VBA to search for photos in a folder and concatenate file names without duplicating

In February I asked for a code to group photo names that I have in a folder (product photos) belonging to the same product, such as you can see in this other question . My problem has been solved, but I need an adjustment to the code I'm going...
asked by 10.10.2015 / 19:13
1
answer

Drop-down list with repeat criteria

I have a conference list, where in Plan1, column A, only the codons that are in Plan2, column A, will be typed, but with a criterion, only the total number of times in plan2 can be repeated. > To enter in Plan1, only the cods of Plan2 I use...
asked by 30.08.2014 / 03:09
1
answer

Macro to automatically fetch images and play in excel

Good afternoon, I have a spreadsheet, where I need to automatically include images. I would like to know if there is any way to create a macro, where you merge the Reference and the color (reference & color) and search in a certain folder the...
asked by 10.04.2018 / 19:48
1
answer

Check the number of copies that were printed

Hello, I have a table that, when printed, generates a record in a txt, telling the user who printed it, which machine, which printer, which document, and when. But I would like to also record the number of copies, but I have no idea how. Code...
asked by 29.06.2017 / 18:41
0
answers

Change Outlook signature via VBA [closed]

How to change Outlook signature via VBA depending on a particular situation ... In my Outlook I have 2 pre-defined signatures (Internal and External) I already have a Script that identifies when the email is External or Internal Basic s...
asked by 04.05.2016 / 19:12
1
answer

Automatic Logon in SAP BExAnalyzer by VBAProject

(UPDATED) In Excel I have an add-in that gives access to the BI system to access / layer data in a specified / structured query. In my VBAProject I'm referencing the Add-in to call some specific functions of this Add-in in an Auto_Open, that...
asked by 15.05.2017 / 15:50
1
answer

Get the result returned when doing F4

I created a VBA that shows a list of vendors and I can not get the item selected after F4. Public Sub ListaFornecedores() Dim strSql As StdBEStringBuilder Set strSql = New StdBEStringBuilder strSql.Append ("SELECT Fornecedor, Nom...
asked by 09.08.2018 / 18:12
2
answers

What is the difference between a VBA project and a VBA macro?

I was studying VBA macros and I came up with the following question: What is the difference between a VBA project and a VBA macro? Are the two the same thing or do they have any significant difference between them?     
asked by 30.11.2016 / 16:33
3
answers

Check if number is integer in Access

How to check if a number is integer in Access VBA? I've tried If Int(Me.Numero) Then Msgbox "É inteiro" End If But it did not work. I wanted it if I type 8,5 it would return "Not integer". The field is Not Coupled.     
asked by 23.01.2014 / 17:55