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.
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?
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.
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 192.168.1.1 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.
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.
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).
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?
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...
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!!
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
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.
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.
Info: MacBook Pro (Retina, Mid 2012), Mac OS X (10.7.4)
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?
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.
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.
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".
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.
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.
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
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?
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.
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.
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.
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.
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.