Hi,
I'll answer your second question first:
Add this line of code
before this line of code
This will fix the display issue. The problem is that Excel thinks you are feeding the cell a number, so it formats the number in scientific format, which loses all information after so many digits. Then when you format the cell to display the number properly, it doesn't know what the final digits actually were, so it displays them as zeros.
As for your first question:
With the way that your code is setup, the only way to fill the result to another workbook is to have that workbook open in the background. Then when the prompt comes up asking where to place the result, switch to that workbook and select the cell.
Hope this helps
Bookmarks