Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bitmap PasteSpecial to Word Application
Dear All,
I am having a very strange and odd problem with Excel and Word. If you could kindly propose any solution ideas, I shall appreciate it very much. I have a reporting VBA application on the Excel. Smoothly produces all the reports. I have to put the reports in a Word application. The reports are not fixed row and column sizes. I have to generate a Bitmap image of the Excel report and tried to Paste it in the Word Application. Very strangely, on the very first runs no problems. It worked, I had the reports Bitmap pics on Word beatifully as I wanted but then later something happened, may be the ghost in the machine. Excel VBA is copying the range and sending it to the Word application but, the pasted bitmap is a blank object, sadly, very sadly nothing inside. In order to complete my reports on time, I tried a backdoor tactic and created a Word macro doing the PasteSpecial Datatype:=wdPasteBitmap and assigned it to a keyboard shortcut macro. Bingo! It worked. However it is taking so long to complete a full set of report with approx. 200 x 30 Cntrl-Qs and shifting between the applications is awfully open to error. I have tried another backdoor route because I were running short on time, I tried the Sendkeys method but unfortunately, the same ghost in the same machine, very first few runs it worked, then generated empty objects. I cleaned the Clipboard if incase there is a memory related problem. No progess. I tried to pause the code before and after the PasteSpecial steps. No progess. Then I wondered if the Excel Bitmap function is not working properly so I tried a code to generate my own bitmap pictures, which worked fine, but the same ghost in the same machine, blank pages were there after the second or third runs so sadly and so misfortunately. I tried the 2007 and 2003 vers. of Excel but sadly, very same. I am working on a licenced XP Pro and licenced Office Pro Pentium 4 with 4GbRAM and lots of disk space. If you may need to see the code, I shall send the code as well. If some Guru could help fiding the ghost in the machine, I shall be more then gratefull. Regards, VBANovice trying to find the Ghost in the Machine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does Selection.PasteSpecial toggle Application.ScreenUpdating | Excel Worksheet Functions | |||
Bitmap Pasting to a Word Application | Excel Programming | |||
Copy from Excel and paste as bitmap in Word | Excel Programming | |||
Across application pastespecial | Excel Programming | |||
Making VB PasteSpecial method to work the same as Excels Application | Excel Programming |