Questions tagged as 'excel'

Tagged questions
2
answers

Excel: Transpose every 5 cells

Hello, I have the following problem, my spreadsheet has hundreds of data all in the same column this way: ButIwanttofindawaytotransferthesevaluestoothercells,sothatthefirstlineshowsthefirst5data,thesecondrowthenext5,thethirdrowthenext5,andso...
asked by 20.12.2017 / 19:08
1
answer

Activate found cell

I'm having trouble activating the cell that was found. The code is as follows: Private Sub cmdPesquisar_Click() 'Verificar se foi digitado um nome na primeira caixa de texto If Txtnif.Text = "" Then MsgBox "Digite o NIF d...
asked by 06.12.2017 / 17:42
1
answer

How to replicate a value depending on what is inside the cell?

I have a code that always puts 264 empty characters after the last word entered inside the cell; then puts more "00000000000000" after the 264 empty characters and I export to txt, as I show below: MyquestionisdoIhavetoputattheendofthelineaf...
asked by 20.11.2017 / 15:58
1
answer

Follow-up of visualization (pop up)

Hello, I'm having a question about HTML, I need to control how often a pop up pops up, it's scheduled to open every time a computer starts. I need to throw this data into an excel (because of workplace guidelines), every time it opens on t...
asked by 10.11.2017 / 14:56
2
answers

Pass values from one form to another

Dear I have two forms A and B. A = Has the listview and displays information from the base B = You need to receive form A information and display. (Information that is not displayed in form A) I need to make this happen through the l...
asked by 01.11.2017 / 17:01
2
answers

Sort equal queues

I have 4 columns in excel: A, B, C, D right? But I need to sort it to make a comparison because it's all the disorganized information I explain: Original Archive in .CSV (Disorganized Information) A(Inglês) B (Tradução)...
asked by 10.10.2017 / 13:08
0
answers

Import access data to excel based on criteria

I have a table in access and I can even pull its data to an excel worksheet (I can do this using the code below), but I would like to be able to pull only some data (based on criteria such as an advanced excel, only realized between excel and ac...
asked by 18.10.2017 / 18:18
0
answers

Error trying to open an Excel file

I'm trying to open a document in excel via vbScript. I am not succeeding at execution, running is generated the following error, without description:    -2147417851 The problem occurs when you run the following command: Set objExcel = C...
asked by 11.10.2017 / 15:06
1
answer

Web Data Query in Excel

I work in a company and need to monitor the printer toner life on a daily basis ... For this I created a monitoring worksheet, but I wanted a practical system, like this: When I insert the web address into a worksheet cell, automatically n...
asked by 09.10.2017 / 02:25
0
answers

The insert is not working / Excel

I created a process to make a Insert in a worksheet in EXCEL but the data is not being inserted. It returns no error. Code: private void AtualizarPerformanceEntrega() { try { DataTable dt = ExportPerformanceEntrega...
asked by 06.10.2017 / 16:46