Forum Discussion

jmant37's avatar
jmant37
Copper Contributor
May 25, 2020

VBA - opening an MS Word document from Excel, with all formatting from Excel.

I have a sheet range (A1:I18) that is formatted the way I want with picture, different row and column widths, cell highlighting, cell borders, different font sizes etc. I'd like assign macro to a button that then sends the user to MS Word, opening up the Excel cells as converted in an MS Word file. Any help to do this would be fantastic!

 

I'm very, very green to VBA and have no idea even how to record macros etc. 

No RepliesBe the first to reply

Resources