Pages

Search

Excel Help Forum - Excel General: Extracting Descriptions from one spreadsheet to appropriate part numbers on t...

Feed2Mail notification - new post on Excel Help Forum - Excel General
Extracting Descriptions from one spreadsheet to appropriate part numbers on the other
I have attached two spreadsheets. The first spreadsheet has long descriptions and vehicle applications with the part numbers to the left. The 2nd spreadsheet is where I want the long descriptions to go under the "description" column. I want to accomplish this without altering any of the other...

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 ?

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)

VBA: Save as PDF macro

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?

How do I show the tabs bar?

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?

problem with even pages

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.
I opened my office files in the computer normally.
However, when I open office file attachments in your mail client (I use Incredimail premium), then the error message:

"Microsoft office can not verity the license for this product. Try repair the office program by using control panel"
I implementation repaird; reinstall but still did not fix the error.

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.
To edit this object, you must install a program that can open the object.
".

 

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.
To edit this object, you must install a program that can open the object." error message immediately.

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

Excel Help Forum - Excel Programming / VBA / Macros: Problem with formula

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Problem with formula
There is a problem with the formula in column B in the attached spreadsheet. It counts some different values in Column A as the same. Column D shows how the results should be displayed. For some reason it starts out finding the highest value 1/6 (100) but then for 2/6 finds it two different...

Excel Help Forum - Excel General: How to Share Workbooks between Multiple Users?!?

Feed2Mail notification - new post on Excel Help Forum - Excel General
How to Share Workbooks between Multiple Users?!?
I feel like I'm so close, but I'm missing something important Here's what I've done: 1. Clicked the 'Share Workbook' button on the Review tab 2. Checked the box that says 'Allow changes changes by more than one user at the same time' 3. Selected the settings I want ...now what... If I...

Excel IT Pro Discussions Forum: Excel 2010, Data Validation List, wrong order.

Feed2Mail notification - new post on 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

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Help Requested in Creating Hyperlink VBA
I posted this originally in the Excel General, but I believe it should be posted here... Hi. I am using MS Excel 2007, and I have very basic knowledge on how to use visual basic . I need help with a macro, and I believe this is the best place to ask for help. I have column "A" a list of my...

Excel Help Forum - Excel General: Need help with function and date sorting

Feed2Mail notification - new post on Excel Help Forum - Excel General
Need help with function and date sorting
I am tryign to run the following statement in excel: =IF(O42="AB",VLOOKUP(WIPCOEI2012!O42,WIPCOEI2012!$O$51:$R$52,3,FALSE),IF(O42="AT",VLOOKUP(WIPCOEI2012!O43,WIPCOEI2012!$O$51:$R$52,3,FALSE))) When I cut and paste this row of cells, one of which has the above statement, the "O42" reference...