• Is there a way to auto-refresh an Excel auto-filter when the data is changed?

    Is there a way to change the value of a cell so that when it is filtered, the current row disappears?

    ITKE354,225 pointsBadges:
  • STRPCCMD – How to avoid black DOS screen popup

    I have a STRPCCMD command in my CL program to open an IFS folder which has the .CSV files. STRPCCMD PAUSE(*NO) PCCMD(''''start " " "\'+%trim(P@SYSNAME)+%xlate('/':'':DFTPATH)+'"'')' P@Sysname has the system name. I can see a popup DOS window but getting message the path not found. I am able to see...

    RamvishakRamesh2,505 pointsBadges:
  • Changing spell check language in Microsoft Word 2010

    I'm editing a document in another language, and want to change the spell check language of this document. I usually use MS Word 2010 when writing documents. Will making a change to this particular document affect other English-language documents (meaning does not save by default) I write?

    ITKE354,225 pointsBadges:
  • Activating en dashes in Word 2007

    Never mind, I found what I was doing wrong, thank you anyway!

    Hades135 pointsBadges:
  • convert oracle reports to excel

    How do i corvert oracle reports to excel

    DDPORACLECORV5 pointsBadges:
  • Imbed and Link External Excel Spreadsheet into Visio

    Looking to utilize an external spreadsheet which maintains various information pertaining to our move from one data center to another. Items included are ip address, rack, U, hostname. The question is I want to utilize this spreadsheet as my source. Then within my Visio, I have tabs for each Rack....

    Aguacer08,135 pointsBadges:
  • Excel Macro to extract substrings from a comma-separated string.

    How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.

    Sdsdsd15 pointsBadges:
  • Microsoft Excel error message

    I have just installed Office 2010 and error message comes up when I start Excel: 'Compile error in hidden module: AutoExecNew' I also get error message when closing Excel: 'Compile error in hidden module: DistMon' Please can you help?

    Sandralord5 pointsBadges:
  • VLOOKUP in Excel 2007

    I have 2 columns on an excel spread sheet with the following formula; VLOOKUP(D2,$A$2:$B$2090,2,FALSE) if I copy from column one cell A(2thur209) it produces the corresponding name in column B, but if I type the same name it produces #N/A. What is the problem?

    Newkid4735 pointsBadges:
  • Can data in Excel 2003 be set up to automatically move from one sheet to another in a workbook?

    Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the others we...

    Kaylee5 pointsBadges:
  • Excel – Out of memory

    Hi, I have a Win2000 Server that we are using for our production QC System. I need to run 3 excel files with macros (Excel 2000) on the server for a monthly report. My problem is that each of these Excel files are already 30MB. When opening the third Excel file, the system prompts that it is out of...

    JayCuizon0 pointsBadges:
  • Oracle Forms to MS Excel

    I have several reports which extract data via Oracle Forms into MS Excel. But Excel cuts off the input at row 999.  The Oracle Form uses the DDE.EXECUTE(ConvID) command.  Does anybody know if Excel has a limitation of the number of rows it will import via Oracle Forms?

    Mayac35 pointsBadges:
  • Export multiple files to Excel using CL

    Hello, I have these queries on a job schedule now and I want to export them to Excel using CL. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two files to? And can I run both queries this way?

    Querys100 pointsBadges:
  • One formula for a single column in Excel 2003

    I am using MS Excel 2003. I have a spreadsheet with the exactly the same formula in every cell of a given column (This is possible by using the row() and the indirect() functions). The spreadsheet is using 6000 rows. Currently, I have copied the formula into each cell. This increases the...

    Gosteelers5 pointsBadges:
  • Problem with shortcut error messages

    I was moving folders around in my documents when something I did erased or moved some of my folders. The documents were Excel spreadsheets with formulas. I ran a search and a couple of them came up but when I click on them, I get the error message: Problem with shortcut the item " " that this...

    Mh1125775 pointsBadges:
  • Adobe Pro9 Error while interacting with the scanner

    Hello All; I have never come across this problem before but it has definitely proven itself to be quite interesting, I have a computer running Win XP Pro, Adobe Pro 9 connected to a Brother MFC 8860DN on the network and up until a few days ago, when trying to scan from Adobe I get an error that...

    CGarcia26C1,025 pointsBadges:
  • Can I find an Excel merged cell size in VBScript?

    I have a set of Excel spreadsheets which all have similar properties and I'm trying to automate a set of processes on them. I'm a compelte VB beginner, but it's going ok - I've just hit a stumbling block with the internet isn't being very helpful with. Once I have found a certain cell, is it...

    Bengreen15 pointsBadges:
  • Put rows in numerical order

    I have data entered randomly and now I want to sort it numerically using a certain column as the numbers to sort.

    Kooka5 pointsBadges:
  • Excel 2007 – gauge, speedometer, or dial charts

    Hi, Does anyone have any idea were I could find some some sample templates on these 3 for: Excel 2007 - gauge, speedometer, or dial charts. Thanks Jared~

    Jreifenstein001185 pointsBadges:
  • Combo box in Microsoft Excel

    How do I link numeric values to word choices in my combo box? I have tried If Then's for if you pick a certain choice it = a certain number, but I'm stuck! Thanks.

    Toriel5 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