Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: randy700
  • Content: Threads
  • Order by date
  1. randy700

    Command Button on Excel Spreadsheet

    I have several spreadsheets (macro enabled) that I've placed a command button on to run the background VBA code. Last night, our corporate PC support geniuses ran some updates, which they never notify us about. Now the buttons are disabled. I've checked the usual macro security settings, none...
  2. randy700

    Format dependent on another cell

    Not sure how to build a formula in data validation. I'm not even convinced this can be done in Excel. Basically, what I need is: If A1 = "SOLD" Then A2 must be numeric, must be greater than 0, and cannot be blank. I've looked at examples of data validation, but can't find anything similar...
  3. randy700

    Leading Zeroes

    Excel 2010, opening a .csv file. The file is created in a COBOL program and received thru email. My incoming file looks like this: "Company","Department","Customer","Sales","Salesman" "Walmart","Shoes","0123456",0001.23,","Jones" First line is column headings. My problem: I cannot find a way...
  4. randy700

    Count by Background Color

    Beginning with the 2007 version of Excel, we now have the built in ability to sort and filter by color. Does anyone know if there is a function to COUNT the number of cells that are colored? Randy
  5. randy700

    Formatted Date

    Excel 2007 I have this code: Dim dtMonthEnd as Date dtMonthEnd = Format(#4/30/11#, "mm/dd/yy") The result I'm getting is Month end = 4/30/11 I'm moving this to a mainframe file and need 04/30/11. The leading zero is important on the mainframe. Anyone know how I can get it formatted as...
  6. randy700

    + or ++

    I'm working on a project that requires me to extract data from various files and build text files. The users want a + or - sign in front of all signed numeric fields. My question is... What is the difference between these 2 picture clauses? PIC +9(06).99 PIC ++9(06).99 They seem to product...
  7. randy700

    Disable error checking

    In Excel 2003, is there a method to disable error checking? I'm talking about a situation where cells are formatted as text that display an error (identified by a little green tick in the upper left corner of the cell). I'd like to turn this off, so the error is not displayed. Randy
  8. randy700

    Warning wen opening spreadsheets

    Using Excel 2007, I receive files in various formats (.xls, .xlxs, .xlxm, .xlm). When opening the files, I often get the following message... The file you are trying to open, 'Filename.xls', is in a different format than specified by the file extension. Verify that the file is not corrupted and...
  9. randy700

    CSV File

    I'm trying to export a main frame file into Excel. I can send a .csv file and open it with Excel. All works well except for text fields that look like numbers with leading zeroes. I cannot change those fields in the main frame as they represent customer part numbers (the main frame jobs don't...
  10. randy700

    SORTOUT Error

    Can someone tell me what I have wrong here? This code works: //STEP02 EXEC PGM=SORT //SORTLIB DD DSN=SYS1.SORTLIB,DISP=SHR //SORTWK01 DD UNIT=DISK6,SPACE=(CYL,(75,25),RLSE) //SORTWK02 DD UNIT=DISK6,SPACE=(CYL,(75,25),RLSE) //SYSOUT DD SYSOUT=X //SORTIN DD...
  11. randy700

    Login ID

    I know I've seen it here somewhere, but cannot seem to find it in any of my searches. I'm looking for a way to get the system or windows login ID. Can someone point me in the right direction? Randy
  12. randy700

    Unable to enter a formula

    Using Excel 2007. I have a few cells that I need to enter formulas. Most work fine, however, I have some that display the formulat itself, instead of the result. Can someone tell me how to format the cell so it displays the result of the formula? Randy
  13. randy700

    VBA and displayed values different

    I'm trying to upload data from an Excel 2007 spreadsheet to the mainframe. To satisfy my clients needs, I've created a macro that processed the data. I'm working with as many as 5 decimal places, with only 2 decimals displayed in the spreadsheet. The client wants the DISPLAYED value uploaded...
  14. randy700

    Excel Multiplication

    I have several macros that upload data from Excel to the mainframe via the IBM MQ series. This one is presenting a problem because it stops when it reaches a certain cell. Here is the code that is giving me trouble: strTempData = ActiveCell.Value * 1000 strTempData = Space(WidthArray(nbrCols) -...
  15. randy700

    Excel Closes Down

    I have several Excel 2007 spreadsheets that use macros to transfer the data to the mainframe. We interface through the IBM MQ series. The project I'm currently working on is to transfer a freight table to the mainframe. The problem I've run into: Every time I attempt to run the macro, it stops...
  16. randy700

    Saving an Excel 2007 File

    Ever since we upgraded to Office 2007, I get a pop-up message when I save an Excel file to the network drive. I don't see it when saving to my hard drive (maybe it's that much faster). It's rather annoying because, after saving the file, I often move on to another task and Excel comes back to...
  17. randy700

    Excel macro causes excel to close

    I have an Excel spreadsheet, created in 2007, saved in 2003 format. It runs fine on my machine, which has 2007 loaded. It also works correctly when run from my Citrix server, which has 2003 loaded. The problem I have is when my customer tries to run the same spreadsheet. On her machine...
  18. randy700

    Sending Email from an Excel Macro

    I have an Excel macro that I use to upload data to a mainframe. I'd like to add a final step that notifies the computer room that the data has been uploaded. This code works in Access: DoCmd.SendObject acSendNoObject, , , "me@domain.com", , , "Information Needed", "Testing email", False Is...
  19. randy700

    Sending Email

    I have an Excel macro that I use to upload data to a mainframe. I'd like to add a final step that notifies the computer room that the data has been uploaded. This code works in Access: DoCmd.SendObject acSendNoObject, , , "me@domain.com", , , "Information Needed", "Testing email", False Is...
  20. randy700

    Field Selection

    OK, can't figure out what I inadvertently changed. Suddenly, whenever I enter a field in a table or query grid, I'm selecting everything from the cursor to the end of the field. I can't find the option to select nothing when entering the field. Hope this makes sense. Randy

Part and Inventory Search

Back
Top