• Oracle Form: Export to Microsoft Excel

    I have an Oracle form. I need the code of a function that exports a given SQL query into Excel sheet on a button click action.

    Chetana045 pointsBadges:
  • How to I create a Chart in Excel 2007 from Non Numerical Data?

    We have several projects going at work and my boss is tired of sorting through Spreadsheets and told me to graph everything. I need to figure out how to make a chart register how many of word/phrase A, B, C etc. there are in a column and stick that in a graph. If anyone could help I would really...

    Kuroia5 pointsBadges:
  • Importing from an Excel worksheet to Access form

    I have set up my database in access including the form that I want to import my information into, however when I try to import from an excel worksheet into access, it changes all my field names to field 1,2,3 etc. Then when I look at the form page all my sections have the word #NAME? in them. How...

    Horses5 pointsBadges:
  • How do I run Excel Reports?

    Is is possible to run reports similar to how you run reports in Access in Excel 2007? If so, how?

    Lysprice5 pointsBadges:
  • Export or Import data Excel to Excel (VBA coding)

    Hi experts, could someone please tell me if it's possible to export or import Excel data to Excel (VBA coding)? Ananda Debnath

    AnandaDebnath280 pointsBadges:
  • Connecting an Excel spreadsheet with Visual Basic

    Hi, can I connect an Excel spreadsheet to form in Visual Basic? I must do calculations in runtime to that spreadsheet. Can you tell me a sample code? Thanks!

    Janita5 pointsBadges:
  • Use of the EXCEL formula function to copy data and insert an asterik on both ends of output.

    Is there a method to use the formula function to copy the contents entered in one cell (A2) into cell B2 with the addition of an asterisk '*' on both ends of the copied text? An example being - Enter 'H123456' in A2, with the output in B2 being '*H123456*'

    Tmdillon5 pointsBadges:
  • Excel compact or compress utility?

    Microsoft Access has a repair and compact utility built into it. I'm looking for something similar for Microsoft Excel -- mostly to reduce the size of bloated spreadsheets. Any suggestions (other than manually copying the important data from the large spreadsheet to an empty and clean new...

    DKoch675 pointsBadges:
  • Excel formula to find and replace letters in a word

    Hi, I have a cell that has a word written in it ex. damascus. Now with this formula, I need to be able to find the "a" and replace it with "A" so it will become dAmAscus. Is this possible?

    Microbert25 pointsBadges:
  • How do I change a single cell size in a spreadsheet

    I have a spreadsheet and I have set column widths. I would like to change one cell in that spreadsheet without changing the width of all of the rest of the sheet. Is this possible? Also, is there a way to set the page sizes separately i.e. page 1 legal, page 2 letter?

    Cat1005 pointsBadges:
  • Conditional formatting

    Hi there. I want to change the cell colour shading of range A10:F10 to one of three colours, depending on the contents of another cell outside this range (J10). Can this be done please?

    Twiggy196510 pointsBadges:
  • Compatibility mode

    My Excel documents are saving in compatibility mode. How do I change this?

    jlynkett75 pointsBadges:
  • Excel equation

    When working out an equation in Excel, if I use a comma, it will work out the equation for me, but if I use a full stop or point the formula comes up with a #value error sign. eg. =4,5*5=22.5 but =4.5*5=#value Is there a setting I need to change?

    littlebiscuit25 pointsBadges:
  • Export to Excel

    Why does Crystal add blank rows and columns when I export to Excel?  How can I export without blank rows and columns?

    RicksterS5 pointsBadges:
  • Transaction web page using MS Excel

    How to develop transaction web page using MS Excel as database?

    ramki19805 pointsBadges:
  • Change a field in a file

    I created a file using qry400, to hold the position of a field I used spaces '    ', now when I try to download to an Excel spreadsheet the info in that field comes out looking like HEX instead of what is in the field. Is there anyway to correct this? *** note - I must fix the file, I can not...

    hydr15 pointsBadges:
  • Microsoft Word or Excel

    Why when I double click the created small Word or Eccel files, the program won't open the document anymore?  The program only opens the first page of the program as we click the Word or Excel icons.  I now always need to go to Word or Excel main program or icon to select the created document...

    paul180815 pointsBadges:
  • Filename error in VBA

    I created a macro to run with my daily reports in Excel. The only issue is the names of the report change every day respectively as Mat1 mm-dd-yy. I have tried to maneuver with the code but it always leads to a dead end. How can I change the code to be able to run with any date? Mat1Macro Macro ' '...

    ambershantae5 pointsBadges:
  • Scrolling

    In working with MS Excel 2003, there are darker scroll lines vertically & horizontally on the worksheet. When I try to scroll the page down below the line, only those cells scroll, not the whole sheet. How do I fix this?

    nccoolmom10 pointsBadges:
  • Opening Excel

    We use a shared workbook. As I understand how Excel is supposed to open, it should be at the same place where I last saved it. Instead, it opens at that location and then jumps to a weird place on another sheet. I cannot figure out why or how to make it go back to opening normally.

    tlsanders11,340 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