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

%3CLINGO-SUB%20id%3D%22lingo-sub-1415262%22%20slang%3D%22en-US%22%3EVBA%20-%20opening%20an%20MS%20Word%20document%20from%20Excel%2C%20with%20all%20formatting%20from%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1415262%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sheet%20range%20(A1%3AI18)%20that%20is%20formatted%20the%20way%20I%20want%20with%20picture%2C%20different%20row%20and%20column%20widths%2C%20cell%20highlighting%2C%20cell%20borders%2C%20different%20font%20sizes%20etc.%20I'd%20like%20assign%20macro%20to%20a%20button%20that%20then%20sends%20the%20user%20to%20MS%20Word%2C%20opening%20up%20the%20Excel%20cells%20as%20converted%20in%20an%20MS%20Word%20file.%20Any%20help%20to%20do%20this%20would%20be%20fantastic!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20very%2C%20very%20green%20to%20VBA%20and%20have%20no%20idea%20even%20how%20to%20record%20macros%20etc.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1415262%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

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. 

0 Replies