Hi Folks,
I am trying to use a VBA macro (for Office 2003) to do the following:
- In Excel, the user will select a range of cells
- In Word the user will call the macro (via a button or shortcut) to insert the selected Excel range as an embedded object
The code is not the problem so far, my problems are:
- Given that the user is working in a Word document, most likely will use the same fonts in Excel
- When Excel range was inserted in Word and they both use the same font names and sizes, they look different inside Word ( fonts look as if they stretched a bit)
- Styling Cell borders in Excel is not like styling cell borders in Word
I do appreciate any advice on this regards