• 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:
  • Import data from Lotus notes into Openoffice

    I've found many articles on the web of how to manipulate Open Office from the outside, but what I need is to manipulate the outside from within Open Office. We have some spreadsheets which have macros that connect to a Lotus Notes database using COM and we are looking into porting them over to Open...

    Silvius5 pointsBadges:
  • Run a Macro in Excel 2007 spreadsheet located on a file server

    When I run the macro located on the local drive it works, but when I put the document out on a shared file server I get an error. The server folder is in my trusted locations.

    njasche5 pointsBadges:
  • iSeries V5R3 downloading to Excel 2008

    Are there compatibility issues using File Transfer from iSeries V5R3 to download data to Excel 2008?

    Weeodett10 pointsBadges:
  • Microsoft Excel VBA

    'Please, Tell me this problems How to solve 'One cLick on cell at a time appeared date only Specific column and rows Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) ActiveCell.FormulaR1C1 = Now() ActiveCell.Offset().Range("A1").Select End Sub 'Thanx

    98331466585 pointsBadges:
  • Excel VBA cell.find

    I have this code recorded by XL. Works ok. ** Cells.Find(What:="dd", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _ xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) _ .Activate End Sub ** In the first part - (What="dd", I want the macro to read Cell G1 and looks for text...

    Sswcharlie5 pointsBadges:
  • AS/400 addon for Microsoft Excel

    is there an addon that allows data to be sent back and forth excel to as400

    Glenc15 pointsBadges:
  • Inventory work for storeroom using Excel VBA

    Im supposed to do inventory for a store room at work using excel. Oraganizing and labeling all the items in there so that my boss can be able to find what he wants easily by simply for example if he wants a clock he looks for clock and he sees its at b1 and he looks for b1 and that specific item...

    Emozae20 pointsBadges:
  • File Transfer to iSeries from Excel 2007

    I am using the iSeries Client Access for V5R4, and trying to transfer an Excel 2007 (.xslx) file. There is no corresponding file type to choose from (only goes up to Excel 2003 (BIFF8). Is there any other way to do this using Client Access

    Badkarma40 pointsBadges:
  • Excel VBA – Cell value not being displayed

    when i display all the values there is a cell that dosnt display it's result,but when u put the mouse on it in the comment box it appears

    Skh805 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