When using copy/paste special to take a range from Excel 2002 to Powerpoint 2002 all is fine on my PCs - i.e. all formats are kept as expected. However, my client has 2 of his own machines and 2 of his clients that lose the font colour only - all text is black (background colours etc are fine). Colour is retained in HTML and Bitmap formats but not Metafile or Enahnced Metafile. Anyone else had this problem? If so, any solutions please.
Font colours disappear when pasting to Powerpoint as Metafile/Enhanced metafile
1 posts
• Page 1 of 1
- MS OFFICE OUTLOOK
- MS Office Access
- informix
- Exchange 2000
- Mathematica
- php
- c++
- cobol
- MS EXCEL
- xml
Jump to:
- 1. Run-time error '6' Overflow
The following code is giving me the Run-time error '6' Overflow, and specifically at the code "ans = var1 * var2". And I don't understand why, when stepping through this code, it keeps jumping in and out of the procedure. I obviously don't know what I'm doing. FYI, cells D3 and F3 have the following code in them: =RANDBETWEEN (1,9) I hope someone can explain... Private Sub Worksheet_Change(ByVal Target As Range) Dim var1, var2, ans, tgt If Target.Column = 8 Then tgt = Target.Value var1 = Range("D3").Value var2 = Range("F3").Value ans = var1 * var2 Range("D4").Value = var1 Range("F4").Value = var2 Range("H4").Value = tgt If tgt = var1 * var2 Then Range("I4").Value = "Correct" Else Range("I4").Value = "Wrong" End If End If Calculate End Sub - 2. Incorrect formula
Would appreciate help with my formula. I only want the 1 to be added to L28 and L29 if they have a value greater than 0. this formula produces 2 even if all the cells have nothing in them, but I need there to be nothing in the cell if no values are in any cells. If the value of every cell in the formula was 1 then my answer should be 14 but if cell L28 is 0 then the answer should be 12, and if neither L28 or L29 has a value then the answer should be 10, but because of the =1 in my formula I get an answer that is 12.(or 2 greater than I want if values are in other cells) Help appreciated. =((L24+L25)*3)+(L26+L27)+(L36*2)+(L28+1)+(L29+1) - 3. Using Subtotals
I have a spreadsheet (table) that I plan to use sub-totals. Is it possible to have a calculated column to the right of the table on each subtotal row (e.g. Column B:99 / Column A:99)? What if a data refresh adds a new grouping? - 4. Building a summary page
Example: Vendor Sales Cost Sheet1: Walk-in sales abc 1.00 .50 def 1.00 .50 ghi 1.00 .50 Sheet2: Drive-thru sales abc 1.00 .50 ggg 1.00 .75 ghi 1.00 .50 Sheet3: Mailorder sales ggg 1.00 .45 klm 2.00 .80 frt 1.00 .90 How can I build a summary page as follows: Total Sales: abc 2.00 1.00 def 1.00 .50 ghi 2.00 1.00 ggg 2.00 1.20 klm 2.00 .80 frt 1.00 .90 - 5. Excel 2007, unknown name appears on Move or Copy...
I have always used Excel 97 to track and record my investments. Recently I started using Excel 2007 with my old Excel worksheets. What I do is use Move or Copy... to copy the previous day's worksheet for the current day, so I can update my positions and prices. Now when I do this with Excel 2007, I always get this message: "A formula or sheet you want to move or copy contains the name 'Print_Area_MI', which already exists on the destination worksheet. Do you want to use this version of the name?" I have no idea what that's about since I have never used any such name on anything. I just click Yes and that takes care of it, but is there some way I can stop this pesky message from reappearing every time I do this?
Next
Font colours disappear when pasting to Powerpoint as Metafile/Enhanced metafile
by Dean Painter » Thu, 08 Apr 2004 20:35:55 GMT
Similar Threads:
1.Font colours disappear when pasting to Powerpoint as Metafile/Enhanced metafile
When using copy/paste special to take a range from Excel 2002 to Powerpoint 2002 all is fine on my PCs - i.e. all formats are kept as expected. However, my client has 2 of his own machines and 2 of his clients that lose the font colour only - all text is black (background colours etc are fine). Colour is retained in HTML and Bitmap formats but not Metafile or Enahnced Metafile. Anyone else had this problem? If so, any solutions please.
2.windows metafile vs enhanced metafile
3.Is there code for Paste Enhanced Metafile?
I have tried and failed to record a macro that performs the function of Edit/Paste Special/Enhanced Metafile picture. My recorded macros come up as empty 'subs'. Can I get around this limitation with VBA code? I can't seem to...help. Thanks. Same question as another guy, but I do have 2003
4.Pasting Excel Charts as Enhanced Metafiles
Since upgrading to Office 2003, I am unable to successfully paste Graphs made in Excel as enhanced metafiles into my office's Microsoft Word report template. When I paste special, as an enhanced metafile, I am only able to see the very bottom piece of the graph. I can move the graph around and resize it, but it will not show up on screen. Nor does it show up in print preview. BUT it comes out just fine when I print a hard copy. This issue is unique to our report template, as I can paste Excel graphs into a blank Word document with no trouble. But it is also unique to Excel, as I can successfully paste graphs made in Power Point into our report template. I've tried re-creating the template in 2003 but that did not help. I've also tried every combination of Office 2000 and 2003 pastes (i.e. graphs made in Excel 2003 into the 2000 template, graphs made in Excel 2000 into the 2003 template, etc). Nothing seems to work. Has anyone seen this problem before? Any suggestions on how to get aorund it?
5.Excel 2007 line-chart pasted as an enhanced metafile - editing
To tailor all our charts we past/special/metafile line charts into Powerpoint, then ungroup twice to be able to move/chop/change elements of the chart. When I ungroup the second time the line (representing data) actually breaks into a huge number of invidual lines (according to the underlying source data), as opposed to one single line. As a result, things are much more tedious/complicated. Any way to ungroup a chart in Powerpoint and have the line stay as a line, and not a ton of individual lines? -- Ben
6. Pasting from xl into word as an enhanced metafile
1 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 99 guest