Productivity Software Tag Directory

Browse Alphabetically:

Featured Productivity Software Questions

  • VSTO 2013 add-in installation error

    We created add-in for excel using VS 2013 and made an MSI installer (ISLE) to make this add-in to support for Excel 2007, 2010 and 2013. When we run the setup, we are facing issue stating that "Unable to read registry value". Please help me to solve this issue.

    saravanangj5 pointsBadges:
  • VBA Help Needed: How Do you extract from a column a specific color?

    This is my code.Sub Looping() Dim matchFound As Boolean Dim thisIsTheYValue As Integer 'For x= 3 To 6306 'For y = 3 To 1971 For x = 3 To 6306 matchFound = False For y = 3 To 1000 If Cells(x, 4).Value = Cells(y, 9).Value Then ' this is the x column that was the same as the y column Cells(y,...

    rolando05315 pointsBadges:
  • Creating a daily Microsoft Excel formula

    I am trying to create a formula which will total beginning date to present date. But present date is not used in Excel work sheet. How can I set a formula, that will give me a daily count upon opening the worksheet?

    aastra5 pointsBadges:
  • Cross reference macro across worksheets in Microsoft Excel

    My end game is to copy 1st row across 12 calendar sheets starting with 1st sheet (January) and list rows on new sheet then go to next row on 1st sheet to copy across the 12 sheets and list to 2nd added sheet and continue repeating same task for total of 60 rows and total 72 sheets. each row has 10...

    krashnburn7145 pointsBadges:
  • How are various terms used by Google Android, Gmail, & Libre Office writer defined?

    As a newbie, I'd like to understand words like starred, label, folder, circle, folder, Ggroups, chat, contacts, drive, tracker, proxy, footer etc. These are many unfamiliar terms for a non techie.

    kengra5 pointsBadges:
  • Excel data put in Oracle Forms

    Sir, how do I open Oracle Form 6i and make button? And when the button is pressed, how do I import Excel data into my Forms block?

    USAMAKHALID5 pointsBadges:
  • VBA Help Needed: How to Unprotect sheet, Update Stocks on Excel sheet, Reprotect sheet

    I was trying to update some stocks and commodities links on a protected sheet by creating a button to update but before the update occurs the sheet becomes protected. If I disable the re-protection of the sheet it will updated the stocks and commodity prices but the columns width doesn’t adjust...

    abcmustafa10 pointsBadges:
  • VBA code to transfer data from iSeries to Excel

    Hi everyone, could someone provide VBA code to automate the Transfer of data from the iSeries into an Excel 2003 Spreadsheet. Currently we have to manually use the iSeries Excel Add-In. All fields are left default except the Library/File field where we enter PRODDTA/F56EXT. The data then transfers...

    Mblair.au25 pointsBadges:
  • How to get STAAD output (Member End Forces) to Excel by using VBA

    How do I get STAAD output (Member End Forces) to Excel by using VBA? I want to get all member end forces from staad -- .ANL file to Excel. Can anyone tell me the coding for that?

    harshabec5 pointsBadges:
  • Arabic letter is appearing as symbol from AS/400 to Excel sheet

    I have a problem in extraction. When I try to extract a file contain a Arabic letter from the AS/400 to Excel sheet, the Arabic letter appear as a symbols. Is there is anything should I do to solve this problem, considering that the Arabic letter on my PC is working fine.

    osamah205 pointsBadges:
  • Change English numbers to Arabic numbers

    How I can change English numbers to Arabic numbers?

    Mark475 pointsBadges:
  • Converting Oracle Report 6i into Excel

    the problem is in report the data is correct but when i try to convert into excell the dupicate rows are beuing formesd..i also did a page protect variation but report changes but not the converted file. if i have 50 records on page 1 then in report it shws 50 rows only but in xcel it shows 55 rows...

    Programmerjan35 pointsBadges:
  • Default password user report in Excel spreadsheet

    How do I export the anzdftpwd (default passwords) user report to an excel spreadsheet

    DCORDERO4720 pointsBadges:
  • Auto populating Excel fields from an Access query

    How do you auto populate an Excel report leveraging data computed in Access - is there a link function?

    Brigita5 pointsBadges:
  • How to restore Excel files following format?

    I have a document in Excel, opened it and took a few records kept. A day later, open it, and instead of letters only the symbols. I search in Google this problem, found just what you need to try to restore the original document without my changes.

    FritzEberhardt5 pointsBadges:
  • How to open an Excel file

    My Excel file got corrupted and now has now a file extension .xlsx.wzzzpin. How can I open this file?

    Job40Auruku5 pointsBadges:
  • How to repair corrupted files

    My MS Word, Excel and PDF files have been corrupted and these files are showing there file extension as "qbnzgel". How to open this type of files?

    tanveerhamza5 pointsBadges:
  • Why won’t my Excel fields link for a subreport?

    I am trying to use an Excel file as a source for my subreport in Crystal 2008. I am able to create a simple report using the Excel file alone, but when I try to use it as a subreport, it will not link. Help!

    AngelaK15 pointsBadges:
  • How to get AS/400 macro to pull data from Excel

    Hello I’m trying to create a macro on the AS/400 that will pull data from an Excel sheet and input data to the screen. I know how to create a macro to run the menu option by using the record macro button but not sure how to get it to access the excel file so it will run through the list.

    dluy688035 pointsBadges:
  • How to run AS/400 commands through Excel macro

    I need to run AS/400 commands through Excel macro. Please help on this. This is repetitive task, has to run every time entering and giving common fields.

    hemasekhar5 pointsBadges:

Browse Alphabetically:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following