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]
I need some guidance in writing a macro that will parse a glossary Word document and reformat it into an Excel spreadsheet with the term in one column and the definition in a second column. [more inside]
What's a good non-cloud collaborative software alternative to Google docs? [more inside]
I have a spreadsheet that has students’ names and their class schedules. We want to be able to email the class schedule to the students using an email mail merge. I am willing to use Excel/Word or Google Docs/Sheets. I think I have figured out how to use a directory mail merge in Word to print the schedules, but we really need to email the schedules to the students instead of print them. [more inside]
With my gmail account I am in frequent contact with a particular individual. So frequent that our emails are kind of a mess, and I want to know if I can organize them in any way. [more inside]
I have a spreadsheet that contains information I want to use to fill out a form, Mad Libs style. Essentially, I'd take each row of the spreadsheet and use the cells to populate a text document. It's not actually in Excel/Word - it's in Libreoffice, if that changes anything. I also need room for conditional if-then statements, because some text may require additional accompanying notes. I tried generating a pdf in Nandeck (card game generation software) but that doesn't work well for formatting text relative to other text, so I'm looking for a better solution.
I'm using Excel and Word 2007. Created Excel docs, created Word docs, certain cells in the Excel docs have data that must be embedded in the Word docs. This has been discussed here before, but only the method of creating these links (which was my method) but I'm just checking to see if anybody knows how to make this work when you move the document. All the links appear to be hardcoded absolute links to the Excel doc. Works fine on my PC, breaks on yours. Any way to get this functionality to be portable? [more inside]
Help me turn my iPad into a work productivity tool. [more inside]
What do you need to know to be "proficient" in Excel and Word? [more inside]
I have a batch of mixed-format data including long-form text fields, hyperlinks, number and plain text in an Excel doc. I have assembled a Word catalog merge file intended to allow me to proof the data manually. There are 42 records. On merge, the output document results in what appears to be the correct number of pages and records. However, records 28-42 do not appear to place any data in the destination document. [more inside]
ExcelFilter: I have a whole bunch of excel files. More than 100 of them. Each file has about one page of print area, but some in portrait and others in landscape. They are mostly text in cells; not a lot of formulas being used. I would like to (1) merge all these files into one Word document; (2) have a page break so that each file (more or less) is one page; and (3) do it with a minimum of cutting and pasting. Opening everything as a PDF and viewing in Preview is also an option, but less optimal since I'll certainly need to adjust some formatting and page breaks. Maybe on publisher? Is anything like this possible? Or do I need to do it page-by-page? What would you do? I'm on a Mac 10.8.2.
Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
How to make a pie chart in Word with dollar amounts, not percentages? [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 :)
Can anyone recommend a good, well-trafficked forum for Microsoft Office (particularly 2010) questions? Seems like this should be eminently Googleable, but maybe because there are so many of them, I'm not finding the one that is the one. Thanks!
How can I create a web-based table of contents that links to specific places within a diverse collection of documents? [more inside]
Microsoft Access 2007 - how on earth do I cut / copy / export / do anything with my Pivot Chart, besides print it? [more inside]
Microsoft Office 2007 filter: Can you recommend a program/plugin (or the like) which will replace the "ribbon" interface with a traditional menu interface? Free is ideal, but for-pay is okay, too. Running Windows XP. Thanks.
I need help copying a table from Word to Excel in Office 2007. Where there are hard returns within a cell in the Word table, Excel splits the table cell into multiple rows. I need Excel not to split cells in the Word table into multiple Excel rows. At the same time, I need to retain the paragraphs that appear within the Word table cells - that is, I can't just get rid of all those hard returns; the formatting must be preserved. My Google-fu is failing me rather seriously. Is there any way to do this?
Passing an MS Office test with flying colors. [more inside]
Is there a way to insert into a text string in Excel a "hard enter" so that when a series of rows of text are copied into Word that it automatically incorporates paragraph breaks between them? [more inside]
I'm trying to paste some text from Excel into Word. Normally when I do this, I select Paste Special > Unformatted Text so my stuff doesn't display as a table. But this time, the Excel text is already formatted with a ton of bold, italics, and underlining, and I don't know how to retain that formatting while still ditching the table. Help? [more inside]
Need list of trade publications. Found huge one on Ulrich's web. How can I remove all information except for the (hyperlinked) titles, ideally in a way that keeps the titles on separate lines so I can then paste them into Excel? [more inside]
Can you reccomend me a good Excel 2007 Book? I'm currently studying a foundation degree in Renwable Energy in the UK, and am struggling with Excel 2007. A general book would be handy, but the main topic I'm really struggling with is 'visual basic', so it would need to include detailed information on how to use that and the coding system of Excel. Can anyone reccomend a good book to get that would include information relative to that?
Can you recommend online tutorials for Excel, Word, and MS Access? [more inside]
How do I keep a particular tab in Word2007 from automatically disappearing? And other Word2007 and Excel 2007 questions inside. [more inside]
I'm looking for a job doing presentation graphics (in law firms, possibly financial firms); this is about 30% of my current job at a law firm. I'm one of very few "experts" at my firm which isn't very technologically advanced in this area, so I'm afraid that my skills won't cut it in the outside world. I need advice on how to upgrade my skills. [more inside]
Does anyone know how to remove the formatting (for lack of better expression) column borders that accompany text when I paste it from Excel to Word? I've checked both Word & Excel help to no avail, probably because I can't frame the question very well. Thanks.
Is it possible for an email attachment in Outlook to 'update' itself from a network drive? My attachment is not the same now as it was when I first received and viewed it. [more inside]
Can I download only OpenOffice Writer? [more inside]
I need to make a template for an in-print events calendar, and I'm not sure what the best way to approach this project is. Advice please! [more inside]
My main computer is a Mac (iBook) and I use the Address Book and Apple Mail. I also manage the email list for a group, and I need to be able to export the list of email addresses to either Excel (preferably) or Word. I haven't figured out how to do that. [more inside]
Has anyone taken the Office Proficiency Assessment and Certification (OPAC) test recently, or have documentation on what exactly it tests for in Word and 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]
Automation Filter: How can I automate the insertion of data from a spreadsheet into a Word report template? [more inside]
How do I get 'rock hard' Microsoft Office skills? [more inside]
How can I make readable Word tables out of a large Excel spreadsheet? [more inside]
Help me create custom documents out of pre-written paragraphs in Word. [more inside]
Question on converting numbers into formatted text with Excel. [more inside]
The management at the company I'm working for has sold a couple customers on a product that we as the worker-bees have yet to produce. That being said I view this more as an opportunity to do something new than as a huge hassle, assuming we can figure out a convenient way of producing said product. So I was hoping the great and wonderful MeFi might have a couple suggestions they might throw my way. [more inside]
How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row. [more inside]
I'm doing a code review and I'm keeping track of my findngs on an Excel spreadsheet. I need to generate reports that show vital details about the source code file being reviewed. Unfortunatley, as far as I can tell, MS Word 2003 generates one Word doc that has all oft he merged content in one file. How do I get it to create separate documents? [more inside]
My girlfriend is going for an interview where she will be tested on Microsoft Word and Excel. Is there an online tutorial where she can take some sample tests or run through some applications? We've googled a few, but they seem to stop at beginner levels and to be rather cumbersome. Just wondered if anyone had some first hand knowledge of a site to head to. Regards/p &k
A friend has a large list of address labels in column format which were created in Excel, then exported to Word. He no longer has the original Excel file. [more inside]
Complex Excel to Word merge question is the [more inside]
I need some computer work done for me and I'm not sure how to find someone to do it. [more inside]
Is there a quick way to create a mail merge directory in Word from an Excel spreadsheet, broken down by a specific field (department, category, etc.)? This seems like a Microsoft 101 question, but the built-in Help doesn't seem to address this specifically, and online help from Word 2002 gets into code I can't even begin to understand. [more inside]
I need help finding or creating a macro to transliterate Cyrillic characters to their Latin-alphabet, English-language "equivalents" without doing a massive find-and-replace by hand. [more inside]
When I try running long complex macros in MS Word for OS X, created in Office for Mac OS 9.2, some of the macros are freezing/crashing. Perhaps even worse, the macros don't seem to be failing at the same point each time I try to run them. [more inside]
I'm working on my MA thesis and so have an enormous jumble of books, articles, and references kicking around. I am looking for an easy way to manage this. [more inside]
Page: 1 2