Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 1 of 1

Thread: How To For Microsoft Office Applications

  1. #1
    Join Date
    9th April 2007
    Location
    Alstonville, Straya
    Posts
    5,703

    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 at 18:47.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. FAQ/How To For Microsoft Office Applications
    By Dave Hawley in forum HELP FORUMS
    Replies: 0
    Last Post: April 26th, 2008, 13:55
  2. FAQ/How To For Microsoft Office Applications
    By Dave Hawley in forum Excel and/or Word Help
    Replies: 0
    Last Post: April 26th, 2008, 13:55
  3. FAQ/How To For Microsoft Office Applications
    By Dave Hawley in forum Excel and/or Access Help
    Replies: 0
    Last Post: April 26th, 2008, 13:55
  4. FAQ/How To For Microsoft Office Applications
    By Dave Hawley in forum Excel and/or Email Help
    Replies: 0
    Last Post: April 26th, 2008, 13:55

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno