$$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

2013-03-04 Thread Paul Schreiner
I may regret asking this, but here goes: Using Office 2010: I have Excel templates that are used to create documents and store the data in an Oracle database. The Oracle database has data from "released" and "archived" or "historical" documents. These documents are saved as PDF's and stored

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

2013-03-04 Thread Sam Mathai Chacko
This has most of it http://www.excelfox.com/forum/f13/execute-sql-excel-vba-66/ Regards, Sam On Mon, Mar 4, 2013 at 11:50 PM, Paul Schreiner wrote: > I may regret asking this, but here goes: > > Using Office 2010: > > I have Excel templates that are used to create documents and store the > dat

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

2013-03-04 Thread David Grugeon
Hi Paul Helen Feddema's book Access : Working with excel covers all this and much more. If you want it for $10 instead of $17 you have to subscribe for the free newsletter Access Watch. http://shop.office-watch.com/awe/fasttrack.aspx On Tuesday, 5 March 2013, Paul Schreiner wrote: > I may regre

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

2013-03-07 Thread Paul Schreiner
the people you can, As long as ever you can.” - John Wesley - From: David Grugeon To: "excel-macros@googlegroups.com" Sent: Mon, March 4, 2013 4:11:32 PM Subject: Re: $$Excel-Macros$$ Excel VBA to retrieve from M

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

2013-03-07 Thread Prince
; > excel-...@googlegroups.com > > *Sent:* Mon, March 4, 2013 4:11:32 PM > *Subject:* Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or > Sharepoint > > Hi Paul > > Helen Feddema's book Access : Working with excel covers all this and much > more. If you w

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

2013-03-08 Thread Paul Schreiner
r you can.” - John Wesley - From: Prince To: excel-macros@googlegroups.com Sent: Fri, March 8, 2013 12:00:35 AM Subject: Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint Hi Paul, I think the solutions given by Sam and Me are corr