Topic: Work related: Custom MS Office templates pulling in data

Offline benlav

  • Addicted
  • benlav might someday be someone...benlav might someday be someone...benlav might someday be someone...benlav might someday be someone...
  • Posts: 4,166
Hey team,

I now work for a small boutique investment advisory firm and have been streamlining a bunch of processes. Something I have done is creating a tonne of macros for excel, now I am turning my attention towards word.

Does anyone know of a decent website where I can learn about creating a skeleton template which can pull data from other word docs. For example, every month we write up a market commentary, which would then feed through to the master template on call, right now it is all copy and paste.

Having a quick look, it looks like an XML structure would be the way to go? I have basic knowledge in coding, enough to get me through and I can learn (and find) what I need. Plus I don't get too complex.

If anyone knows of a good system, please let me know!

Ben

Posted: February 16, 2015, 10:40:32 am

Offline Xsannz

  • Addicted
  • Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!
  • Posts: 5,412
Hey team,

I now work for a small boutique investment advisory firm and have been streamlining a bunch of processes.

so you've been templating new grammatically correct email templates for your nigerian scam company?

Reply #1 Posted: February 16, 2015, 01:23:04 pm

Offline Xsannz

  • Addicted
  • Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!
  • Posts: 5,412
Hey team,

I now work for a small boutique investment advisory firm and have been streamlining a bunch of processes. Something I have done is creating a tonne of macros for excel, now I am turning my attention towards word.

Does anyone know of a decent website where I can learn about creating a skeleton template which can pull data from other word docs. For example, every month we write up a market commentary, which would then feed through to the master template on call, right now it is all copy and paste.

Having a quick look, it looks like an XML structure would be the way to go? I have basic knowledge in coding, enough to get me through and I can learn (and find) what I need. Plus I don't get too complex.

If anyone knows of a good system, please let me know!

Ben


VBA will be your friend.

a much easier option is to create the template as bad as it sounds in excel format it ike a word document etc etc and have that link out to the relevent data sources and pull them in its how we used to template automated reports.

Google  http://bit.ly/1Cydq6l and http://bit.ly/1CydSSm

they seem complex best way is probably the way we did it and excel and use the documents you want to pull from as data sources
Last Edit: February 16, 2015, 01:28:02 pm by Xsannz

Reply #2 Posted: February 16, 2015, 01:24:15 pm

Offline Xsannz

  • Addicted
  • Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!
  • Posts: 5,412
or write a macro that goes opens a named template and then copies it to your template.....

if you have sample files i might be able to knock something up for you or at least do all the havy code and then just leave comments and variablesstuff for you to fill in.

Reply #3 Posted: February 16, 2015, 01:29:04 pm

Offline benlav

  • Addicted
  • benlav might someday be someone...benlav might someday be someone...benlav might someday be someone...benlav might someday be someone...
  • Posts: 4,166
or write a macro that goes opens a named template and then copies it to your template.....

if you have sample files i might be able to knock something up for you or at least do all the havy code and then just leave comments and variablesstuff for you to fill in.

cheers, looking into those now. I know how to do a VBA in excel about copy and pasting, might have to learn how to do it regarding word docs.

Reply #4 Posted: February 16, 2015, 01:47:03 pm

Offline Xsannz

  • Addicted
  • Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!
  • Posts: 5,412
or write a macro that goes opens a named template and then copies it to your template.....

if you have sample files i might be able to knock something up for you or at least do all the havy code and then just leave comments and variablesstuff for you to fill in.

cheers, looking into those now. I know how to do a VBA in excel about copy and pasting, might have to learn how to do it regarding word docs.

I have some sample stuff you can have now if i can find it it was a report that grabbed sharepoint, SQL DB, and Word files opened them copied information and stats accross then graphed and compiled all sorts of things including emails and pdf files and sent them out, its a nice condensed way of every VBA hack i know of..

the pdf printer one is the worst as you have to inject into the registry at run time where the pdf printer grabs its file names from ;)

also i advocate anything you produce the final output being PDF its alot harder to manipulate what you said or didn't say or put in a file with PDF than word..

Reply #5 Posted: February 16, 2015, 02:02:08 pm

Offline benlav

  • Addicted
  • benlav might someday be someone...benlav might someday be someone...benlav might someday be someone...benlav might someday be someone...
  • Posts: 4,166
I might take you up on that offer, however my new nigerian based, err, my new company has the IT policy to get around. I will actually need it to generate in word format, as I am not producing reports, but financial plans that they will need to be able to change.

Reply #6 Posted: February 16, 2015, 02:21:11 pm

Offline Xsannz

  • Addicted
  • Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!
  • Posts: 5,412
I might take you up on that offer, however my new nigerian based, err, my new company has the IT policy to get around. I will actually need it to generate in word format, as I am not producing reports, but financial plans that they will need to be able to change.

fair enough the nice thing about VBA is you can get around it policy... 

i found a nice trick that enabled macros even if you had it disabled at domain level :P

Reply #7 Posted: February 16, 2015, 02:24:18 pm

Offline benlav

  • Addicted
  • benlav might someday be someone...benlav might someday be someone...benlav might someday be someone...benlav might someday be someone...
  • Posts: 4,166
I might take you up on that offer, however my new nigerian based, err, my new company has the IT policy to get around. I will actually need it to generate in word format, as I am not producing reports, but financial plans that they will need to be able to change.

fair enough the nice thing about VBA is you can get around it policy... 

i found a nice trick that enabled macros even if you had it disabled at domain level :P

The IT policy here blanket refuses the ability to load in trusted locations in office...

Reply #8 Posted: February 16, 2015, 02:54:09 pm

Offline Xsannz

  • Addicted
  • Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!
  • Posts: 5,412
sucks i hate narrow mindedness of the IT guys sometimes

Reply #9 Posted: February 17, 2015, 08:52:13 am

Offline Apostrophe Spacemonkey

  • Fuck this title in particular.

  • Apostrophe Spacemonkey is awe-inspiring!Apostrophe Spacemonkey is awe-inspiring!Apostrophe Spacemonkey is awe-inspiring!Apostrophe Spacemonkey is awe-inspiring!Apostrophe Spacemonkey is awe-inspiring!Apostrophe Spacemonkey is awe-inspiring!Apostrophe Spacemonkey is awe-inspiring!Apostrophe Spacemonkey is awe-inspiring!Apostrophe Spacemonkey is awe-inspiring!Apostrophe Spacemonkey is awe-inspiring!Apostrophe Spacemonkey is awe-inspiring!Apostrophe Spacemonkey is awe-inspiring!
  • Posts: 19,050
sucks i hate narrow mindedness of the IT guys sometimes

No, Xsannz. You are the IT guys.

Reply #10 Posted: February 17, 2015, 09:03:27 am

Offline Xsannz

  • Addicted
  • Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!
  • Posts: 5,412
sucks i hate narrow mindedness of the IT guys sometimes

No, Xsannz. You are the IT guys.

I used to be :)  i hated the fact that the bosses who wanted rules didn't think about the end users and edge cases with no flexibility.

Reply #11 Posted: February 17, 2015, 09:58:42 am

Offline Lias

  • Administrator
  • Lias is awe-inspiring!Lias is awe-inspiring!Lias is awe-inspiring!Lias is awe-inspiring!Lias is awe-inspiring!Lias is awe-inspiring!Lias is awe-inspiring!Lias is awe-inspiring!Lias is awe-inspiring!Lias is awe-inspiring!Lias is awe-inspiring!Lias is awe-inspiring!
  • Posts: 3,973
Be glad you have what you have.

Things some of us would like to implement at work but can't due to lack of resources and resistance from the business.
All network ports kept physically disconnected without a valid work order and change control to liven them.
All network ports having port security with static (not sticky) MAC filtering.
All PC's to be secured in tamperproof housings preventing access to back of PC, and front USB disabled.
Whitelist for only approved USB devices as an additional safeguard.
Applocker/Application whitelisting
Internet access only to a whitelist of approved sites.
Bitlocker on all drives including the aforementioned whitelisted USB devices.

You get the idea :-P

Reply #12 Posted: February 17, 2015, 01:03:07 pm

Offline Xsannz

  • Addicted
  • Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!Xsannz is awe-inspiring!
  • Posts: 5,412
Be glad you have what you have.

Things some of us would like to implement at work but can't due to lack of resources and resistance from the business.
All network ports kept physically disconnected without a valid work order and change control to liven them.
All network ports having port security with static (not sticky) MAC filtering.
All PC's to be secured in tamperproof housings preventing access to back of PC, and front USB disabled.
Whitelist for only approved USB devices as an additional safeguard.
Applocker/Application whitelisting
Internet access only to a whitelist of approved sites.
Bitlocker on all drives including the aforementioned whitelisted USB devices.

You get the idea :-P

These are the sort of narrow minded rules that makes stuff dirty diapers in car air vents and piss on door handles.

Reply #13 Posted: February 17, 2015, 02:44:18 pm