Most voted "office" questions
23 questions
Sort by count of
-
6
votes2
answers1419
viewsAlternatives for VBA development in Office
At work I have a large code base written in VBA (approximately 13 active projects), both for Access or Excel applications. I’ve been trying to refactor some things, but several factors are making my…
-
6
votes3
answers1307
viewsCount elements between two quantities
I’m creating a Dashboard to a religious organization, which will include the age group of its members among other data. The ages of registration and promotion among their religious education classes…
-
5
votes1
answer3351
viewsMACRO in Excel - printing 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…
-
4
votes2
answers1998
viewsOpen xls (password protected) file in Delphi and save data in Firebird table
I have an office file (.xls), password protected, which has several lines. I want to search the contents of the column 1 and knowing the row that the result is found I want to save this single row…
-
2
votes1
answer443
viewsTurn multiple columns into one
Hello, I do not program VBA and I am not able to make a code that did 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…
-
2
votes1
answer5260
viewsVBA code to delete line
Guys, I have a code that checks the line if there’s a word or phrase and deletes the line: If Mid(Cells(i, 10), 1, 50) <> "Defeito" Then Rows(i).Delete Shift:=xlUp However I in the spreadsheet…
-
1
votes1
answer1815
viewsError using Javamail with Office365 account
I have a Java class that works perfectly to send emails through a Gmail account. However, even using the recommended settings to send an email via SMTP with Office365, an error is returned. The…
-
1
votes2
answers1837
views#REF! when deleting cells in another spreadsheet
Good morning, I have an Excel file with two spreadsheet, in 'Plan1' all data are deleted, and a MACRO I made, imports a TXT file and populates the 'Plan1', inserting data and calculations. In…
-
1
votes0
answers194
viewspowershell script for offline office key decryption
I removed from a PC "dead" the key from office 2007 that was in the register Now he was modifying the popular " Search-Registrykeyvalues " script to directly pass the decryption value. But I’m not…
-
1
votes1
answer93
viewsUpdate an Access application
What is the easiest way to upgrade an Access desktop application with VBA to a web application with sql server?
-
1
votes1
answer49
viewsSharepoint 2007 and 2010 with Office Online 365
I have a demand in hand, the company I work will migrate Office on premise to the online, IE, the office will be uninstalled from the machine and started to use the online. As we use here from…
-
1
votes1
answer2078
viewsxlrd opens files in xls format?
excuse my ignorance on the subject, but I’m developing a Python script that reads Excel files to get certain information on these, and for that I’m using xlrd, I was wondering if xlrd is able to…
-
1
votes1
answer1556
viewsProblem with waterfall drop-down list
Contextualization I am trying to create a drop-down list for cells in the Model column, which depends on the corresponding cell value in the Manufacturer column. The above table is in the tab Plan2…
-
1
votes0
answers97
viewsException from HRESULT: 0x800A03EC
Error executing the following lines of code: Result res = new Result(); foreach (Process clsProcess in Process.GetProcesses()) { if (clsProcess.ProcessName.Equals("Microsoft Excel (32 bit)") ||…
-
0
votes1
answer892
viewsApache POI: how to know if a spreadsheet has come to an end?
I am developing a personal project, and for this I am using Java along with Apache POI to read XLS files, how can I know if the spreadsheet has reached its end? Thanks in advance!
-
0
votes1
answer29
viewsPreview Excel, Power Point, Word on a website
Good morning, I’d like to know how to preview Excel, Power Point, Word on a website. For PDF I managed to do with this code. <embed src="RelatorioM16.pdf" width="760"…
-
0
votes2
answers1366
viewsGenerate an excel file from a data grid C#
I am trying to generate an excel file from a datagrid, and this is generating the following error: An unhandled Exception of type 'System.Invalidcastexception' occurred in Eletronictaxnotes.exe…
-
0
votes1
answer99
viewsHow to compare two columns and return the sum?
Personal talk, I have the following table below, what I want is that it adds the Price (Column D) of all books with the Situation (Column AND) "Sold". I know I can do with the PROCV function. But I…
-
0
votes1
answer2546
viewsPROV between two spreadsheets
The result I should show in column authors of the production sheet is the name of all the authors who wrote that discipline. I am using the following function =PROCV(C8;'Remanejamento'!C3:D55;2) but…
-
0
votes1
answer1278
viewsMacro VBA for Exel - copy data from one sheet to another with one condition
Hurray for you guys, I’m completely new to VBA and a major programmer. I need help to build a macro for Excel. Context: In the Excel book that is found in the following link, I intend to develop a…
-
0
votes1
answer63
viewsSort Worksheet by something by clicking on "explore"
Good Afternoon everyone, I am trying to filter a specific spreadsheet. The idea is to filter a spreadsheet by a subject. By clicking Explore. Example "Worksheet to be automatically filtered" I put…
-
0
votes0
answers87
viewsRuntime error "5852"
I used this code to generate a direct mail and separate the files. But the following mistake is being made: Runtime error "5852" The requested object is not available. Use of office 365 Sub…
-
-1
votes1
answer31
viewsBecause VBA returns #value error
Hello I have the following vba code which is a function that takes three parameters and calculates the functions Bult-in trend and rquad and depending on the result it returns trend or the average…