Questions tagged as 'excel'

Tagged questions
0
answers

Excel: Read .dbf file with Ms Query from other sources

Environment: Ms Office 2010, Windows 10 I have not been able to obtain the information from this database with a .dbf extension using Ms Query (from other sources), maybe my data source is misconfigured but I already tried with all the driver...
asked by 18.05.2018 / 17:11
1
answer

Leaves in Macros Excel

I have a problem, I hope you can help me. I have a macro that I collect information from a sheet, in a book, and I take it to another sheet, from another book. Each sheet of origin is recovered with a loop. Up to this point, the problem is when...
asked by 21.05.2018 / 14:31
1
answer

Help in macro excel

I need to know how, after fulfilling the condition, you can copy the corresponding range and paste on another sheet. That is, if row 13, after the iteration arrives, fulfills the condition, the defined range of row 13 is copied and copied in the...
asked by 21.05.2018 / 12:58
1
answer

Report showing all the fields in BD, up to NULL fields

This is my code where an export is made of all my data stored in my DB (reports), but in my BD I have null fields and when downloading the excel report I download all the data that are stored in the BD and I just need you to show in that report...
asked by 21.05.2018 / 14:27
1
answer

Line break in excel

I have a problem with a formula in Excel, I am trying to copy a text from one spreadsheet to another. I have the code that copies it but when copying ignores the line breaks, does anyone know how I could fix this? thank you.     
asked by 16.05.2018 / 21:29
0
answers

Why the first record is replaced

When I enter a form a record is added to the indicated row but after that I add another record and replace it and I do not understand why I think the code is right. Function Insercion(Nombre_Completo As String, Domicilio As String, Telefono As...
asked by 17.05.2018 / 06:41
0
answers

SAP from Excel macro looks different

I have recently learned to implement within an Excel macro a connection with SAP to extract the information that is necessary. The macro works perfectly but, while it is running, SAP looks differently, changes colors and missing elements. This i...
asked by 11.05.2018 / 21:09
2
answers

Export date to excel vba from a web page

I am trying to export from a web page ( link ) the data of the table 1 Colombian Peso Rates table . The problem is that I do not export the date. Someone can help me with that.Annex image of the table to export table and image after exporting t...
asked by 09.05.2018 / 21:05
0
answers

add color to a font in laravel excel

I am generating a query through laravel excel but my problem is that I need to set the color of the font to the first cell and all the examples I have seen are to set the type of font, background, alignment, size, etc. . I appreciate your help,...
asked by 09.05.2018 / 16:09
1
answer

How to obtain the data of an excel with OLEDB Data Provider?

I have a problem because I am trying to read an excel (xls), with the OLEDB, I already install the driver but it does not load the file, this is the error that indicates me. This is my code. try { // CargaMasiva...
asked by 07.05.2018 / 19:21