Tagged Questions

0
votes
1answer
50 views

How to find document variables in MS Word without using a Macro

I have document with some document variables in and I'm trying to use those variables in the document. But since the variables are set by an external system (which is not well documented) I'm playing ...
0
votes
1answer
21 views

Office 2007: assign a different keyboard shortcut to “find”

I'm trying to assign a single key (F2) to the "find" command, but I cannot find it in the list of commands. As you can see here, I can see the "find" command when it comes to add it to the Quick ...
1
vote
0answers
81 views

Runnning macro when specific text is entered on Word

How can I make a macro that does something whenever a specific text is entered on Word. Can you give me a simple example of a macro that, for instance, is run every time some text is entered between ...
2
votes
1answer
49 views

How to register a macro programmatically?

I have like 700 machines in which I need to deploy a new macro we have created. Is there any way to do this via cmd?
2
votes
2answers
633 views

In Excel 2007 where do you store macros that you want to use on all sheets that you open?

It looks like you can store it in a file called PERSONAL.XLSB and that will create "Global" (for all worksheets) macros. This file is of course stored in your user profile ...
0
votes
0answers
136 views

Access 2012 - Can't find object

When opening certain macros, whether in design or run, I get ' Microsoft Access cannot find the object 'whatever the object name is>'. This only is on certain macros, but most of them work properly. ...
1
vote
1answer
2k views

How to select radio buttons by cell value in Excel?

I have a group of radio buttons with labels in adjacent cells. How can I arrange for the radio button with the label matching a target cell value to activate? Here's an equivalent example to what ...
2
votes
1answer
3k views

Word: Resize Image by Percent - Macro

I routinely paste many screen captures into Microsoft Word 2007 and then have to manually resize them to around 75%, which becomes very tedious. The screen captures are all different sizes. I've ...
1
vote
2answers
936 views

Office 2010 macro issues

I have some macro enabled word documents that worked fine in Word 2003, but in 2010 I cannot get the macro security settings to behave properly. When I first open a macro enabled document, I get this ...
0
votes
1answer
63 views

Key Stroke of SHIFT i displays “BIG PAPA” instead (full Virus/Anti Spyware Scans complete!)

This is a bit weird, and seems to be localized on three machines with MS Office 2007 and 2010, have scanned all three units (one of them was removed from the network, completely formatted, and the OS ...
0
votes
1answer
3k views

Excel cannot open the file “filename.xlsm” because the file format or file extension is not valid?

In Excel 2007, I get this error when I try to run a script a friend posted to the web. I have heard of no one else having trouble. Any ideas what might be going on here?
-1
votes
3answers
250 views

Macros Excel 2007 - extracting data

Im trying to extract certain data from a cell and trying to put it somewhere else within the same cell. Any suggestions? EDIT I have several text strings in ONE cell (a date, a part number and a ...
1
vote
2answers
194 views

Can I get word to ignore the macro security setting for one specific file?

The Word security seems to be. You can't run any macros at all so there. You can run some but I'll keep asking you are you sure are you sure are you sure until you choose option 3. You can run ...