Sharing documents?

[Mike2502]

Hi,

I have made a mailmerge with excel and word on my local drive however as I have to roll this out for 8 people in my team I have a few questions I'm hoping to get some expert answers for

- if I copied all the files from my local and put it onto a shared drive and if they copied, would this work on their local drive (will change file paths within the code)

- will my word documents be linked with the excel file once I have copied this over to my team members personal drive?

- what's the best method to get these across to the team?

Thanks all

 

[mumps]

Are you running the code from Word or from Excel? Have you created a merge document in Word which contains all the merge fields?

 

[Mike2502]

Are you running the code from Word or from Excel? Have you created a merge document in Word which contains all the merge fields?

Hi Mumps,

I have macros in word and vba in the excel files, I've done the merge fields and everything is running perfectly... At the moment the codings file path is 'myuser/folder/projects/etc...'

All I have to do is change myuser to the team members computer username but I just wanted to know what's the best way to transfer the files across to the team members where it will include the macros and VBA?

 

[mumps]

I think that emailing the files as attachments should work. They could then simply save them to the desired folder.

 

[Mike2502]

I think that emailing the files as attachments should work. They could then simply save them to the desired folder.

Hi I have just tried this however excel VBA comes over but the word macros doesn't?

Is there any way around this?

Cheers

 

[mumps]

If the macros are in a Normal module, insert a regular module and copy the macros there. Then save the file. See if this works for you.

 

[Mike2502]

If the macros are in a Normal module, insert a regular module and copy the macros there. Then save the file. See if this works for you.

Hi,

It is in a regular module (I think), I don't see it below the normal module

Doesn't work unfortunately

Thanks

 

[MARK858]

It is in a regular module (I think)

The module should look something like the bit in blue below in the Project window.

 

[Mike2502]

The module should look something like the bit in blue below in the Project window.
View attachment 20905

Hi Mark,

I've got it on Project and it isn't copying over when I send the word documents via email.

Is there any alternative

 

[MARK858]

No alternative but no reason why it shouldn't "stick" as long as it is a .Docm and not a .Docx.