Questions tagged as 'excel'

Tagged questions
1
answer

How do I open a UserForm with the same name as a button? VBA language

My program consists of 20 buttons and 20 UserForms. I wanted to simplify the program and make a unique Sub Routine. Each time I press a button, the CheckBoxPreview routine analyzes the button name and opens the UserForm with the same button n...
asked by 29.08.2018 / 14:06
0
answers

Site integration with Excel worksheet

Hello, I would like to know if you can use an excel spreadsheet already configured with formulas and records as a "database" for a website. The intention is for the person to access the page, enter the data and send it to that worksheet. With...
asked by 08.09.2018 / 04:37
1
answer

Error 381 listbox.list VBA

Hello! Basically I need to add the values from the listbox, but my program is displaying the following error. Run-time error '381': The List property could not be obtained. Invalid property array index. Private Sub TextBox1_AfterUpdate() D...
asked by 08.09.2018 / 00:55
0
answers

Powerpoint, Excel - Interop with VB.NET

Hello, First of all, I am a new member and I apologize for something that does not comply with the site's policies. I developed an application in vb.net using interoperability with excel and powerpoint. The purpose of the system is basically...
asked by 23.08.2018 / 17:34
0
answers

Fill combobox on WEB page via VBA

I'm trying through VBA in Excel, filling a combobox on an internet page. But when I run the code, that error message appears saying that "The object does not accept this property or method" . Part of the HTML code for the webpage is this:...
asked by 25.08.2018 / 18:46
1
answer

MessageBox in VBA in Excel

Hi, I'm working on a PivotTable in Excel and I would like it when I typed the text store 10, it would display a warning that this store is unavailable, I know I need to call a messagebox however I have no idea what other structure need to use, c...
asked by 23.08.2018 / 20:27
0
answers

Excel, modify duplicate row data

Good afternoon guys. I am very bad at Excel and there has been a demand for me that doing manually will give a monstrous manpower, so I come to you. Here's the scenario. A | B | C | 1- Tiago | | | 2- Tiago | ok |...
asked by 23.08.2018 / 20:16
1
answer

Problem downloading a php export

Good afternoon, I have a script that generates an excel spreadsheet with information, but after the exchange the server started to give problem, before it generated and dropped normally but now only saved on the server the file perfectly. But in...
asked by 22.08.2018 / 20:41
0
answers

Download service file Rest with Ajax

I need to download an Excel (.xlsx) file that is generated by a rest Spring service. Does anyone have an example of how to do this? The controller rest looks something like this: private static final String PATH_FILE = "/home/testes/Arq...
asked by 15.08.2018 / 19:09
1
answer

Zero Page with every click

I have in the figure above this small UserForm with three pages. On the first page, when you click the Enable button, the next date is inserted with TextBox Data as False, so the user does not change. The Enable button also enables the Predic...
asked by 06.08.2018 / 19:02