• Referencing clip art in Excel

    Is there a way that I can reference clip art in Excel? For example, based on the type of car selected from a Data Validation list, I want to show that type of vehicle from a clip art image.

    Rbeyer15 pointsBadges:
  • Charts from internal references of external data

    I can access and process the external data from another worksheet just fine (I'm grabbing data from one excel spreadsheet to plot on another), but I need to process this data before plotting (I need to normalize the data to the max value in that column and the number of rows in each column...

    Nanopit5 pointsBadges:
  • Writing excel RTD to a file

    I have an excel spreadsheet set up using the RTD function to update a row of values every 2 seconds. How can I get excel to append a csv or xls file with the RTD values every time they change? Alternately, can some code make the RTD row be copied and pasted to a new row so that all of the incoming...

    Rtd guy10 pointsBadges:
  • easy way to automate uploading data from a word document to a spreadsheet?

    I have a spreadsheet to verify datafields for. This needs to test for example state all the valid entries. I do not want to save off a spreadsheet form of the template i am testing one for each data value I need to test. Is there an easy way to create many spreadsheets off of a data file I create...

    Juls45 pointsBadges:
  • Cell Colors in Excel

    I would like to have some code that will update the color of a cell based upon values in other cells. Even when the cells are on different worksheets within the same workbook.

    TweetyBird695 pointsBadges:
  • Extra columns on export to EXCEL

    How do I avoid the extra columns upon Crystal export to EXCEL?

    Bozotheclown10 pointsBadges:
  • User permissions in MS Excel

    I have a question on sharing an MS Excel file. Is it possible to restrict a file so that each user can modify only his own tab within that file? Also, is it possible to, under the same of restrictions, have a group of admin users who can modify all the tabs?

    Windows Security ATE160 pointsBadges:
  • Excel 2007 Freeze pane problem

    AOA SIR, I am using Office 2007. I have protected sheet which were created in office 2003. When ever we have open this proted Workbook In Excel 2007 the freeze pane option is disbaled. Please help me out to Solve the Above mention Issue. I Will thankfull to You.

    Mobilink115 pointsBadges:
  • Overwrite previous record with VBA code

    I am doing a training exercise. All works OK as per the notes with a new record being added when the OK button is clicked. Now I want a script that overwrites the previous record and not to add a new record / row on pressing OK. Pls help with code

    Battler5 pointsBadges:
  • how to convert a csv file into a xlsx one?

    Hi, i´m genetarting a csv file from an open hub in BW so i need to convert it into a xlsx one due to i need to upload it into the microsoft share point. is there an abap function that does it? i know that there is one to convert an xls one into a csv. Thanks

    VPD5 pointsBadges:
  • Excel 2007 Macros problem

    AOA, I am using office 2007 the Macros are disabled when we open password Protected Workbook.

    Mobilink115 pointsBadges:
  • MS excel 2007 load data into database

    I am using MS excel 2007 and would like to upload data into DB2 database. I could do this before on my older version of excel. How do I do this with MS excel 2007?

    Geyes15 pointsBadges:
  • Working with Excel in ActiveX DLL

    I have a OCX file that is registered on client's PC and called from ASP to perform the Excel manipulation (copy charts and paste into PPT). I tried to register the OCX on server and called using <Object> tag, did not work, still looking for the OCX on the client. Created a new DLL file...

    Dfree5 pointsBadges:
  • Return zero when there’s no data

    I am trying to write a query that I can use to generate an Excel chart to show activity in our database. I have it returning rows for each minute over the previous two hours (no problem). The problem comes when I plot a line chart. If there's no activity in a given minute, there's no row returned,...

    DanM5 pointsBadges:
  • Validation in Excel

    Can a cell have a validation rule from a list and also have the ability to free type in that cell? This is in Excel 2003.

    Mart8025 pointsBadges:
  • After exporting charts from SQL Server Reporting Services to MS Excel, images appear poor

    I have a problem with my charts. After exporting from SQL Server Reporting Services to Excel, my charts look "ugly.” Quality is low, images are blurry, etc. Is it possible to change settings somewhere?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Search for duplicates in a collumn and delete the row on which it occurs

    Hi, I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on. I know this is possible using clipboard and filters but I would rather avoid...

    Harleq20 pointsBadges:
  • Retreiving data from within square brackets, there may be more than one in each cell (spreadsheet owner refuses to change it grrrr)

    I have a spreadsheet with a column containing data in the following format Column G Row 1 [1T40131A] [GB50131A] [GB50131B] [GB50131C] [1T50131D] Row 2 [1T400133] Row 3 [303640]*VF Row 4 [240700]*RN I would like to create a UDF that will retrieve the data within the brackets and create a column on...

    Harleq20 pointsBadges:
  • how can i limit the data size while entering to the database ?

    how can i limit the data size while entering to the database from Excel sheet using vb6?

    Shwetha20 pointsBadges:
  • Saving form calculations to tables

    I have a simple calculation on the input form a-b. It is calculated on the form but I cannot figure how to save it to the table

    Rv49495 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