Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

How To For Microsoft Office Applications

Collapse
This topic is closed.
X
This is a sticky topic.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How To For Microsoft Office Applications

    How to use Visual Basic for Applications (VBA) to change UserForms in Excel

    How to Programmatically Manipulate a UserForm

    How to Programmatically Create UserForms in Visual Basic for Applications

    Download Attachment At Bottom For Live Links

    The Hey, Scripting Guy! Archive: Microsoft Office

    Microsoft Excel
    • How Can I Import a Fixed-Width Data File into Microsoft Excel?
    • How Can I Sort a Spreadsheet By Cell Color?
    • How Can I Check the Value of a Specific Cell in a Bunch of Excel Spreadsheets?
    • How Can I Mark the First Occurrence of a Number in an Excel Spreadsheet?
    • How Can I Read Custom Summary Information Properties for an Excel File?
    • How Can I Change the Color of a Spreadsheet Cell Based on a Range of Values?
    • How Can I Import Multiple Worksheets into an Access Database?
    • How Can I Search For Values in an Excel Worksheet?
    • How Can I Cut a Row From One Excel Spreadsheet and Paste That Row Into Another Spreadsheet?
    • How Can I Determine the Value of the Last Cell in an Excel Range?
    • How Can I Convert an Excel Serial Number to a Date and Then Back?
    • How Can I Insert New Rows Above the Last Row in an Excel Spreadsheet?
    • How Can I Copy Data from Excel to PowerPoint?
    • How Can I Retrieve Hyperlink Information From an Excel Spreadsheet?
    • How Can I Insert Blank Rows (and Formulas) Into an Excel Worksheet?
    • How Can I Update and Then Break All the Links in an Excel Spreadsheet?
    • How Can I Open All the Excel Spreadsheets in a Folder and Run a Specified Macro Found in Each of Those Spreadsheets?
    • How Can I List the Addresses in My Sent Items Folder in an Excel Spreadsheet?
    • How Can I Add a Background Picture to an Excel Worksheet?
    • How Can I Replace Numeric Values in an Excel Spreadsheet?
    • How Can I Copy Data From One Spreadsheet to Another?
    • How Can I Replace Text in an Excel Spreadsheet?
    • How Can I Set the Print Area in an Excel Spreadsheet?
    • How Can I Delete Specified Rows in an Excel Spreadsheet?
    • How Can I Color Every Other Row in an Excel Spreadsheet?
    • How Can I Copy Selected Columns From a CSV File to an Excel File?
    • How Can I Change the Background Color of Spreadsheet Rows That Have a Date in a Specified Cell?
    • How Can I Export an HTA Table to Excel?
    • How Can I Delete All the Worksheets in a Spreadsheet Except for the First Worksheet?
    • How Can I Assign a Background Color to Cells in a Spreadsheet and Then “Sum” Those Cells?
    • How Can I Sort a Row in an Excel Spreadsheet?
    • How Can I Remove the Password When Opening an Excel Spreadsheet?
    • How Can I Import an Excel Spreadsheet Into an Access Database?
    • How Can I Save a Table in an Access Database as a Spreadsheet?
    • How Can I Use a Blank Row to Separate Data in an Excel Spreadsheet?
    • How Can I Specify the Number of Decimal Places to Display in an Excel Spreadsheet?
    • How Can I Configure Excel to Autosave Every 5 Minutes?
    • How Can I Save an Excel Chart as a Picture?
    • How Can I Change the Font Color in Excel If a Specified Condition is Met?
    • How Can I Convert an Excel Spreadsheet to XML?
    • How Can I Set the Default File Path in Excel to a User’s Home Directory?
    • How Can I Compare a List of Names in One Excel Column to a List of Names in Another Column?
    • How Can I Convert a Tilde-Delimited File to Microsoft Excel Format?
    • How Can I Search Active Directory for User Names Stored in an Excel Spreadsheet?
    • How Can I Add a Total Row to an Excel Spreadsheet?
    • How Can I Create a Custom Date Format in Microsoft Excel?
    • How Can I Keep the Screen From Updating While Running an Excel Script?
    • How Can I Use Information in an Excel Spreadsheet to Rename a Set of Folders?
    • How Can I Determine the Background Color of a Spreadsheet Cell?
    • How Can I Make the First Character in a Cell Uppercase and All the Other Characters Lowercase?
    • How Can I Copy a Worksheet to a New Spreadsheet?
    • How Can I Use Windows PowerShell to Automate Microsoft Excel?
    • How Can I Tell If a Specified Worksheet Exists in an Excel Workbook?
    • How Can I Add a COUNTIF Formula to an Excel Spreadsheet?
    • How Can I Copy All the Comments From an Excel Worksheet to a Word Document?
    • How Can I Change All the Lowercase Letters in an Excel Worksheet to Uppercase Letters?
    • How Can I Create a New Excel Spreadsheet at Midnight Each Night?
    • How Can I Select a Column of Data in Excel and Then Paste that Data into a Text File?
    • How Can I Convert a Number to a Date in Excel?
    • How Can I Locate and Replace Information for a Specific Item in a Spreadsheet?
    • How Can I Save an Excel Spreadsheet, and Then Save a Copy as HTML?
    • How Can I Format an Excel Spreadsheet So It Retains Leading Zeroes?
    • How Can I Determine the Last Row in an Excel Spreadsheet?
    • How Can I Remove All the Formatting from an Excel Spreadsheet?
    • How Can I Change the Footer in an Excel Spreadsheet?
    • How Can I Add Additional Worksheets to an Excel Workbook?
    • How Can I Sort Worksheets in a Workbook?
    • How Can I Import a Fixed-Width File into Microsoft Excel?
    • How Can I Add a Hyperlink to an Excel Spreadsheet?
    • How Can I Build an Array from a Column of Data in Excel?
    • How Can I Copy Column C of One Worksheet to Column A of a Second Worksheet?
    • How Can I Center Text in an Excel Cell?
    • How Can I Change the Background Color of a Cell Depending on the Date?
    • How Can I Delete Data from a Spreadsheet Yet Keep All the Formatting?
    • How Can I Open an Excel Workbook and Retrieve the Names of All the Worksheets?
    • How Can I Tell if an Excel Workbook is Open and, If It Isn’t, Open It?
    • How Can I Insert a Column into a Spreadsheet?
    • How Can I Save a Single Excel Worksheet to a CSV File?
    • How Can I Password-Protect an Excel Spreadsheet?
    • How Can I Make Changes to and Then Re-Save an Existing Excel Spreadsheet?


    Microsoft Word
    • How Can I Randomly Assign a Font to Characters in a Word Document?
    • How Can I Find a Word in a Document and Change the Background Color of the Paragraph Where That Word Appears?
    • How Can I Count the Number of Sentences and Paragraphs in a Word Document?
    • How Can I Extract Specific Information From a Word Document and Then Use That Information to Rename the Document?
    • How Can I Tally All the Items in a Microsoft Word Document?
    • How Can I Reset the Revision Number of a Word Document to 1?
    • How Can I Retrieve Field Values in a Microsoft Word Document?
    • How Can I Change the Paragraph Case in Microsoft Word?
    • How Can I Insert a Manual Line Break into a Microsoft Word Document?
    • How Can I Search For and Modify Formatted Text in a Word Document?
    • How Can I Search For Red Text in a Microsoft Word Document?
    • How Can I Change the Default File Save Format in Microsoft Word?
    • How Can I Put the File Name in the Footer of a Microsoft Word Document?
    • How Can I Add a Page X of Y Footer to a Microsoft Word Document?
    • How Can I Save Each Paragraph in a Word Document as a Database Record?
    • How Can I Replace a Specified Font in a Microsoft Word Document?
    • How Can I Apply a Theme to a Microsoft Word Document?
    • How Can I Add the Last-Saved Date to the Footer of a Microsoft Word Document?
    • How Can I Insert a Date Field in Word?
    • How Can I Add a New Item to the Microsoft Word AutoCorrect List?
    • How Can I Clear All the Formatting From a Microsoft Word Document?
    • How Can I Change the Default Highlight Color for a Microsoft Word Document?
    • How Can I Run a Macro After Opening Up Word?
    • How Can I Center-Align a Picture in a Word Document?
    • How Can I Change an Existing Hyperlink in a Microsoft Word Document?
    • How Can I Add a Blank Line Between the Existing Paragraphs in a Word Document?
    • How Can I Insert Text Into an Existing Microsoft Word Bookmark?
    • How Can I Get a Total Page Count for All the Word Documents in a Folder?
    • How Can I Set the Document Orientation in Microsoft Word to Landscape?
    • How Can I Replace Text in a Microsoft Word Document?
    • How Can I Search For (and Reformat) Highlighted Text in a Word Document?
    • How Can I Get a List of the Unique Words Used in a Microsoft Word Document?
    • How Can I Get a List of Available Metadata for Microsoft Office Documents?
    • How Can I Add Multiple Tables to a Word Document?
    • How Can I Search a Word Document for All the Words in Double Brackets?
    • How Can I Add Centered Page Numbers to the Footer of a Word Document?
    • How Can I Create a Table and Fill the First Column With a Range of Dates?
    • How Can I Rename a Word Document Using the First Three Characters in That Document?
    • How Can I Search for and Highlight Words in a Microsoft Word Document?
    • How Can I Right-Align a Single Column in a Word Table?
    • How Can I Boldface a Specific Word Throughout a Microsoft Word Document?
    • How Can I Change the Font Name and Size for an Entire Word Document?
    • How Can I Set Word’s Revision View Mode to Final?
    • How Can I Insert Multiple Files Into a Word Document, Putting a Page Break Between Each File?
    • How Can I Set Word’s Default File Location to be the User’s Home Directory?
    • How Can I Open Word with the Cursor Positioned at the Start of a Specified Line?
    • How Can I Change File Locations for Microsoft Word?
    • How Can I Insert a Symbol into a Word Document?
    • How Can I Hide a Specific Toolbar in Microsoft Word?
    • How Can I Extract Word Paragraphs That Use a Specific Style?
    • How Can I Insert Files into a Word Document?
    • How Can I Convert 1,000 .RTF Files to Word Documents?
    • How Can I Add a Hyperlink to a Word Document?
    • How Can I Put the User Name into the Footer of a Microsoft Word Document?
    • How Can I Determine Which Version of Word is Installed on a Computer?
    • How Can I Save Word Documents as Text Files By Using a Script?


    Microsoft Access
    • How Can I Import Multiple Worksheets into an Access Database?
    • How Can I Add a Record to a Database Using Windows PowerShell?
    • How Can I Delete a Set of Records From an Access Database?
    • How Can I Be Notified if an Access Database File Exceeds a Specific Size?
    • How Can I Retrieve the Field Size and a Sample Record For All the Tables and Fields in an Access Database?
    • How Can I List All the Fields and Data Types in an Access Database?
    • How Can I Append a Value to a Specified Field For Each Record in a Database?
    • How Can I Add the Contents of a Group of Text Files to an Access Database?
    • How Can I Import a .CSV File into an Access Database?
    • How Can I List All the Access Database Files on a Computer?
    • How Can I Print a Microsoft Access Report?
    • How Can I Compact an Access Database?
    • How Can I Use Windows PowerShell to Pull Records From a Microsoft Access Database?
    • How Can I List All the Tables in an Access Database?
    • How Can I Determine Which Version of Access was Used to Create a Database?
    • How Can I Delete a Table from a Jet Database?


    Microsoft Outlook
    • How Can I Schedule a Meeting Each Monday Through Friday For Two Weeks?
    • How Can I Sort Items Retrieved From a Microsoft Outlook Folder?
    • How Can I Set a Reminder on All My Outlook Appointments?
    • How Can I Schedule an All-Day Event in Microsoft Outlook?
    • How Can I Run a Script Any Time Outlook is Started?
    • How Can I Determine the Age, in Years, of an Outlook Contact?
    • How Can I Save the Attachments for All My New Outlook Messages?
    • How Can I Convert an Extension Number to an Actual Phone Number?
    • How Can I Create a New Folder in Microsoft Outlook?
    • How Can I List the Addresses in My Sent Items Folder in an Excel Spreadsheet?
    • How Can I Get a List of Appointments for a Specific Month?
    • How Can I Save Emails That Are More Than One Month Old?
    • How Can I Create a New Outlook Distribution List Based On the Membership of an Active Directory Group?
    • How Can I Save All My Contacts as VCards?
    • How Can I Delete Unread Emails That Are More Than 6 Months Old?
    • How Can I Randomly Select an Email From an Outlook Mail Folder?
    • How Can I List All the Meetings Scheduled By a Specified Person?
    • How Can I Filter Outlook Messages By Email Address?
    • How Can I List All the Members of a Microsoft Outlook Distribution List?
    • How Can I Determine the Follow-Up Status of Outlook Emails?
    • How Can I Tell If Any of My Contacts Have a Birthday This Month?
    • How Can I Delete All the Messages in My Sent Items Folder?
    • How Can I Start Outlook If It Isn’t Already Running?
    • How Can I Connect to the Junk Mail Folder in Outlook?
    • How Can I Get Access to a Mail Folder That Isn’t a Subfolder of My Outlook Inbox?
    • How Can I Get a List of All the Senders’ Email Addresses in an Outlook Folder?
    • How Can I Delete All the Email Sent From a Specific Person?
    • How Can I Write a Script That Accesses All the Subfolders in My Outlook Inbox?
    • How Can I Get Total Size and Number of Items in an Outlook Folder?
    • How Can I Convert an Outlook Email Message into a Text File?
    • How Can I Get a List of All the .PST Files on a Computer?


    Microsoft PowerPoint
    • How Can I Retrieve the User Name and User Initials From Microsoft PowerPoint?
    • How Can I Copy Data from Excel to PowerPoint?
    • How Can I Apply a New Template to a PowerPoint Presentation?
    • How Can I Configure PowerPoint to Print Handouts Instead of Slides?
    • How Can I Run a PowerPoint Slide Show From a Script?


    Other Office Tasks
    • How Can I Use Windows PowerShell to Look at All the Microsoft Office Documents in a Folder?
    • How Can I Change the User Information in Microsoft Office?


    MS-Office-How-To.zip


    Merge Or Convert Excel | Trading Add-ins For Excel | Convert Excel Into Web Pages |Convert Databases Including Excel | Business Spreadsheets | Build Automatic Trading Models in Excel
    Last edited by pike; April 3rd, 2013, 18:47.
    If the solution helped please donate to RSPCA

    Sites worth visiting: Rabbitohs | Excel-it royUK | Excel Matters Rory | Kris' Spreadsheet Solutions | Domenic xl-central | SO The Macro Man | The Smallman

Trending

Collapse

There are no results that meet this criteria.

Working...
X