Replies

I knew it!! I knew there had to be a simple solution!! Gee, do I feel stupid!!

THANKS!!

By the way, I’ll have a look at the NameManager just the same. Perhaps it might come in handy as well.

Drew

In addition to the NameManager, to just get a list:

goto a blank section of a worksheet
Insert – name – paste
And a list of the names and their formulas will be created …

Steve

Hi Howard,

I have been using Linux off and on for several years. I think it was around 1995 or 1996 when I first tried it. I have maintained a Linux desktop for daily use now since 2005. Over the years I have tried all the main distributions including RedHat, Debian, Ubuntu (based on Debian), Mepis (based on Debian), SUSE, Mandriva (then it was Mandrake), Xandros, Gentoo, Knoppix, etc. etc. I had stuck with Kubutnu for some time (about a year or so) but recently tried switching back to Mepis (one of my favourites). If you wish to try it out for a while first, I’d suggest you download a live CD version of Mepis or Ubuntu and run those. Keep in mind that running a distro from a CD will be slow as the files are all compressed on the disc and need to be read and uncompressed first. Therefore, don’t judge the responsiveness based on a live CD. However, it will give you an idea of the functionality available.

You will require two partitions as a minimum. One for a Linux swap partition and another for the root partition. However, I highly recommend a third partition for /home. This allows you to overwrite the root partition with a new distro some day and not lose your home partition. Worked really well for me when switching from Kubuntu to Mepis.

Drew

Thanks again for the tips Hans!

I did try just copying the required OCX and DLL files from a Windows 2000 machine onto my Windows XP machine and all seems to be well. I will look at recoding the database in the long run to correct the need for the non-supported configuration.

Drew

Hans!

You’re my hero! You’ve come to the rescue several times. Thanks again!!!

Drew

Hans!

You’ve got to be kidding! That was it?!?!?! WOW! THANKS!!! I still have no idea why that would have suddenly become enabled, but removing the check boxes definitely fixed the problem!

Thanks again,

Drew

HI Nancy,

Glad it worked out for you. I’m sorry about that extra line of code in there for the size. That is a step that I had to perform manually each time. I use this macro for placing Excel charts into my reports which are in Word. I had the same issues you were having when placing a clipboard image in as an Enhanced Metafile. Since my charts are always 6.5″ wide, I included that extra line, which you obviously did not need.

Drew

HI Nancy,

Glad it worked out for you. I’m sorry about that extra line of code in there for the size. That is a step that I had to perform manually each time. I use this macro for placing Excel charts into my reports which are in Word. I had the same issues you were having when placing a clipboard image in as an Enhanced Metafile. Since my charts are always 6.5″ wide, I included that extra line, which you obviously did not need.

Drew

Edited by Phil Rabichow to reduce size of pretagged code to prevent scrolling
Hans,

Here’s what ended up working for me!!!

Sub PasteAsMetafile()
    Selection.PasteSpecial DataType:=wdPasteMetafilePicture, _
Placement:=wdInLine
   'Selection.PasteSpecial DataType:=wdPasteEnhancedMetafile, _
Placement:=wdInLine
    Selection.MoveLeft Unit:=wdCharacter, Count:=1, Extend:=wdExtend
    Selection.InlineShapes(1).LockAspectRatio = msoTrue
    Selection.InlineShapes(1).Width = InchesToPoints(6.5)
End Sub

Take note of the difference between the first line of code and the commented line below it. I simply tried using “MetafilePicture” instead of “EnhancedMetafile”. Now, even the last two lines of code work and the picture is sized correctly!!

Thanks for your help. Your exact code may not have worked right the first time, but it gave me something to work with. That was still a big help.

Drew

Edited by Phil Rabichow to reduce size of pretagged code to prevent scrolling
Hans,

Here’s what ended up working for me!!!

Sub PasteAsMetafile()
    Selection.PasteSpecial DataType:=wdPasteMetafilePicture, _
Placement:=wdInLine
   'Selection.PasteSpecial DataType:=wdPasteEnhancedMetafile, _
Placement:=wdInLine
    Selection.MoveLeft Unit:=wdCharacter, Count:=1, Extend:=wdExtend
    Selection.InlineShapes(1).LockAspectRatio = msoTrue
    Selection.InlineShapes(1).Width = InchesToPoints(6.5)
End Sub

Take note of the difference between the first line of code and the commented line below it. I simply tried using “MetafilePicture” instead of “EnhancedMetafile”. Now, even the last two lines of code work and the picture is sized correctly!!

Thanks for your help. Your exact code may not have worked right the first time, but it gave me something to work with. That was still a big help.

Drew

Edited by Phil Rabichow to make the screen with narrower & to make the link clickable – see Help #19
Hi Nancy,

I noticed that back in July you posted a request for Pasting Metafiles. I too just posted looking for the same answer. I found your letter and the resulting thread just after I posted. Anyway, I too received a reply from HansV and it didn’t work for me either. HOWEVER, the good news is, I did manage to find a fix for Hans’ code. Simply changing one option in the code he gave me, fixed the problem!! Check out my post 398600

For that matter, I may as well post it here too! Naturally, you needn’t include the commented line, but I left it in for reference so you can see what I changed. Hope this works for you.

Sub PasteAsMetafile()
  Selection.PasteSpecial DataType:=wdPasteMetafilePicture, _
Placement:=wdInLine
 'Selection.PasteSpecial DataType:=wdPasteEnhancedMetafile, _
Placement:=wdInLine
  Selection.MoveLeft Unit:=wdCharacter, Count:=1, Extend:=wdExtend
  Selection.InlineShapes(1).LockAspectRatio = msoTrue
  Selection.InlineShapes(1).Width = InchesToPoints(6.5)
End Sub

Drew

Edited by Phil Rabichow to make the screen with narrower & to make the link clickable – see Help #19
Hi Nancy,

I noticed that back in July you posted a request for Pasting Metafiles. I too just posted looking for the same answer. I found your letter and the resulting thread just after I posted. Anyway, I too received a reply from HansV and it didn’t work for me either. HOWEVER, the good news is, I did manage to find a fix for Hans’ code. Simply changing one option in the code he gave me, fixed the problem!! Check out my post 398600

For that matter, I may as well post it here too! Naturally, you needn’t include the commented line, but I left it in for reference so you can see what I changed. Hope this works for you.

Sub PasteAsMetafile()
  Selection.PasteSpecial DataType:=wdPasteMetafilePicture, _
Placement:=wdInLine
 'Selection.PasteSpecial DataType:=wdPasteEnhancedMetafile, _
Placement:=wdInLine
  Selection.MoveLeft Unit:=wdCharacter, Count:=1, Extend:=wdExtend
  Selection.InlineShapes(1).LockAspectRatio = msoTrue
  Selection.InlineShapes(1).Width = InchesToPoints(6.5)
End Sub

Drew

Hi Hans,

What’s really odd is that the wdPasteEnhancedMetafile method is in fact listed in Word 2000 as a viable option. However, when that method was used, the other options (re: wdInline, etc. ) did not have any effect.

Anyway, I got exactly what I was looking for now.

THANKS AGAIN!

Drew

Hi Hans,

What’s really odd is that the wdPasteEnhancedMetafile method is in fact listed in Word 2000 as a viable option. However, when that method was used, the other options (re: wdInline, etc. ) did not have any effect.

Anyway, I got exactly what I was looking for now.

THANKS AGAIN!

Drew

Hi Hans,

I get the following error:

Run-time error '5941':

The requested member of the selection does not exist.

What results is still a floating image. I even tried the other code you provided for another user in the same regard.

Any further insights?

Drew

Hi Hans,

I get the following error:

Run-time error '5941':

The requested member of the selection does not exist.

What results is still a floating image. I even tried the other code you provided for another user in the same regard.

Any further insights?

Drew