Questions tagged as 'vba'

Tagged questions
0
answers

Send Excel macro message to Skype for Bussiness [closed]

I have a code that sends messages via lync but the system has been migrated to Skype for Bussiness . Could someone help me how to mute the code to send. When you try to run the macro it displays the error "Compile error: Can´t...
asked by 10.10.2016 / 15:48
1
answer

How to merge multiple Excel tables into one?

I have 3000 tables as in this example: IneedtomergethemintooneandI'musingthecommand:=ÍNDICE(TXT!$B$1:$B$200,CORRESP(MAIOR(SE(TXT!$A$1:$A$200="Last Name:",TXT!$B$1:$B$200,""),1),TXT!$B$1:$B$200,0)) The problem is that it just shows me the f...
asked by 12.08.2016 / 13:05
0
answers

Connecting Powerpoint to Access via VBA? [closed]

I am creating a type of "urn" in the Power Point would like 3 (three) basic solutions to determine the votes; Clicking the confirm button automatically votes for email , for a given email address; Clicking the commit button automaticall...
asked by 28.05.2016 / 18:14
1
answer

I need help with a Solidworks macro

Basically it has to open the 2d drawing of a selected file from the assembly generate the PDF and close, I got something, but it only works with the path file, I do not know which command to use to make it work with whatever file you choose ....
asked by 30.06.2016 / 03:14
0
answers

How to find the ID of input fields (Texts and Listbox)?

I ran the code below and was able to identify the field ("body_x_tabc_x_identity_x_prxidentity_x_selBscenCode_x_txtselBscenCode_x_x") via the Set objInputs line. But I can not identify the other fields. Among them there are also listboxes. Det...
asked by 28.04.2016 / 21:34
0
answers

View PDF files in VB6

I have a directory on the server that is created according to the book and sheet, where when scanning images it is saved through the book and physical sheets. example: I have a book that I have three pages, the number of the book is 1022 an...
asked by 01.02.2016 / 13:37
0
answers

Help with logic - Verify that the request was made well in advance

I'm developing a script in vba , so it saves all incoming attachments with new e-mail, with extension xlsx . It verifies that it is the right attachment (through a code that the worksheet will have), copies the entire contents of that work...
asked by 26.12.2015 / 17:34
0
answers

How to list download links by VBA

Hello My problem is the following ... I am accessing a website, where I provide login and password and I travel through the pages to my page of interest. I have a function that always lists all active page links in IE. The problem is th...
asked by 26.11.2015 / 13:57
0
answers

Using macros to create toner notifications

I have a spreadsheet, which I'm implementing in a script, which will monitor the toner level of each printer. and each printer can access via the web through an IP. With this script I will be able to monitor the 20 printers I am responsible f...
asked by 21.09.2015 / 20:10
1
answer

VBA - excel does not recognize external data comma

Good morning everyone! I'm trying to integrate excel with other software (the EES - Engineering Equation Solver) through vba code. My program copies certain columns from a table, transfers to the other program, performs the calculations, co...
asked by 15.07.2015 / 15:58