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
|
Similar Threads
