Ολοκληρωμένο

Excel to Word copying macro

Hi,

What I need is probably really simple but I can’t figure it out.

I have a bunch of tables in excel that I want to copy into word; with the appearance matching how it would look if I did the copy and paste manually.

Each table is on its own worksheet and is a named range (local name... name is same on each sheet), each sheet also contains a named cell (again... local name... same on each sheet) with the title of the table.

I want the macro to paste the tables into word with the table title separating them, captioned as a table in word.

Ie the macro would do the same as if I:

1) insert a caption with the ‘table’ label

2) the append with the title copied from the value of the title cell

3) copy and paste the named range from the worksheet

4) change the table property to be centrally aligned on the page

Rinse and repeat with the data from the next worksheet.

Ικανότητες: Excel, Visual Basic, Visual Basic για Εφαρμογές, Word

Περισσότερα: vba macro generate report excel word, excel word vba macro example, macro code generate report excel word, excel vba export to word document, copy data from excel to word using macro, excel vba copy range to word document, import data from excel into word automatically using vba, excel vba open word document and paste, excel vba open word document and copy, vba code to copy from excel and paste in word, macro to export data from excel to word, word forms macro excel access, vba excel word macro, macro across excel word, top form copying excel word, excel word macro examples, create excel word macro, excel word document macro, excel workbook word vba macro, macro excel word bookmark

Σχετικά με τον Εργοδότη:
( 2 αξιολογήσεις ) Manchester, United Kingdom

Ταυτότητα Εργασίας: #18122184

Ανατέθηκε στον:

beltran0404

Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. I can do your Excel to Word document according to your requirements. Please contact me by chat and then we could discuss f Περισσότερα

£20 GBP σε 1 μέρα
(114 Αξιολογήσεις)
5.4

10 freelancers κάνουν προσφορές κατά μέσο όρο £16 για αυτή τη δουλειά

Developer000

Feel fee to contact me for Excel to Word copying [login to view URL] me message to discuss further more details .We provide the commments,images,videos,demos and live sessions in order to help the [login to view URL] payment only Περισσότερα

£20 GBP σε 1 μέρα
(13 Αξιολογήσεις)
4.6
anisheco

Hi, I have 10+ years of experience in report/process automation using MS Excel with VBA. I read the job description and understand the requirements. We can create bookmarks in the word document, and create a control pa Περισσότερα

£20 GBP σε 1 μέρα
(3 Αξιολογήσεις)
3.3
georgieva8510

Hey, I'm interested in your project. Please send me a message so that we can discuss more. Thank you!

£18 GBP σε 1 μέρα
(1 Κριτική)
3.0
eternalvs

Hello, My middle name is "macro" :) I do this type of work all day everyday, and have done so for 10+ years. I am confident I can write a macro to copy your excel tables to word and format them as you have laid out Περισσότερα

£20 GBP σε 0 μέρες
(5 Αξιολογήσεις)
2.8
egafiori

My name is Esteban, I'm an industrial engineer and Excel/VBA Expert. I'm new freelance,You can see some of my experiences in my profile. I could also help in economic analysis and evaluations, based on regression Περισσότερα

£10 GBP σε 1 μέρα
(6 Αξιολογήσεις)
2.5
engrranakaleem21

Hello, I have already gone through the details from you. I think it is the best suited for me and you will have got an excellent feedback. I am available from now on. I ensure you i will provide you a better quality w Περισσότερα

£10 GBP σε 0 μέρες
(2 Αξιολογήσεις)
1.7
kapappu

Dear Hiring Manager, Wish you a very good day, sir. I’ve carefully gone through the every details of your post. According to your demand and my capabilities, I believe myself to be the most appropriate candidate for Περισσότερα

£10 GBP σε 1 μέρα
(0 Αξιολογήσεις)
0.0
wafaaalia

1day 18$

£18 GBP σε 1 μέρα
(0 Αξιολογήσεις)
0.0
Hardeeek

"Dear Next Employer We will give you the best result by uses my Past Experience and excellent academic skills on your project. You cam chat with me and let's get started, I Am ready to show you some samples of similar Περισσότερα

£10 GBP σε 1 μέρα
(0 Αξιολογήσεις)
0.0