ASP Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me

The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.

Go Back   Dev Shed ForumsProgramming Languages - MoreASP Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old March 15th, 2003, 07:01 PM
forefront forefront is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2000
Posts: 166 forefront User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 18 m 58 sec
Reputation Power: 13
Question Excel programming challenge

Is there a way to accomplish this?

Formulae exist in an Excel spreadsheet, linked to a Word document (a standard letter that extracts the results from the Excel cells). We want user online to fill in a web-based form, these data to be processed according to formulae in Excel sheet and then a standard document (Word or similarly formatted) is emailed to the person containing just the results from the Excel cells. At no point will the person have access to original Excel or Word files.

The Excel and Word documents will change frequently.

It is desirable if there is a way to simply upload the Excel and Word docs and the online form and all other aspects of the system will change automatically to reflect these changes.

1. Person fills in form
2. Server processes data from that form and generated answers 3. Person is emailed a standard document with the answers in place

Reply With Quote
  #2  
Old March 17th, 2003, 05:05 AM
Spudhead Spudhead is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2003
Posts: 151 Spudhead User rank is Corporal (100 - 500 Reputation Level)Spudhead User rank is Corporal (100 - 500 Reputation Level)Spudhead User rank is Corporal (100 - 500 Reputation Level)Spudhead User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 20 h 10 m 58 sec
Reputation Power: 12
I think you're going to have problems that way. I'm not familiar with how Excel updates Word and other documents, but I should imagine that any changes are only going to show up when you open the Word file; not when you attach it as an email.

The way I'd do it is to have your formulas etc as a seperate include file for ease of updating, and use some sort of 3rd party compnent to generate documents (Word, PDF etc) on the fly. There are a number of these about, I believe you can get free ones, and most will allow you to open an existing template document and add the data that your form / ASP processing has produced. You can then send the document off in the usual manner.

Any help?

Reply With Quote
  #3  
Old March 17th, 2003, 10:58 AM
forefront forefront is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2000
Posts: 166 forefront User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 18 m 58 sec
Reputation Power: 13
Thanks for your response. I am still looking for a more specific answer.

I appreciate your time nonetheless!

Reply With Quote
  #4  
Old March 17th, 2003, 05:28 PM
mohecan mohecan is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Feb 2003
Location: Melbourne, Australia
Posts: 212 mohecan User rank is Private First Class (20 - 50 Reputation Level)mohecan User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 11
As stated in the previous reply, Excel and Word will only update on file open, Excel has the capability to prompt for updates to external links on file open.
You can use macros in both Word and Excel, to run on document open that will help automate your updates.
With your word doc, you can use the forms properties, bookmarked to change values.
Using VB scripting in html, you can create a Word Object, as a starting point use this link

http://www.devguru.com/Technologies.../createobj.html

Hope this helps.
Comments on this post
Gran Roguismo agrees!
__________________
How can I soar like an eagle when
I'm flying with turkey's?

Reply With Quote
Reply

Viewing: Dev Shed ForumsProgramming Languages - MoreASP Programming > Excel programming challenge

Developer Shed Advertisers and Affiliates



Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.

© 2003-2013 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap