• handling text overflow

    Text that is too long for a cell can be handled in several different ways. What is the difference between: (1) Not giving Excel any instructions about what to do with the text overflow (2) Letting Excel wrap text in a cell (3) Using ALT+ENTER to cause Excel to go to a new line while entering text....

    Brad3386015 pointsBadges:
  • Automated file transfer from AS400 to Word?

    A search400.com reader wrote in with this question: I need to take a spool file (say a Collection Letter) generated from RPGIV. I can copy this spool file to a physical file if needed. I want to automatically import or send this file to Microsoft Word for editing purposes. I have used the 'ADD-INs'...

    AS400 - Ask the Expert485 pointsBadges:
  • Editing exhisting macro

    I have an exhisting macro but now I want to delete column's E and H in one of the sheets and am unsure how to edit the macro to correspond to this change.

    Cadenthais15 pointsBadges:
  • How to keep link Hotspots from opening in Internet Explorer?

    My company just migrated from Outlook to Lotus Notes 6.5 and we are struggling on some basic issues. For instance, when someone opens a link to a PowerPoint (.ppt) document from a Lotus Notes e-mail, it opens with Internet Explorer. How do we get this file to open using PowerPoint instead of...

    C2c5 pointsBadges:
  • use vba to draw graphics in ms word

    can vba create drawing "free hand" or by joining forms and circles together (putting one near another is good enough)

    Elad Karako255 pointsBadges:
  • How to get File from AS400 to Microsoft Word?

    I have copied a spool file from the AS400 to a physical file and need a way to get it into Microsoft Word for editing and emailing.

    JHAMLW5 pointsBadges:
  • 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:
  • The executable has changed since the last time you used

    Hello All A user has recently start having errors when she is in outlook and use MSword. The errors are for Word.exe or Outlook.exe and sometimes Ie.exe Note:The Symantec Antivirus EndPoint dose not find any virus. Word:File Version: 11.0.8202.0 File Description: Microsoft Office Word File Path:...

    AsgharE35 pointsBadges:
  • Excel 2003 linking text format in two workbooks

    I have 8 different workbooks that are linked to one master workbook. In each of the 8 workbooks people need to select certain names and change the text format to bold. however when the master workbook is open and updated the BOLD format is not there. Each of the 8 workbooks are changed monthly with...

    Carourke15 pointsBadges:
  • MS Office defaults when instlling via Group Policy

    I recently created a packaged install of Office 2003 to assign to workstations. I created a .mst file with my specifications and deployed the package. Everything worked great except when I launch Word for the first time the computer prompts me for my Name and Initils. Is there a way to configure...

    Skepticals0 pointsBadges:
  • DRM & MAIL MERGE

    Is it possible to embed a DRM in a Word for Windows database and documents, email them to someone who can then modify the database for his own use but still be unable to share them on CDs or email them to others once the data base has been modified?

    Fgd5 pointsBadges:
  • Microsoft Office 2003 Not Registered Correctly

    We have had a similar problem with Office 2003, the Upgrade version, several months ago. We recently bought the Full version. The Product ID is 73931-640-4339835-57976, the Registry Key is 90110409-6000-11D3-8CFE-0150048383C9. The program accepts neither one in the dialog box for installation....

    JandNLarson55 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:
  • Issues with 2007 MS Office Server SP1

    Are there any known or has anyone had issues with 2007 Office Server SP1?

    Daizy35 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:
  • 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:

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