#DOES PSYSCOPE USE VISUAL BASIC SOFTWARE#
#DOES PSYSCOPE USE VISUAL BASIC CODE#
#DOES PSYSCOPE USE VISUAL BASIC WINDOWS#

Work is subject to general review on an occasional basis.

Understands and conveys more complex messages and instruction, and takes action accordingly.

Offers or obtains specialized information and provides assistance on general matters.

Ongoing involvement outside immediate unit.

Wide variety of complicated job tasks requiring coordinating numerous processes/methods.

Six years of related work experience, four of them in the same job family at the next lower level, and high school level education or four years of related work experience and an Associate degree, or little or no work experience and a Bachelor degree in a related field or an equivalent combination of experience and education.

Screens and refers callers and visitors to the appropriate individualĮxperience, education, and formal training:.

Merges, edits and manipulates data on a personal computer to generate complex reports.

Keyboards statistics, graphs, manuscripts, manuals, slide presentations, and other complex material.

#DOES PSYSCOPE USE VISUAL BASIC SOFTWARE#

Regular, skilled use of more complex machines, including word processors or personal computers responsible for basic troubleshooting and repair or manipulation of data using published software.Composes and proofreads routine formal letters or memoranda for internal or external circulation.Screens complex, technical or specialized literature for referral.Classifies material for filing use of a straightforward or complex filing system.Extracts and compiles a range of data from written sources, from individuals by asking questions, or from one or several given databases, limited interpretation of data.Limited knowledge of University organizational policies and procedures generally detailed knowledge of a narrow area of University rules and procedures.Limited acquaintance with business, accounting or commercial procedures.Specialized college-level coursework detailed but narrow knowledge in one or several work-related areas substantial knowledge of broader field of learning.The duties will vary from incumbent to incumbent in the job title. The job duties listed above are representative and characteristic of the duties required and the level of the work performed in the job title. Performs additional functions incidental to programming activities.Serves as principle source of information for program specifications, requirements and development.Operates computer and related equipment.

Develops written materials and documentation related to programs.

Develops flow charts and programming specifications.

I don't feel like figuring out what this does Selection.SpecialCells(xlBlanks).Clerical and Technical generic job description ThisComponent.getCurrentController().getActiveSheet().getCellByPosition(nCol, nRow).getString() = 'a' You do not need to use the range at all, since you only care about a single cell, so, you get the active sheet and then get a particular cell from the sheet. When you have the active cell, you get the cell address, and from that, you have the row. REM Restore the old selection, but lose the previously active cell OConv.Address = oActiveCell.getCellAddress OConv = oDoc.createInstance('.CellAddressConversion') ORanges = oDoc.createInstance('.SheetCellRanges') REM This leaves ONLY the active cell selected. REM Create an empty SheetCellRanges service and then select it. Here is some craziness to get the active cell: Sub RetrieveTheActiveCell()ĭim oOldSelection 'The original selection of cell rangesĭim oRanges 'A blank range created by the documentĭim oConv 'The cell address conversion service The Cells command returns a specific cell based on a row and column. Range(Cells(CurrentRow, i), Cells(CurrentRow, i)).Value = 'a' Sadly, this can be tricky depending on what your macro does. You must translate the portions that manipulate the document to use the UNO API. I just want to add that the function SinceLastWash gives the correct value in some cells where I use it and in others gives an error, #NAME?

#DOES PSYSCOPE USE VISUAL BASIC CODE#

Is there a way to convert this code to make it compatible with libreoffice or do I have to learn an altogether new language like python? Learning python would not be a problem but is not a solution to my problem as I have many work related files in excel which have a lot of vba code and it is not possible for me to use open office/libreoffice at work. If Range(Cells(CurrentRow, i), Cells(CurrentRow, i)).Value = 'q' Then If Range(Cells(CurrentRow, i), Cells(CurrentRow, i)).Value = 'a' Then Selection.SpecialCells(xlBlanks).Delete shift:=xlToLeft Below is the vba code I have: Option VBASupport The only problem I am facing is that libreoffice, the default spreadsheet package is not compatible with excel macros.

#DOES PSYSCOPE USE VISUAL BASIC WINDOWS#

I have recently migrated to pclinuxos from windows and seem to like it.

Does psyscope use visual basic