Before writing this from scratch I'd like to know if something already exists. The need is for a server that accepts data, document type and an optional template id, and returns an MS Office doc (powerpoint or excel) containing the data, in the selected template. [more inside]
What started as a screen scraping project has evolved (devolved?) into working with lots of word files with embedded tables. I found and customized an excel macro to extract them on a file by file basis. I'll describe what I'm doing with it inside. Can you give me some pointers on further automating what I'm doing -- or point me to a forum that can? [more inside]
VBA and Macros and VLookup, Oh My! I might be ending up on a work assignment where they want someone who can create and edit complex Excel templates that interface with Access and Adobe Forms. I've used all these programs extensively, but I've only used advanced features sparingly (either editing someone else's creation or googling for a specific fix for a specific problem.) Difficulty level: I only have a week to cram on this before I would start. Is it possible for a quick learner to get up to speed enough not to crash and burn on a project like this? Can anyone recommend an online course I could binge on before having to take on this project?
I want to be able to open multiple instances of Excel 2010 in Windows 7 on a PC. This is the default for opening Word docs but for some reason Excel limits me to multiple windows inside one instance. Is there a way to do this? Challenge: I do not have the ability to edit the registry on this (work) computer.
What do you need to know to be "proficient" in Excel and Word? [more inside]
Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
Need help with (possibly?) "indirect" in Excel. [more inside]
How to prevent accepted tracked changes from carrying over into an excel + word + outlook email to 50 people?
Hi everyone, Hoping someone can help me sort this problem ... It's a excel + microsoft word document + mail merge to outlook email to 50 people. I am trying to help someone out - this is is as it just as it was described to me: Track changes were accepted and turned off and the email looked as it should - so off went 50 customized emails. ..unfortunately the sent email then shows that all the emails are sent showing all of the tracked change revision markings! Sorry if this is too vague. Thanks for your efforts :)
Passing an MS Office test with flying colors. [more inside]
Where can I download more attractive funnel chart templates for Excel 2007? [more inside]
Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using
bubblegum and string the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]
Trying to get some modified AVERAGE results in Excel. [more inside]
I need MS Excel and Word to play together nicely. I can do what I need to in Word, and I can do what I need to in Excel; it's the Relationship that's Complicated. Maybe I need workflow advice? Basic knowledge? Please, please keep reading. [more inside]
MS Excel Question: If I have a column with a range of dates in it, is there a formula that will tell me how many years ago that date was from today? [more inside]
MS Excel filter: I'm editing a huge spreadsheet and Excel doesn't like my zip codes. How can I quickly fix this? more after jump... [more inside]
I can't get a formula in excel to recalculate when copied and pasted to another cell. Help! [more inside]
OfficeApp Filter: How can I seamlessly convert lists of project assignment names and deadlines to a calendar view that can be shared? Or can I? [more inside]