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
ADVERTISEMENT
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
View Related
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
Feb 21, 2010
I've just learned a good way of having my company logo entered in the header with a fair bit of customization. Also a footer, but after creating a new sheet from template it crashes. Using office for mac 2004 11.5.5, what I can do or a different way to quickly enter, macros look a bit complex for an amateur like me.
View 1 Replies
View Related
Mar 1, 2009
Is there a size limit for importing an Excel File into Numbers? The error message says the file is too large. Has this been changed in i-work 09? The file has multiple sheets that refer to each other, but i can't even open at this point. It is 3.1 MB.
View 4 Replies
View Related
Sep 1, 2010
I am trying to move contact info for a list of clients from an excel spreadsheet to address book. I am using office mad 2008 and regular address book (not Bento or anything) I can't figure out how to do it.
View 2 Replies
View Related
Dec 6, 2010
Some content in Name.xls may not be saved because it is not compatible with the Excel 97-2004 Workbook (.xls) file format. Do you still want to save the workbook in this format? To save the workbook in a new format and preserve all content, click No, and then on the Format pop-up menu, click Excel Workbook (.xlsx). To save the workbook in the current format and remove all incompatible content, click Yes." Somehow I managed to not read the popup properly and just went ahead and saved (clicked "yes"). I then closed the spreadsheet and now all the work from the past 4 hours is gone.
View 2 Replies
View Related
Dec 30, 2009
In my old old old excel 2003 when I was searching for some words in excel sheet (e.g. in the column) I could choose "to find all" option. So I saw all the results in the "find" window. In excel 2008 for Mac I can see search results only one by one not altogether. On microsoft site http://www.microsoft.com/mac/help.ms...f-17820d214cef
I couldn't find tha answer also. Does anyone know how to make it in excel 2008 for mac so i could see all search results in the "find" window?
View 3 Replies
View Related
Jan 7, 2010
How do I get data analysis in excel 2008 in mac?
View 3 Replies
View Related
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 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.
View 5 Replies
View Related
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
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
Jul 19, 2010
I asked some time ago about the Mac Mini. Well, after that Mac Mini got that much expensive, I decided to get an iMac. Well and today my MacBook Mid 2007 died (doesn't turn on any more). Grr.
So I'm going to get the lowest iMac (21", 4GB, 500 GB HD, C2D 3.0 GHz) which is only Eur 300 more than the mini AND has a display. Besides that it's got 2 additional memory slots, so I can upgrade it for little money to 8 GB if I need that.
Okay, but my problem is another one.
As I stated above, my MacBook died. My Time Machine is from friday or so...
Can I attach its HDD via SATA2USB-Adapter and tell Mac OS to import user data from that SATA-HD? Or do I have to boot somehow from this HD to upgrade my TM to import it to the new HD?
View 3 Replies
View Related
Apr 26, 2012
Is it still the case that one cannot import data from Outlook into Mail without having to pay for additional third party software to facilitate the task and IF so - do we know whether Apple plans to resolve this?
View 1 Replies
View Related
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
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
May 19, 2008
I used to use Entourage but can no longer open it (ID no longer works). I still have my old Entourage identity/data and want to import all of this into Apple Mail. But there is no option to import Entourage data without opening Entourage (which I can't do anymore). Any suggestions how I can import the data to Apple Mail?
View 1 Replies
View Related
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
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
May 29, 2012
I find it slow to edit data in iTunes (e.g., changing to last name first, filling in data when missing from old CDs). This would be very easy to type, copy/paste, copy down, etc. in Excel. Is there a fast way to edit data in iTunes? (faster than clicking on a song, waiting for it to know you're changing data, typing the data and not being able to copy/paste)
View 1 Replies
View Related
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
Jul 1, 2009
I'm running an experiment that will give me a spreadsheet in Excel with 20 participants names, addresses, email addresses, and profits (from the experiment). My goal is to take this data and create individual receipts in Word that have all the above information and can be printed out and handed to the individuals (20 receipts). I have access to Office 2004 (Mac) or 2007 (Windows).
View 1 Replies
View Related
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
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
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
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
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
Sep 6, 2006
I have a EMac with Mac OS X vs 10.3.9 Prior user erased hard drive. Took to ADR data recovery and they scanned the hard drive and were unable to recover any data. Looking for input on other techniques to recover data from hard drive or other companies that specialize in Mac data recovery.
View 6 Replies
View Related
Oct 24, 2009
I burned a video I shot of my sons baseball game. Loaded it into iMovie and created a finished project. I shared it to iDVD and burned a DVD. By accident I deleted the project from the project liabrary (and the event.)How can I load information on the DVD, back on the hard Drive so I can keep the footage. My goal is to make a best of DVD at the end of the season.
View 3 Replies
View Related
Oct 14, 2004
On my powermac G4 I have my contacts in Entourage. There are like a total of 1200 and I really don't need all of them on my new iBook so I've limited it to 200 of close contacts and saved them as vcf. Then I emailed myself the vcf file and try opening it on my new iBook which happily imports them into Address Book instead of Entourage (it also seemed to lose alot of the details, like categories).
I look for option in Entourage to import a VCF and it doesn't seem to have it. How do I import a VCF into Entourage? Or how can I these select contacts onto my laptop installation of Entourage?
View 4 Replies
View Related
