Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Macro/Automatic script that scans for certain values.

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Macro/Automatic script that scans for certain values.
I'm not exactly experienced in Excel or VB so this one is slightly challenging for me and I can't find a way to easily execute this either through a macro or automatically. I have a time sheet for employees, we manage four venues in the same building, what we need to happen is we fill out a time...

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...

Excel Help Forum - Excel Charting & Pivots: How to Plot Data Labels on a Chart with a text value instead of a numeric value

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
How to Plot Data Labels on a Chart with a text value instead of a numeric value
So I've been having this trouble with a chart in Excel for months and just haven't been able to figure it out. It involves a chart that has labels that are supposed to show as change1, change2, change3, ect. plotted along a chart with a date range. If I change the date range to anything but...

Excel Help Forum - Excel Programming / VBA / Macros: Moving an entire row to new worksheet based on variable cell value.

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Moving an entire row to new worksheet based on variable cell value.
So hooray for my first post! Now on to the serious business... I have read many posts relating to this for moving an entire row based on text of one cell, but only for one word. I am havin no luck finding the script to move it to a different sheet based on different words (in the same cell). ...

Excel Help Forum - Excel General: Hide duplicate information

Feed2Mail notification - new post on Excel Help Forum - Excel General
Hide duplicate information
Hello, I have a spreadsheet with two tabs. One tab is a sheet of employee names and addresses, the other tab is a list of employee names. I want to compare list and only show what is different and hide the duplicates. I have tried with the advanced setting under filters but it hides the...

Excel Help Forum - Excel Charting & Pivots: How to Plot a Bar Chart with FY and Quarters displaying on the Horizontal Axi...

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
How to Plot a Bar Chart with FY and Quarters displaying on the Horizontal Axis in 2007
I am using Excel 2007. I have a stacked bar chart that I am using for a timeline for a project at work. The x-axis is the dates and the y-axis is the various tasks of the project. I want to use bar chart to show the time each company believes a milestone event will happen so I want the horizontal...

Excel Help Forum - Excel Programming / VBA / Macros: Why are certain Macros grouped in a single Module?

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Why are certain Macros grouped in a single Module?
When I select the "View Macros" option in Macros and select one to view, it gives me the option to scroll up and down and view several other macros. Usually about 3 or 4 of them will be in the same module. What I don't understand is how it decides which macros are in a given module. I simply...

Excel Help Forum - Excel General: [SOLVED] Looking to calculate months

Feed2Mail notification - new post on Excel Help Forum - Excel General
[SOLVED] Looking to calculate months
Hello, I have a simple spreadsheet that will calculate rental payments based on any given month for 1 month. I'm looking for help that will calculate based on 2 or more payments. I'm using this to calculate 1 month - =IF(C2="","",(DATE(YEAR(C2),MONTH(C2)+1,0))) C2 would equal the 1st day of...

Office IT Pro General Discussions Forum: Power point tablet bug

Feed2Mail notification - new post on Office IT Pro General Discussions Forum
Power point tablet bug
When I use the pen in a powerpoint presentation it freezes up.

Excel Help Forum - Excel Charting & Pivots: Multiple Criteria to Display on a Chart

Feed2Mail notification - new post on Excel Help Forum - Excel Charting & Pivots
Multiple Criteria to Display on a Chart
Hello I currently want to display multiple people's stats on a single chart. Although, I would like it so that when i were to click on a single name it showed just that person's stats, but when selecting multiple names it would show their individuals stats on the same chart. I can therefore...

Excel Help Forum - Excel Programming / VBA / Macros: Worksheet change event suddenly not working

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Worksheet change event suddenly not working
Hi there I am stumped. I had this code that was working fine up to last night when I tried to change parts of it to make if more effecient. However I couldn't make that part work, so changed the code back the what it was originally (recopied from an earlier version I'd saved) but now it will...

Excel Help Forum - Excel General: Navigate between sheets without Page Down

Feed2Mail notification - new post on Excel Help Forum - Excel General
Navigate between sheets without Page Down
I'm running Microsoft Excel for Mac 2011 on my Macbook Air and every resource I've searched mentions the Control+PAGEUP/DOWN keyboard shortcut to navigate between sheets. As there is no Page Up/Down keys on the Air's keyboard, I was wondering if there was any way to change the keyboard shortcuts in...

Excel IT Pro Discussions Forum: Conditional formatting using named cell in Excel 2010

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

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Define range of formula in VBA based in first blank cell
Hello everybody, I'm not an expert in VBA, and I need help for the following problem: I have a column with a lot of values that must be summed. The number of filled rows for this column will vary. There is a blank row on the top of the column. So far I have this: Code:

Excel Help Forum - Excel General: If value is missing in any column, then cannot perform operation

Feed2Mail notification - new post on Excel Help Forum - Excel General
If value is missing in any column, then cannot perform operation
Hi, i need some help in figuring out this formula: in cell H3 i have: =SI(D3="","",D3-(E3+G3+C3)) but i want to see if there is missing value in C3 and/or D3 then the formula will output "Missing Value" instead of perfroming the operation. I have attached the excell sheet. Please help ,...

Office IT Pro General Discussions Forum: Sharing your calendar with specific people

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

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
VBA transfer data from one workbook to another
how would i go about transferring data from one workbook to another? the starting data is in: workbook: "VEF LOGBOOKm working.xlsm" worksheet: "Finished" cell: b1 I need it to go to the first unused cell in column a in: workbook: "VEF SUMMARYm.xlsm"

Excel Help Forum - Excel General: Calculating the number of days which fall in financial year

Feed2Mail notification - new post on Excel Help Forum - Excel General
Calculating the number of days which fall in financial year
Hi All, Anyone know how I could split the number of days beween two dates by financial year? ie From To Amount Number of days which fall in 2011/12 financial year Number of days which fall in 2013/14 financial year invoice...

Excel IT Pro Discussions Forum: Excel 2010 - complicated formulas

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

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Weighted Random Number Generator Code Needed
Hello, I am running an excel based Jeopardy game and need a way to randomly choose three winners based on their number of entries gained throughout the game. I need a code which is able to take in columns of information (example below) and randomly pick three student numbers, taking into...

Excel Help Forum - Excel General: How to copy a formula to multiple cells without filling blanks cells too..

Feed2Mail notification - new post on Excel Help Forum - Excel General
How to copy a formula to multiple cells without filling blanks cells too..
Hi, I'm attempting to use a concatenate formula on a list of keywords, however some of the keywords are blank. Is there any way I can get my concatenate keyword to not appear in these fields. I'm attempting to insert a '+' symbol before every keyword but I have 8000+ keywords. E.G. ...