Search results for query: *

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...

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...

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...

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

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...

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...

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

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...

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...

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...

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

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

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...

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) -...

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...

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...

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...

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...

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...

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