Search
Excel Help Forum - Excel Programming / VBA / Macros: Macro/Automatic script that scans for certain values.
Excel Help Forum - Excel General: Extracting Descriptions from one spreadsheet to appropriate part numbers on t...
Microsoft Word - Is there an Accordion Effect in Word ?
Microsoft Word - Is there an Accordion Effect in Word ? |
- Is there an Accordion Effect in Word ?
- VBA: Save as PDF macro
- Office 2007 referencing problem
- Word 2007 track changes does not always print properly
- How do I show the tabs bar?
- problem with even pages
- Office 2013 preview: cannot open documents attachment in mail client.
- Error Inserting Excel 2007 into Word 2007
- Why is one of my references working backwards?
Is there an Accordion Effect in Word ? Posted: 24 Oct 2012 05:07 AM PDT Does Microsoft-Word 2007 or 2010 has any thing like "Accordion Effect" to be able to display or not some paragraph as I wish? (without deleting of course) |
Posted: 24 Oct 2012 02:54 AM PDT Greetings! I made the following macro to save current document to PDF: Option Explicit Sub SaveDocumentToPDF() Dim PDFFilePath As String Dim PDFFileName As String Dim RetVal With ActiveDocument PDFFileName = FileNameNoExt(.Name) & ".pdf" PDFFilePath = .Path & "\" & PDFFileName '.SaveAs FileName:=PDFFilePath, FileFormat:=wdFormatPDF CreateBookmarks:=wdExportCreateHeadingBookmarks .ExportAsFixedFormat OutputFileName = PDFFileName, _ ExportFormat:=wdExportFormatPDF, _ OpenAfterExport:=True, _ OptimizeFor:=wdExportOptimizeForPrint, _ Item:=wdExportDocumentContent, _ CreateBookmarks:=wdExportCreateHeadingBookmarks RetVal = Shell("explorer.exe " & .Path, vbNormalFocus) End With End Sub 'The following function returns the filename without the extension from the file's full path: Function FileNameNoExt(strPath As String) As String Dim strTemp As String strTemp = Mid$(strPath, InStrRev(strPath, "\") + 1) FileNameNoExt = Left$(strTemp, InStrRev(strTemp, ".") - 1) End Function Despite the fact that PDFFilePath is correct, the output PDF is saved beside the original DOC, but always named False.pdf. Could you help me to find the problem for such wrong name or maybe I should use different VBA function? Thank you in advance for a detailed reply! |
Office 2007 referencing problem Posted: 24 Oct 2012 02:30 AM PDT hi i am on office 2007 but i do not get a selection choice for the APA referncing style in the dropdown list . i understand i should see " APA fifth edition" and " APA 6th edition" but on my machine i only see "APA" |
Word 2007 track changes does not always print properly Posted: 23 Oct 2012 11:32 AM PDT I have a user that uses the track changes feature. When she creates a document and shows the track changes it displays correctly on the screen but when she goes to print it the right hand margin gets truncated. We can print the same document to another printer and it prints correctly. This does not happen all the time. Sometimes another document with track changes prints correctly on her printer. This has been going on for a few months now and we have not found a solution as we cannot create this problem with any consistency. Any suggestions? |
Posted: 23 Oct 2012 09:34 AM PDT When I had Word 2007 I remember having a bar across the top of the screen showing the tab settings. Now I have Word 2010 and I don't see that bar and I cannot figure out how to put it there, if not all the time, then at least when I want to have it there. Can someone help me? |
Posted: 23 Oct 2012 08:07 AM PDT HI, I've a problem with the body-text only in the even pages. I think it's all about the ident of first row of a paragraph. I show figure to explain better: (1) (2) (3) It's not a problem for word "informazioni" I'm in the (1) situation. I need to use all the space for the words. How can i do it? It's a word 2010 bug or it's a my fault? |
Office 2013 preview: cannot open documents attachment in mail client. Posted: 23 Oct 2012 12:34 AM PDT Hi all! I encounter very annoying.I installed windows8 + office 2013 preview. "Microsoft office can not verity the license for this product. Try repair the office program by using control panel" |
Error Inserting Excel 2007 into Word 2007 Posted: 22 Oct 2012 08:07 AM PDT I get an error when I try and insert an Excel 2007 Spreadsheet into Word 2007. The error message that I receive is: "The program used to create this object is Excel. That program is not installed on your computer.
Both MS Word 2007 and MS Excel 2007 are fully installed on my computer. I can insert an Ms Excel 2007 spreadsheet into a MS Word 2007 document and it works just fine. I am doing this on a Windows 2003 server computer. Steps to recreate. 1) Open a new or existing MS Word 2007 document. 2) Click on Insert, Oject, Create from File (with Display as Icon checked or unchecked (it doesn't make a difference). 3) If Display as Icon is unchecked, I get the "The program used to create this object is Excel. That program is not installed on your computer. 4) If Display as Icon is checked, then the process appears to work ok, the icon is inserted. But when I double click on the icon, I ge the same error message. 5) If Link to File is checked, then the process works okay.
I have seen this error message numerous times in web searches, but I have never seen it solved. |
Why is one of my references working backwards? Posted: 19 Oct 2012 10:32 AM PDT I am putting together a work manual with a specification that foldout pages must be at the end of the manual, but a reference page must be placed in the procedure to refer to the foldout page. To accomplish this, and keep the references current as the document changes, I placed the figure number on the reference page and then used a standared reference ot the figure on the diagram. Then to keep the page number of the diagram current on the reference page, I made the diagram page number into a bookmark and use a standard reference of the bookmark on the reference page. So in essence I have two links between two pages one going in each direction.
The problem I am having is that after saving, closing and then re-opening the document, the text material from the reference page is being duplicated on the diagram page. It is as if the bookmark is working in reverse even though if I ctrl+click on the reference page it takes me to the digram page so the bookmark is working correctly with that respect.
Any ideas? The reference structure is shown below.
reference page TEXT: figure title caption REF: bookmark of diagram page number
Diagram REF: figure title TEXT: page number |
You are subscribed to email updates from Office Forum - Answered Threads, Microsoft Office Word To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
Google Inc., 20 West Kinzie, Chicago IL USA 60610 |
Excel Help Forum - Excel Programming / VBA / Macros: Problem with formula
Excel Help Forum - Excel General: How to Share Workbooks between Multiple Users?!?
Excel IT Pro Discussions Forum: Excel 2010, Data Validation List, wrong order.
Hello,
I created a Data Validation to, "List" some items in drop down menu. It works fine, but I have about 20 items in it, and when I click the "Down" arrow to view the drop down list, it starts from the bottom. I'd like to view the first item in the list to be shown on top.
Any suggestions?
Excel Help Forum - Excel Programming / VBA / Macros: Help Requested in Creating Hyperlink VBA
Excel Help Forum - Excel General: Need help with function and date sorting
Excel Help Forum - Excel Charting & Pivots: How to Plot Data Labels on a Chart with a text value instead of a numeric value
Excel Help Forum - Excel Programming / VBA / Macros: Moving an entire row to new worksheet based on variable cell value.
Excel Help Forum - Excel General: Hide duplicate information
Excel Help Forum - Excel Charting & Pivots: How to Plot a Bar Chart with FY and Quarters displaying on the Horizontal Axi...
Excel Help Forum - Excel Programming / VBA / Macros: Why are certain Macros grouped in a single Module?
Excel Help Forum - Excel General: [SOLVED] Looking to calculate months
Office IT Pro General Discussions Forum: Power point tablet bug
Excel Help Forum - Excel Charting & Pivots: Multiple Criteria to Display on a Chart
Excel Help Forum - Excel Programming / VBA / Macros: Worksheet change event suddenly not working
Excel Help Forum - Excel General: Navigate between sheets without Page Down
Excel IT Pro Discussions Forum: Conditional formatting using named cell in Excel 2010
Greetings,
I want to use a named cell in my Conditional Formatting rule. Let's call it "red_target".
I want to be able to tell the rule, "If cell value is greater than red_target, turn red."
When I type "=red_target" or "red_target" in the Value: field, it thinks I literally mean the string "red_target."
When I use the picker to navigate to that specific cell, it doesn't fill in the name. It uses the R1C1 absolute reference.
Any ideas on using named cells in Conditional Formatting rules?
Thanks,
Rachel
Excel Help Forum - Excel Programming / VBA / Macros: Define range of formula in VBA based in first blank cell
Excel Help Forum - Excel General: If value is missing in any column, then cannot perform operation
Office IT Pro General Discussions Forum: Sharing your calendar with specific people
the client would like to share his calender with his secretary and also be able to hide certain meeting from her.
CAn you please she me how to do this in step by step form please(step1,step 2,step 3, etc.)
Excel Help Forum - Excel Programming / VBA / Macros: VBA transfer data from one workbook to another
Excel Help Forum - Excel General: Calculating the number of days which fall in financial year
Excel IT Pro Discussions Forum: Excel 2010 - complicated formulas
Hi
I have a spreadsheet I'm just about happy with, but I need to tweak a formula slightly and I need a bit of help with it. In the cells in column F, the user either types in the Book Band number or if the child has reached above level 30 they are now a Free Reader and they typre Feee Reader into a cell in column F. A Free Reader has the reading age of someone 11y, 6m+.
In column G the formula works out how far ahead, behind or whether they are on target. Here is the formula:
=IF(TRIM(E2)=TRIM(G2),"On target",IF(INT(M2)<>0,INT(M2) & "y, ","") & ROUND(MOD(M2,1)*12,0) & "m" & IF(K2>L2, " behind"," ahead"))
I would like to adjust that formula to show the text in column H of "Way ahead" if a child is a Free Reader (11y, 6m+).
I'd really appreciate your help.
Viv
Viv Haig
Excel Help Forum - Excel Programming / VBA / Macros: Weighted Random Number Generator Code Needed
Excel Help Forum - Excel General: How to copy a formula to multiple cells without filling blanks cells too..
Danh sách blog
1. Thông Tin Địa Điểm Trường Học Thuộc TpHCM
2. Tìm địa điểm ** Chính xác** Bản đồ,số ĐT,website
3. ATM Agribank, bản đồ, địa chỉ, đường đi
4. ATM Vietcombank, bản đồ, hướng dẫn đường đi đến Địa điểm
5. ATM Sacombank, bản đồ, hướng dẫn đường đi đến Địa điểm
6. ❤ ❤ Dịch vụ chọn lọc cho bạn ❤ ❤
7. Sửa lỗi
8. Đầm bầu
9. Top nice templates for you
10. Top answers for your issues - collect information from Google Search
11. Top Clips Vui Nhộn
12. AngularJS Tutorials
13. Lời bài hát