Questions tagged as 'vba'

Tagged questions
2
answers

Check the end of the song and run macro

Hello, I'm making a virtual sound table for an event and would like to give the click effect of the button. I'm doing mega simple, but I need the button to be pressed while the music plays and when it is finished the button will disappear. Yo...
asked by 20.06.2017 / 19:04
1
answer

Add Blank Row Excel Using VBA

I have a spreadsheet with 10k lines, in this format (example): 3004977 \{DOWN} \{TAB 9} REMESSAS \%S 18082017 \{TAB} 2 \%D \^ S 3004972 \{DOWN} \{TAB 9} REMESSAS \%S 18082017 \{TAB} 3 \%D 3004972 \{DOWN} \{TAB 9} R...
asked by 18.08.2017 / 21:36
1
answer

How to change the Excel document icon [closed]

I want to change the excel document icon, to have another face and look like an executable, or something, can you help me?     
asked by 20.06.2017 / 09:35
1
answer

Update an Access application

What is the easiest way to upgrade a desktop Access application with VBA to a web application with sql server?     
asked by 22.04.2017 / 00:58
1
answer

Export SQL query data to Excel

Good afternoon guys. I created a database to control receipt and delivery of cards. The inclusion of the data is done through a form in excel. This form also has the option to query existing data. the query returns the information in the f...
asked by 30.03.2017 / 17:29
1
answer

I can not access IE checkbox element by vba

I'm trying to click on a checkbox in IE using VBA, but I can not access the element of this checkbox. I searched in several distinct forums and the closest I found was that access to a part of the tree might not be allowed. The site is: "...
asked by 03.05.2017 / 21:13
1
answer

VBA: the underlying connection was closed: an unexpected error occurred on a receipt

I have a VBA project that interacts with web pages using the SeleniumWrapper reference. In Windows Vista business the application works normally, however, in Windows 7 appears the error reported in the title of the question Follow the code:...
asked by 10.02.2017 / 15:38
1
answer

Save results from a query to an array

Good afternoon! I need to get the results of this query: sql = "SELECT controle.ID FROM controle WHERE BP = '" & controlectform.nmbpbox.Value & "';" And save to an array. Subsequently I will do a for each in that array and I will...
asked by 03.04.2017 / 21:40
1
answer

How to generate Forms without title bar in VBA / Excel?

I need to work with some forms without the title bar in VBA / Excel. I found many similar solutions, but all for 32 bits (mostly in older versions of VBA).
asked by 22.08.2016 / 23:37
2
answers

How to find next values from the same client

If you can help me with this one, I think it will work for others as well. I'm trying to make clicking on searching the TextBoxes are populated with the client data, and again clicking the Search button the TextBoxes are loaded with the next rec...
asked by 28.06.2016 / 18:35