Questions tagged as 'vba'

Tagged questions
2
answers

Open only one Crystal screen (preview) - Spring BSS

Is there any way in the event before printing in ERP Primavera to open only one preview of the crystal so that later only one request is spooled of the printer with the paths all together, otherwise it was detected that when printing several use...
asked by 03.05.2018 / 10:27
0
answers

Change button color according to VBA machine status

Well, at the moment I'm developing an app that shows me the status of the lab machines. When I open the form with the scope the laboratory is assigned the color to each button according to the status of the machines. However, now it is intended...
asked by 04.05.2018 / 22:56
1
answer

Transpose data automatically

I have the following problem, I need to create a "robot" that read the data of a certain cell in Excel and enter that data in another software (company's own software in which I work), but it has to "type" exactly the data that was read from tha...
asked by 16.04.2018 / 05:11
1
answer

Spring ERP - Complete diagnostics - Activation code?

I am having difficulty putting the ERP Primavera Diagnostics screen in full operation. It seems to me that I need an activation code to do this. I have tried in the configuration file to put Complete = 1 (did not have any effect)     
asked by 12.04.2018 / 19:16
0
answers

How to use Err.Clear correctly

Good afternoon, guys. This is my first question here in the forum, so I apologize if it is not easy to understand my doubt. Next, I have a script that automates nfs approvals in SAP , but within the loop once it has finished approving, it...
asked by 11.09.2018 / 19:19
0
answers

EXCEL: Form with filling in specific places

InthisimageIhave7"blocks" to be filled via form, they are side by side. As I do in vba a function that fills in these blank fields of TM1 and TM2 automatically, I want to include this function in a form to fill with the forward and back button,...
asked by 14.04.2018 / 05:30
0
answers

APPLICATION VB6 ERROR

From time to time (3 months) an application, which is running in vb6, at times and in some clients, presents the following message. Failed to load control "" from "" Your version of may be outdated. Make sure you are using the version of the...
asked by 14.04.2018 / 21:50
0
answers

Is it possible to import only files with similar names to a worksheet with VBA?

I have several worksheets in separate excell files, and I need to insert the data of each of the worksheets into a specific region of a table, which will perform the analysis of the received data generating a final result. Theprocesswouldtak...
asked by 29.03.2018 / 00:22
0
answers

Certify an executable file so that Windows does not shut it down? [duplicate]

I converted a bat into an executable (.exe), but windows defender does not recognize it and gives as a false positive > Trojan ! Question: Is it possible to certify the executable? Thanks in advance!     
asked by 05.04.2018 / 01:40
0
answers

How to select an item from a listview and change its information in the source cell (where the data is entered into the listview)

I'm having a difficulty on a Form, in which I have information from a plan1 (Database), plan2 (Support for the dynamic filter). Where Plan1 gives me the information about the listbox items, and plan2 serves to work with the filter with several c...
asked by 26.03.2018 / 17:44