Questions tagged as 'office'

3
answers

Count elements between two quantities

I am creating a dashboard demographic for a religious organization, which will include the age group of its members among other data. The enrollment and promotion ages among your religious education classes will be used as criteria. Then...
asked by 13.11.2016 / 20:11
2
answers

Alternatives to developing VBA in Office

At work I have a large code base written in VBA (about 13 active projects) for both Access and Excel applications. I have been trying to refactor some things, but several factors are making my work difficult, like: The IDE that comes with...
asked by 17.10.2014 / 15:26
2
answers

Open xls (password protected) file in Delphi and save data to Firebird table

I have a password-protected office file ( .xls ) that has multiple rows. I want to do a search for the contents of the column 1 and knowing the line that is the result I want to save this single row in a Firebird database table. Example:...
asked by 10.02.2015 / 03:42
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

Turn multiple columns into one

Hello, I do not program VBA and I am not able to make a code that would do the following: |A |B |C | ---------- |1 |6 |11| |2 |7 |12| |3 |8 |13| |4 |9 |14| |5 |10|15| My table has several columns like these up there, I would like you to h...
asked by 22.09.2016 / 17:31
2
answers

#REF! When you exclude cells in another worksheet

Good morning, I have an Excel file with two spreadsheets, in 'Plan1' all data is deleted, and a MACRO I made, imports a TXT file and populates 'Plan1', inserting data and calculations. In 'Plan2' the data is fixed and takes as reference the d...
asked by 20.05.2016 / 15:34
1
answer

VBA code to delete line

Well, I have a code that checks the line if there is a word or phrase and deletes the line: If Mid(Cells(i, 10), 1, 50) <> "Defeito" Then Rows(i).Delete Shift:=xlUp But in the spreadsheet there are phrases like "Defect + broadband" or...
asked by 07.05.2018 / 21:12
1
answer

Problem with drop-down list in cascade

Contextualization I am trying to create a drop-down list for cells in the Model column, which depends on the value of the corresponding cell in the Manufacturer column. TheabovetableisonthePlan2tabInthefilethereisatabwiththerelationofmanufac...
asked by 27.08.2017 / 02:01
1
answer

Update an Access application

What is the easiest way to upgrade a desktop Access application with VBA to a web application with sql server?     
asked by 22.04.2017 / 00:58
1
answer

Sharepoint 2007 and 2010 with Office Online 365

I have a demand at hand, the company that will work will migrate Office on premise to online, that is, the office will be uninstalled from the machine and started using online. Since we have been using SharePoint since 2007 to 2013, I would like...
asked by 27.06.2017 / 13:52