Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Configure IT Quick: Re-create Word's Font Sampler macro with these handy refinements
- Back in the old days, when I was running Office 95 on top of Windows 95, I discovered that Word 95 shipped with a cool Font Sampler macro written in WordBasic. Running the macro created a document containing a sample of every font installed on the system. Unfortunately, the Font...
- Tags: font, Greg Shultz, information technology, Line-2, macro, Microsoft Word, VBA, VBA Font Sampler, VBA Font Sampler macro
- Technical articles 2003-05-05
Additional Resources
- Use VBA to hide some columns
- I in fact want to filter columns like filtering rows with Auto Filter. However, I know Excel cannot filter columns. Then, I thought of using VBA to do it.I intend to set values in A3:Z3. If the values in any of these 26 cells = 1, then...
- Tags: Scripting languages, HeHeMan, VBA
- Discussion threads 2007-08-08
- VBA Macro to transfer data fro excel to Powerpoint
- Hi, I need to present a chart with the data in Excel dynamically using VBA Macro
- Tags: Scripting languages, Microsoft Office, breeze_rathna@..., VBA Macro, VBA, Microsoft PowerPoint
- Discussion threads 2007-07-05
- VBA Macro
- Hi,I am using vba macro for mail merge. I have created htm file as a template and trying to do mail merge, but if fields are more than 62 then it gives error. i have taken then html file but it asks for the table prompt as template contains embedded...
- Tags: Scripting languages, pritivinay@..., VBA
- Discussion threads 2007-08-13
- Sharing Excel Calendar Macro
- I created a calendar pop-up in Excel using VBA. It places the date in a cell, and can be run by keyboard short cut or right clicking the mouse. All of it written in VBA and saved in personal.xlsI saved it as an add-in on a network location. I...
- Tags: Desktops, Scripting languages, Microsoft Office, wendaoneill65@..., Microsoft Excel, PC
- Discussion threads 2007-05-03
- In Excel
- Excel provides over 225 built in functions. Please, can you tell me what kind of function I should use to select only the cells with Conditional Formats/to select only the cells with Data Validation in my huge data without selecting the whole data? Thank you!Try VBA!There is no VBA function...
- Tags: VBA, zimonar@..., windows, Insert Function dialog box, Insert Function, Microsoft Excel, cell
- Q&A 2006-03-11
- Export data from Excel to PowerPoint using macro/VBA code
- Hi, I need to transfer datacharts from excel to a Powerpoint presentation.How could this be done by a VBA code or macro.I am stuck with this for a while. Please help me.thanks,
- Tags: Microsoft Office, ramchandra1.k@..., Microsoft PowerPoint, Microsoft Excel
- Discussion threads 2007-03-13
- How to replace formatted text in Word with a macro?
- I recorded a macro doing just this and the action worked, but not the macro. Basically, I want to, withing a document, delete any text colored red. I also want to change any font in blue to black font.This allows for a document with a lot of instruction to the...
- Tags: Microsoft Word, carter.wilson@...
- Discussion threads 2007-05-29
- Outlook 2003 Macro
- I would like to create a macro in MS Outlook to automate the task of changing the font of a selection in the notes portion of an Outlook task. I copied the text of such a macro from Word, but it gives me an error Run time error 424...
- Tags: Microsoft Office, Microsoft Word, Groupware, Word processors, Microsoft Outlook 2003, dhays, Microsoft Outlook
- Discussion threads 2007-10-25
- Access-Macro to send more than 1 object
- I would like to setup a button that allows me to send via e-mail three reports from Access all at one time. The macro functin or SendObject method only allows one report to be attached to e-mail.Thank you.Susan,unfortunately this will require some vba coding rather than a macro, and...
- Tags: E-mail
- Q&A 2005-04-13
- Accessing a website to which I have passwords
- As part of a macro I am coding for recovering website data, I need to access websites for which I have my own passwords - for example, my bank account. Can I write a vba code macro for a web query which will allow me to access these websites;...
- Tags: Web site development, Web technology, mike@..., Web site, password
- Discussion threads 2007-04-09
- Audio Sampler (gg)
- Use Audio Sampler to easily and quickly play sounds or musics. Press White Key to play recorded sample. Press Black Key to stop the sample. Use "Option" dialog to customize Sampler Keys. This version is the first release on CNET Download.com.
- Tags: Dialog, Audio
- Software downloads 2007-09-13
- Filtering Columns
- I in fact want to filter columns like filtering rows with Auto Filter. However, I know Excel cannot filter columns. Then, I thought of using VBA to do it.I intend to set values in A3:Z3. If the values in any of these 26 cells = 1, then hide the whole...
- Tags: Scripting languages, D2Coop05@...
- Discussion threads 2007-10-23
- F1
- Aw c'mon, did you even -try- to use the built-in Help function? What are you a consultant on?Click Help.In the Search box, enter "macros".In the Search results, click "Run a macro".Now click "Have a macro run automatically..."These steps are detailed for Excel 2003. The sequence may be different...
- Tags: excel, jjoc11762@..., macro, Microsoft Excel, programming, workbook
- Discussion threads 2005-10-21
- I Don't have any experience with M$ Project, but...
- ... I've done a lot of things with VBA on Access, Excel, Word etc. The best way to get yourself un-lost is to record a macro of whathever you want to do:- Tools/Macro/Record new Macro...- change dates, color or whatever- Tools/Macro/Stop RecordingThen you open the VBA editor (Tools/Macro/Visual Basic Editor),...
- Tags: emil.hovsepyan@..., Finish, ms project, Start Date, VBA, windows
- Discussion threads 2005-11-10
- Recording Macros in Word 2007
- I am looking for a way to save shadow formatting for a picture in Word 2007. There is no way to save formatting for pictures that I could find. I was trying to record a macro with the picture's shadow settings, but my selections in picture formatting don't show up...
- Tags: Word processors, jillm@..., Microsoft Word, Microsoft Word 2007
- Discussion threads 2007-08-15
- how to auto run a macro from outlook?
- How to auto run a macro script in VBA of Microsoft outlookDouble-posted.You posted this under Questions, which is where it properly belongs. Please don't post questions under Discussions, and don't post the same question in multiple places.Attach to Application Startup eventPut your code in: Private Sub Application_Startup ...
- Tags: aline@...
- Discussion threads 2007-02-13
- Enable or Disable Macros in Office Documents
- This paper is about macro security and explains the risks involved in enabling macros and how the Trust Center in the 2007 Microsoft Office system can help to mitigate these risks. In this paper, the term "Document" can mean any Microsoft Office file that can contain macros. The term "Macro"...
- Tags: Office Document, Microsoft Corp., Macro, Scripting Languages, Microsoft Office, Software/Web Development, Web Development, Office Suites, Software
- White papers
- Excel VBA SendMail
- I am trying to add a macro button to an Excel 2000 worksheet being used as a form to email the workbook using the SendMail method. I used syntax examples from several sources, Microsoft and VBA experts, and the editor still keeps rejecting them. Has anyone gotten this to work...
- Tags: Microsoft Excel, Microsoft Windows 2000, Microsoft Office
- Q&A 2004-12-17
- Tech Tip: Self-sign macros for security
- Macro security in Outlook allows you tocontrol when macros can run, which helps prevent malicious codefrom affecting an Outlook user's system. When macro security is setto High in Outlook, only digitally signed macros from trustedsources can run. A Medium setting causes Outlook to ask you whetherto enable and allow macros...
- Tags: macro, Microsoft Outlook, security
- Technical articles 2003-12-08
- << Previous
- page 1 of 1
- Next >>
