Questions tagged as 'excel'

Tagged questions
1
answer

Is it possible to retrieve the selected values from a multiselect list box (not active X)?

Is it possible to retrieve the selected values from a list box (Form Control) with the multiple selection option, by formula or Vba?     
asked by 09.01.2017 / 14:03
2
answers

Error '15 .0 'is not a valid floating point value when saving .xls

When trying to save an .xls file I'm having the following error:    '15 .0 'is not a valid floating point value I'm trying to save it like this: var HCalc : THojaCalc; vArquivo : String; vArquivo := 'C:/MinhaPasta/Arquivo.xls'; //dentr...
asked by 29.07.2016 / 14:00
2
answers

Calculate date with JavaScript or otherwise, even in excel? [closed]

How to arrive at an end date from a start date multiplying by N weeks, not taking into account the last week of the year. I can even calculate the dates, but I can not deduct the last week.     
asked by 13.06.2016 / 02:34
1
answer

Is there any way to read an XLS file and manipulate it in Python?

Is there any way to read an XLS file and manipulate it in Python? Does any library allow this?     
asked by 08.08.2016 / 02:31
1
answer

Excel vba - HttpRequest GET

I'm trying to do a GET in VBA in Excel, and found several examples, below what I'm using: Sub http() Dim MyRequest As Object Set MyRequest = CreateObject("WinHttp.WinHttpRequest.5.1") MyRequest.Open "GET", "http://www.google.com",...
asked by 27.05.2016 / 22:30
1
answer

XML Mapping in Excel 2013

I have a spreadsheet where on each line I register a test case and then export it to XML, and then upload this xml to another system we use. The problem is that I can only do 1 to 1, I can not fill several rows and then export all, when I do...
asked by 24.10.2016 / 20:13
1
answer

Auto run macros in Excel / VBA

I made several attempts to execute a macro when starting Excel as indicated in the searches I did, although these indications are very simple, in my case they did not work. I followed the following script: Double click on "This_work_fold...
asked by 02.04.2016 / 17:48
1
answer

Hyperlink Customization in excel

Does anyone know if there is any way I can create a hyperlink in a cell in excel where the value specified in this cell is passed to the id value of a URL? Example: Cell with value: 100531, when clicking on it, call a url link where VALORDA...
asked by 22.08.2016 / 23:16
1
answer

Skip column to each N counted lines

I need help with vba. When inserting values using linetype, I want to change columns, with each N number of lines. For each 100 counted rows and values entered automatically, the column is altering and the row count resumes in a new column. I...
asked by 09.02.2016 / 19:46
1
answer

Prevent Macro Using MAC Address on the Network

Is a spreadsheet available on the network, can be prevented from running a macro if the machine is not "authorized"? I need to block certain users or PC's by using the MAC address for example.     
asked by 24.02.2016 / 22:58