Applications :: Can't Assign Macro In Excel

Mar 4, 2009

I spent at least 30 minutes struggling with my new computer because the path name of my macros had changed. Turns out, you must manually change every item in your Excel palettes that calls a macro. That's easy, you control click on the palette icon, select 'assign macro', and choose the macro.

But although that command was not greyed-out, when I selected it, nothing would happen. There was no error message.

I found no solutions on the internet, and in the course of the 30 minutes, tried various desperate things involving new taskbars, searching for mysterious excel.xlb files, VBA scripts to build taskbars. In the course of that, I broke a bunch of things on the palette. But I found the solution, and joined this group, just so I could tell the world.

You have to have some worksheet open.

Yes, that's it. It makes no sense, but that's it.

View 1 Replies


Applications :: Importing Data Into Excel - How To Use Macro

Dec 8, 2009

I am trying to make an excel sheet on all of my photos. I have found a program to exports exif information in html or txt files and it is the only program I have found that displays the fields I need (Windows XP title, comments, keywords, etc). Anyway, the program will only export all of the data (I can't just select the fields I want) and it also makes a new files for each photos (and names them whatever the photo is named so yes sequential). I have been playing with importing html and txt files into Excel 2008 and need help. I am looking for a way to only import the rows I need and to automate it so I don't have to do 10,000 photos by hand.

On another forum, it was suggested to use VBA (visual basics) in excel on windows which looks promising but I know little about it and will have to borrow my sister's dell to do. Another suggestion was to combine the text files and use a Macro in excel in which I also have little idea on how to use. Can Apple Script or Automator or any thing else help me here? I know Excel 2008 for Mac doesn't have VB but what about macro on it?

View 10 Replies View Related

Software :: Excel 2004 - Disable Macro Message?

Dec 22, 2005

In Excel 2004, I created a macro. I then deleted it using the Tools --> Macros... dialog box. I still get the message about enabling/disabling macros when I open the file. I have tried using the VBA Editor to delete it, but I don't see a "Module 1" (or anything else for that matter) that contains the macro.

I know I can turn off the macro warning in the preferences, but I'd rather figure out why I'm getting the message and get rid of it without turning off the macro warnings.

View 1 Replies View Related

Applications :: Looking For Macro Software?

Sep 8, 2010

I want a program where I can press some sort of combination of keys and I'll get a prompt, and then I can type a command that I can customize and it'll type the custom output.

For Instance:

I hit option-alt-space and something comes up and i type gotoserver and it types ssh -l user so it types it in the terminal for me.

or maybe even opens up terminal and types that in for me maybe it could even wait for a prompt or for some time and then type the password too.

I got quickeys but I can't get it to do anything like this.

View 5 Replies View Related

Applications :: Searching Mouse Macro Recorder?

Feb 20, 2007

I have searched for this, but cannot find any.. I need to do some raw mouseclicks on certain coordinates on the screen, and then loop it forever until I stop it. Anyone know any programs that can do this?

I tried to fiddle around with apple script, but can't figure out how to do that.

View 2 Replies View Related

Applications :: Word Documents Are Infected With A Macro Virus?

Mar 23, 2009

some of my Word documents are infected with a macro virus. I'm not sure how many are infected, although I know it's not all Word docs. I'm running Office 2004 for Mac Student and Teacher Edition. How can I fix this? I'd like to prevent other docs from also becoming infected. I have no anti-virus installed and I'm still running Tiger 10.4.11 (hoping Apple releases Snow Leopard soon so I can finally upgrade).

View 6 Replies View Related

Applications :: Using Mac Excel - Merge/Filter/Extract Into A Single Excel File?

Feb 6, 2009

I am searching for a plugin, software or a solution for a situation I have with an Excel/Word Mail Merge.

It's a law firm we specialize in DUI/DWI and Reckless Driving defense. We subscribe to a data collection service that pulls data from various court systems around the state. We are then given this data by jurisdiction. The Excel files we receive come with 2 workbooks in one file for Traffic and Criminal arrests data with name, address, reason for arrest, etc, etc.

What I have been doing is opening each Excel file and copying and pasting into a new worksheet only grabbing the DUI and Reckless driving arrests because tis is all I am needing from the various files. I then save the new workbook and do a mail merge with Word from this newly created workbook.

Now my question is there such a plugin or software that will combine all the Excel files I receive from the Data collection house and then be able to filter out only the DUI and Reckless Driving arrests to a single Excel Workbook?

View 6 Replies View Related

Applications :: Turning List Manager In Excel Off / Moving Columns In Excel?

Apr 13, 2010

1. Turned the List Manager on by accident in Excel. Can't figure out how to turn it off now. I am using Excel 2004, and a MAC mouse - so no right-clicking for me...

2. How do I move columns in Excel? I select the column on top, but then try dragging it to a place I'd like it to move, but nothing happens. How do I do that?

3. General Mac Word/Excel question - how do I get to use "Home" and "End" buttons? When I hit them I simply jump somewhere, but not to the beginning or end of the paragraph. I have a MAC keyboard with the "Home" and "End" buttons along with the "Help", "Delete", "Pg Up" and "Pg Dwn" keys - basically it looks a lot like a PC keyboard...

View 1 Replies View Related

Applications :: Excel: Pulling Weather Into Excel Spreadsheet?

Oct 21, 2010

I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do!!

View 3 Replies View Related

Applications :: Excel: Pulling Weather Into Excel Spreadsheet??

Oct 21, 2010

I have been asked to do a project at work in Excel. I am keeping track of around 7,000 properties all over the United States. My boss wants to know a lot about each one. I am really struggling with the weather part!! I need to somehow pull the temp and if its snowing or raining from the internet into excel. I have all the addresses and zip codes for each property. I was thinking i could write a formula that looks at an RSS feed or website (like yahoo or Google weather) based on the zip code of the address. I could also write the formula that pulls the weather to excel then VLOOKUP the zip. Does anyone have any ideas about this?? I am not sure what to do

View 1 Replies View Related

Applications :: Difference From MAC Excel 08 To PC Excel 2003

May 22, 2010

I recently purchased my first MAC with Excel for Mac 2008. I am unable to open any files created in it on my PC which has Excel 2003. Apple is of no help. They had assured me of compatibility at purchase citing the new open format. The MAC Excel 08 file won't open on the MAC on which is was created with their Numbers program either.

View 4 Replies View Related

OS X V10.7 Lion :: How To Assign Specific Applications To Spaces

Mar 24, 2012

How do you assign specific applications to spaces in OS X Lion?

Mac OS X (10.7.3)

View 10 Replies View Related

OS X V10.7 Lion :: Assign To All Desktops For Multiple Applications

Jun 20, 2012

Trying to set up a second monitor, which I want to use as my "universal communication dashboard" across all of my spaces.In other words, I want to run a bunch of applications there which should appear regardless of which space I'm on. To do this I know that I just right click the application and select "Assign To: All Desktops" but for whatever reason only one of the applications follows me from screen to screen, even if I have all three selected.All three applications are set to start on login.This seems like a blatant bug in Lion and I would love advice on how to fix it, or how to nag Apple until it gets fixed.

MacBook Pro (Retina, Mid 2012), Mac OS X (10.7.4)

View 2 Replies View Related

Applications :: Assign Custom Quick Phrases To A Keyboard Shortcut?

Mar 30, 2010

Back in the days I used a PC, I used to be able to assign custom quick phrases (like "Sincerely, Emily") as a keyboard shortcut. For instance I'd assign my phrase to F3 or something...and then voila!!! I could insert commonly typed phrases into my emails or word processing. SO NICE! And I miss that. Anyone seen this feature in Mac Mail?

View 2 Replies View Related

Applications :: Using Mac Excel To Windows Excel?

Nov 10, 2009

When I send my .xls files from my Mac (Office 2008) to my boss's Windows machine (Office 2003), he gets an error message when he attempts to open the excel spreadsheet: Excel has encountered an error and must shut down. I've sent files to other computers and not had a problem, and my boss has received other excel files and been able to open them. So it must be something between these two machines/softwares that is affecting it. Any suggestions or ideas? I can add any additional info you need.

View 2 Replies View Related

Software :: Macro Virus In Every Word Doc?

Feb 6, 2009

It seems that every word doc I create has a self generated macro virus embedded in it and when I go to email it as an attachment GMAIL doesn't allow it to be attached.

I also get the warning window about disabling Macros when ever I go to open a word doc on my MacBook Pro.

How do i alleviate this virus from existing docs without destroying content and also rid my laptop of future issues with this virus.

View 1 Replies View Related

OS X Mavericks :: How To Create A Simple Macro

Sep 4, 2014

I do a simple copy and paste, but wanted to know if I can create a customize "Hot Key" on my keyboard that will paste in the word? Lets say the phrase is "Confirmed: ID".

View 1 Replies View Related

OS X :: Want A Global Macro To Switch To Finder And Hide Others?

Mar 8, 2010

easy and free way to create a macro that will switch to Finder and hide others from any application?

View 3 Replies View Related

OS X :: How To Find Itunes Delete Key Right Next To The Next Button Macro

Apr 19, 2010

ok so I have 13000 track on my computer. I probably hate 9000 of them. This collection has been building up for a good 10 years. I like to listen to music on random. I want to be able to either hit "next" or "delete".

I dont want to have go to itunes window, hit delete then "Move to trash". I want the delete button to do that. even if I'm not on the itunes window.

thoughts? It also doesn't have to be itunes. I don't care what it is. if its not itunes i can use it for a month to syphon through all my music then all thats leftover Ill enjoy through itunes.

View 3 Replies View Related

Mac Pro :: How Much Ram Should Assign PS CS3

Feb 18, 2009

so I just installed an extra 4gb of ram in my mac pro, I'm wondering how much should I assign photoshop to use while still being able to run Illustrator, and what ever else.

View 2 Replies View Related

OS X :: Way To Assign A Different Key As The Period?

Nov 27, 2009

My aunt spilled wine on her ibook G4 and the period key won't work and hasn't for ages Is there a way to assign a different key as the period? This copy and paste crap is really getting annoying She's running OS 10 3 9

View 4 Replies View Related

MacBook :: How To Assign F5 And F6 Keys

Feb 27, 2008

I want to assign the F5 and F6 keys on my Macbook to work as 'Page Up' and 'Page Down'. I'm not sure if it is possible to do this for all applications...If it's not, I would just want to use them in Firefox. I tried system preferences > keyboard and mouse > keyboard shortcuts...but had no luck..I don't know what menu command to enter when I create my own shortcut..I can't find page up or down in the menu for Firefox?

View 8 Replies View Related

OS X V10.7 Lion :: Possible To Assign An App To Several Desktops?

May 21, 2012

I'm referring to the desktops you can add in mission control. In the dock, when you click on an app and hold it (or right-click) you can go to options and then assign on which desktop this particular app should open. You can choose on all desktops (which will make the app follow you, no matter to which desktop you are switch), you can choose on the desktop you are now on and you can choose none.But how do you choose several desktops? Is that even possible? Because I don't think so.I am using the Logic arrange window and would like to have the Mixer on a different desktop.

iMac, Mac OS X (10.7.3)

View 6 Replies View Related

Applications :: Using Excel For Mac - How To Landscape?

Sep 10, 2010

I work a lot in Excel for Mac and I have noticed an annoying feature that I can't seem to change. No matter how many times I save a document in "landscape" it keeps on reverting back to "portrait" every time I open it. I have tried to default to landscape but it has not worked.

View 14 Replies View Related

Applications :: No Add Ins In Excel 2008?

Jan 21, 2008

There are absolutely no add-ins for Excel 2008 for mac! I really need the data analysis toolpak for school and work. Does anybody know if it's possible to download this toolpak from somewhere and install it? I've tried looking and have come up with nothing so far.

View 12 Replies View Related

Applications :: Excel 08 Keeps Crashing

Apr 20, 2009

Microsoft Error Reporting log version: 2.0

Date/Time: 2009-04-20 23:11:30 -0400
Application Name: Microsoft Excel
Application Bundle ID:
Application Signature: XCEL
Application Version:
Crashed Module Name: libobjc.A.dylib
Crashed Module Version: unknown
Crashed Module Offset: 0x0001568c............

View 9 Replies View Related

Applications :: Doing T-tests In Excel?

May 4, 2010

I am wanting to do a t-test in Excel (for a class I am teaching). So as a practice, I did this (in columns A and B):


These are my two groups, with means:


Certainly the means seem different!

However, the ttest procedure gave me this p-value:

The formula was this:

View 1 Replies View Related

Applications :: How To Sort In Excel

Jul 8, 2010

I was wanting to know how to sort a list of birthdays in excel by month and day only (Not including years); I also tried to add only the month and day data but it kept sticking 2010 on the end.

View 1 Replies View Related

Applications :: Spellcheck In Excel For OS X

Aug 3, 2010

Let's ignore for a moment how awful Microsoft Office products are on a mac. Anyone know how to turn on spellcheck? I don't see it in the preferences.

View 1 Replies View Related

OS X :: Inability To Assign F Keys For Keystrokes

Jan 7, 2010

Had to reinstall 10.6.2 on IMac after erasing disk for an earlier problem with Adobe CS4 installation. The Adobe Tech Support could offer no help with all log files submitted and as a last resort suggested I erase the internal drive and reinstall system and applications. It worked. But: Two problems encountered so far are : Inability to assign F13 key "to look up dictionary" (default being command -control-D) and the F11 and F12 keys no longer control sound volume as they all did before the reinstallation. I am unable to assign the keys in the System Preferences as suggested by Apple.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved