• Sharing Problems in Excel

    We have several spreadsheets that we share with 5 users. Some of these worksheets seem to grow to a large size in a short amount of time, even though they actually don't contain that much information. These are files that several people are updating and viewing many times per day. For example, I...

    Jjvaldez5 pointsBadges:
  • Working with Login Userforms

    I've been doing research on Login Userforms and have come up with a code variation similar to coding trend. However, I am having an issue clearing the previous information, allowing the user to reenter their password before the loop continues. (i.e. the user inputs "password", receives an invalid...

    McNitro255 pointsBadges:
  • Arabic Text In AS/400 to Excel

    Arabic Text when transfered to from AS400 to Excel displays garbage. Is there an add in I need to install?

    STARter20095 pointsBadges:
  • How can I import data to mainframe from Excel in REXX

    I have the excel sheet with few fields, I want to import the excel data from my desktop to a mainframe dataset

    NatpudanMoorthy5 pointsBadges:
  • Excel to Access conversion

    Accounting came and asked me if a very complicated Excel spreadsheet that they are using for cash receipts could be "moved" into Access. I explained to them the difference between a spreadsheet and a database and that Access could definitely be used to better handle transactions etc. but it would...

    KSoniat610 pointsBadges:
  • Vlookup Worksheet Function

    I develop and maintain pricing models that involve a lot of looping through cells and applying assumptions. For some reason I never seem to be able to get the vlookup worksheet function to work when looping through cells. It either says 'application-defined or object-defined error' or more...

    Hunter115 pointsBadges:
  • OFFICE XP ERROR MESSAGE

    Dear friends I have one system that should member of Domain I am all ready installed the Office 2003 applacition in Domain But after installing the applation whin i oppen the file I am getting erroe message Microsoft excel has not been installed for the current user plz run setup to install the...

    845915 pointsBadges:
  • Data transfer .XLS to iSeries

    It's worked the last 4 tries (tho had to tweak each time), but now I just get basically one long field coming in. The comma delimitors are treated as just another character byte. While setting up a "power user" to take over this function (so no .fdf or other residuals from prior successful...

    aceofdelts2,130 pointsBadges:
  • Creating a .xls text field from AS400 file with dd/mm/yy field

    I am using client access to create a spreadsheet from an AS400 file. Although a date field is defined as alpha in AS400 DDS specs, the field is populated as dd/mm/yy in the AS400 file. When the spreadsheet is created using client access, the field does not come across as text. I need the field to...

    Cunninjoe320 pointsBadges:
  • UPK scripts/Excel Scripts and HP Quality Center

    How time consuming is it to convert UPK Scripts into HP Quality Center and set them up for automated testing? What about test scripts in excel

    Wanthelp10 pointsBadges:
  • Create a file with formulas on the iSeries and send to Excel.

    I can create a file in SQL that has formulas in it (i.e. '=A1*B1') and I can send them to my PC and open them in Excel. However, the formulas are showing instead of the results. If I click inside the cell and hit Enter, I get the value instead of the formula. BUT, I want this automated and don't...

    JeffWilson20 pointsBadges:
  • How do I overcome the “Could not find installable ISAM. Excel 2007″ Error? Ex

    I got the "Could Not find installable ISAM error" while uploading an Excel file in my application.This seems to be happening at the "connection.Open()" code line. -- Web Application -- .Net 2.0 -- Testing using IIS 7.0 on Vista Ultimate -- Office 2007 Enterprise Installed on machine. Code works...

    Donnybrasco10 pointsBadges:
  • Combobox Intro. Question

    Hi! I'm extremely new at using combobox in Excel and I have 2 questions about how to incorporate them into my files. 1.) Is there software that I can use to "produce" the VB code I need to set my comboboxes over my Data Validation cells? Not used to actual programing. 2.) I wanted to know if...

    Kiki83025 pointsBadges:
  • put excel password in VB coding

    i had two workbook name workbook1 & workbook2 they are interlinked with each other and i put one password to that workbook 1. by default workbook2 ask for password i dont want to put password every time so shall i put my password in VB code

    A19805 pointsBadges:
  • Convet pf file to Excel

    I had copyed spool file to pf and i want that should be copied to execl format.

    151015 pointsBadges:
  • Managing Restriction for users with Windows group policy

    Dear Friends, pls guide me how to restrict users form password protacting excle sheets using group policy or other method.Please note my email id for further communication patil_dipak2@yahoo.com

    Sagardip10 pointsBadges:
  • generating excel on server

    I want to generate excle on server and store. I had copied spl file to pf but how can i generate excle on server.

    151015 pointsBadges:
  • convert excel to oracle 9i?

    how can i convert data excel to oracle 9i?

    Binty25 pointsBadges:
  • How do I macro 20,000+ series of data?

    The full s/s stretches to nearly 350,000 rows and consists of over 20,000 series of data, between 6 and 30 rows deep, in columns A:J. In column I of each series, on rows 3, 4 and 5 there are three numbers. The second number is to be subtracted from the first with the answer being divided by the...

    Colwyn25 pointsBadges:
  • Extract all instances of a search between two symbols

    Dear Friends, I have created the following code to search entire C Column from WrkBk1 with "<*>" string so as to extract all the matched words into Wrkbk2. for eg a single cell data in Col-C is given below maintaining similar pattern in other cells too. [Cell C1 Data] Enter Pers No....

    Gotovamsee5 pointsBadges:

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