Questions tagged as 'excel'

Tagged questions
1
answer

How to use the name of a cell in the Excel worksheet in VBA, so that it does not indicate row and column?

How to use the name of an Excel spreadsheet cell in VBA, not to indicate row and column? For example, I gave the name "CustomerName" to cell B20, when I use this name in VBA to put in the label (label1.caption = CustomerName), it accepts and...
asked by 23.11.2015 / 22:19
1
answer

MACRO in Excel - print with sequential numbers

I have a macro from a few years ago that still works, when I click to print the production orders of my company, I put the start and end number, and the macro prints the OPs with the numbers in order, follows the macro : Sub PrintJobs() Dim i...
asked by 12.11.2015 / 13:55
1
answer

Force numerical format / language for the document

Where I work, it is very common to have problems with excel macros, which generate tables and graphs, depending on the language and version of Excel the client is using. How to force a language (for example English) and consequent numerical f...
asked by 06.04.2015 / 17:00
1
answer

Separate result in different worksheets

I have a problem in which I have to get all my information (information from each cell of the worksheet), make them go through a condition and for each condition result write to a new worksheet of a new file. For example, I have the test.xls...
asked by 03.09.2014 / 15:31
2
answers

String Connection excel .xls .xlsx C #

I have a connection string with excel, but it is only .xlsx and is giving this error    ServerVersion = 'connExcel.ServerVersion' threw an exception of type   'System.InvalidOperationException' I need a connection with both at the same ti...
asked by 02.09.2014 / 16:00
1
answer

Split a string

I am trying to make a simple code using split , but there are some errors that I am not able to solve .. in% with% with asterisk VBA informs me that if is out of range .. Sub Getinstrument() Dim instrument As String Dim splitinstr...
asked by 10.09.2014 / 18:02
1
answer

Excel 2007 - Buttons to create / remove rows

I have a table in excel with one line only (plus the header) and six columns. The entire sheet is protected except this line. At the end of the table I wanted to have a (+) button that adds a new row, and a (-) button that removes the last ro...
asked by 05.06.2014 / 15:59
1
answer

How do I import data from a spreadsheet in excel (csv) into an HTML table?

Hello, I'm making a website, which contains a table, but the data in this table needs to be imported from an excel sheet that I have saved here on my machine. Can anyone help me? If possible, I would like to use pure javascript     
asked by 21.02.2018 / 18:34
2
answers

Copying rows from one table that match one criteria and pasting into another Excel sheet

Hello! I am something new in VBA and I have gotten what I want through the macro recorder. However, I think that in this case I will not get what I want through this feature. I'll try to be clear on my goal. My Excel sheet is called "A3"...
asked by 28.02.2018 / 14:54
1
answer

Keep information in date format with PHP?

I have the following information in a file .xls 12/12/2017 10:34:03 but when I show in the browser with PHP it appears like 43081.4403125 . do you have any way to keep in date format ? I'm using the PHPExcel library to get t...
asked by 15.12.2017 / 20:05