Link to home
Start Free TrialLog in
Avatar of sullisnyc44
sullisnyc44Flag for United States of America

asked on

excel as a template, data from a field

I would like to use an excel spreadsheet Purchase Order template. Add it as a custom type to a doc library.

I would like to assign the PO a number once it's approved. Most likely with an SPD Workflow.

This is my main problem - I would like this number to show up on the excel document as well. How can I accomplish this?

SOLUTION
Avatar of Amick
Amick
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sullisnyc44

ASKER

thanks for the link. Is what I want to do feasible?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
EDIT:
The book that is referenced is Excel Models for Business and Operations Management By John F. Barlow. Among other things, it discusses a purchase order system. The author provides quite a bit of detail,  and the book is highly reviewed, so it might be worth trying to find a copy of the book for reference.
thanks so much. this looks lind of awesome.

So the OLE would link to my SharePoint 'unique number list' ? or whatever I call it. Is that the correct way to think about this?

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks. But I'm still not sure how to include the specific PO number to my Excel form. How do I make THAT connection?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
will this work with MOSS 2007?
It should be substantially the same.
Im still unsure of how to get the SharePoint list item associated with the specific spreadsheet into the specific excel spreadsheet.

found this:
http://www.mindsharpblogs.com/penny/archive/2007/06/15/1888.html

and this:
http://www.johnchapman.name/sharepoint-2007-%e2%80%93-update-sharepoint-document-property-from-excel-vba/

http://msdn.microsoft.com/en-us/library/bb462636(office.11).aspx

but am having issues...
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The issue is that I need to create a Purchase Order form. I guess I can use infopath but we were going for the simplest option here.

And I installed that  plug in for excel that 'fixes' the sync issue.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
as long as I can figure out how to deploy it, this works