Questions tagged as 'excel-vba'

Tagged questions
0
answers

EXCEL - How to remove ALL duplicates - not just the duplicate

I have a problem that is getting worse every time .. I have a spreadsheet of user data for a company - where the key is the email of the official. I need to update this listing on a monthly basis including the NEW contractors and EXCLUDE t...
asked by 15.06.2018 / 17:44
0
answers

Move filter button

When I add a table to my worksheet, it already comes with the filter drop down by default. I need to take this button out of that column and move it out of the table, or copy the button out of the table and hide the table button. @ E...
asked by 26.05.2018 / 05:31
1
answer

Delete table rows through VBA

I'm having a hard time deleting rows from a table, not just the content, but this does not affect the rows in the worksheet. I saved a macro that resulted in the following code: Range("Tabela193").Select Selection.ListObject.ListRows(1).Dele...
asked by 30.04.2018 / 18:42
0
answers

Database photo

I have a spreadsheet that I need to put photos by pulling from a database. The trigger would be the product code. When you enter the product code, the photo of the product would go up to the spreadsheet automatically from the database to a sp...
asked by 20.04.2018 / 15:14
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
1
answer

Formatting charts in Excel

How do I get the information from a server using mysql when this information appears in the spreadsheet with already formatted chart in excel?     
asked by 10.04.2018 / 15:03
1
answer

How to hide a table in excel without resizing the chart

I would like to hide a table but it feeds a chart, I would like to do this without resizing the chart. This graphic uses selection buttons that have been formatted with macros.     
asked by 10.04.2018 / 13:40
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

Transform html data within txt into Excel tables

I'm trying to transform some data that is in html and are within a txt to .xls in table form, that data is pertinent there is an email body that extracts, if there is any other idea I might be pulling that body and playing as xls would help me a...
asked by 13.03.2018 / 19:18