Is it possible to send data from ASP and put it into a existing template? i don't want to create an excel document I only want to send one piece of information from ASP to the Exisiting Template.
We have created a online quote number genetrator for our sales team and we want it to open the excel quote template and put the quote number on that excel template.
From the ASP application I am trying to 1) open a template 2) add data to a couple of fields (passed from order.asp to invoice.asp) 3) do a Save As so that the user can save to client.
I have this code working fine for a word document, but I am having touble with the XLT. Any suggestions?
I've been reading through all related Excel posts now for about an hour as well as Googling for my answer and I'm getting even more cornfuzed as I go. I have an Existing Excel Spreadsheet, I need to populate certain fields of the form with values from a Database.
I have no problems connecting to my database and pulling up the data, but I have no idea where to begin with opening my existing spreadsheet, then telling it which worksheet to use and then how to populate the fields I need.
I'm not looking for an entire code handout, this is just something that I haven't attempted before in ASP. If someone could just give a quick example of first opening the existing spreadsheet, selecting the correct worksheet and populating 1 field, I think I can figure everything else out from there.
I have an Excel Template that is filled out in certain senarios. What I want to be able to do is access this existing Excel Template through a webpage, enter nessisary data into the template, and then e-mail these changes to certain people. The original Excel template needs to stay Unfilled out and unmodified once the process is complete. If saving a different copy to e-mail is nessisary that is ok. I have Created the Excel object on the server to be filled with database info from a query, but I'm not sure how to open an current excel document and then email that document onces it is filled out..
View Replies View RelatedImporting EXCEL worksheet into existing ACCESS tables is possible.
Is there any way i could import EXCEL worksheet into an existing ACCESS table using ASP code.Something like, i could upload a EXCEL file from a browser and then it can be imported into an existing table And if possible also check for duplicate keys and update those records. If no records exist then insert them.
is there a way of calling an already existing excel document and populating certain cells
View Replies View Relatedcan use template with asp like php ?
View Replies View RelatedI am looking for a website that provides a message board template.
Also one that provides a form that allows customers to pay membership dues online while inputing information to be stored in a database.
I am trying to update a website that uses ASP to connect to a database.
I want to change a template file i have so that it is CSS driven with as few tables as possible.
I have managed to strip the tables from the header and footer sections of the template and replace them with divs and CSS styled unordered lists.
I am struggling with the site breadcrumb, navigation and main content areas as these use ASP code to draw data from a database (i dont have access to the database). The site is updated using a Content Management System.
The main site webmaster has told me that a CSS driven template is unworkable. I think that she just cannot be bothered to change with the times and therefore won't move to a CSS driven layout. She took great lengths explaining that she had been doing the job for six years and that tables were the best way to go.
I have the template file i'm trying to change. I have included the full template unchanged below. The template code is below: Code:
I need sample in asp how ? so when I change into news/link/ or somthing then I get the info in default ??? can somone tell me how? or where I can find templete in ASP not html??
Default.asp
Include
Left.asp
Right.asp
Top.asp
Bottom.asp
Are there any template engines out there for ASP? I'm a PHP guy at heart and I love my Smarty template engine. Is there a template engine out there for ASP that is comparable to Smarty? Are there any template engines at all for that matter?
View Replies View RelatedI need to create a template for an online newsletter that will auto-generate
page number (with current page not hyperlinked) and previous and next
buttons (no previous on first page and no next on last page).
Does anyone know of any quick asp code that will do this? I don't think
that it'd be too hard to do, but I'm very new at asp. Code:
Is it possible to open a Outlook Template via ASP? The template will be housed on the webserver itself.
View Replies View RelatedMy client has 35 domains (web addresses) that they want to host on a Windows 2K box with IIS 5. They want one application built using ASP and SQL server, hosted somehow on the IIS so that it appears as the same application for each domain. The end user of each domain will actually be using the same application.The head of each of the 35 domain, or the jr. web master of each domain should be able to cutomize the look of the each of their domain. This customization feature would be built into the ASP application. Things that can be changed would be some text, color of text, size and color of input boxes.
This application will be similar to some of the eCommerce sites that have a web interface for their merchants to be able to modify their individual sites. Sort of selecting and modifying templates. They want 1 application so any changes and update of the application will reflect on all domains.My question is how do I start designing this?
Where can I get info on this project, any opensource stuff I can look at?
Do I incorporate XML anywhere?The domains will be accessing the same DB, how do I minimize DB trips?
I have created a word template(.dot) with several bookmarks but know I don't know how to fill this information from the asp page. I have to retrieve the information from the database and fill the information in the word document Code:
View Replies View Relatedi work a lot with smarty that is a template manager for php.. there is someone similar for asp ?
View Replies View RelatedI am looking for a script or a tutorial on how to generate a web page by having a user fill in a few chosen fields and entering the information into some preprogrammed html code using variables.It would then display their page and underneath it the html code.
Exactly like this, but in asp or cold fusion:
http://www.tupics.com/freead/create.pl
I would like to code a message template. I have 2 pages here, to ease my illustration, I named it as FirstPage.asp and SecondPage.asp. I had coded a button on FirstPage.asp, so that when user clicks on the button,then the SecondPage.asp will pop up and a list of messages which is retrieved from database will be displayed, row by row accordingly.
my doubt is how to set a selected message from SecondPage.asp to put it in FirstPage.asp's textbox?
Does anybody have the code to open a Word template held on the same machine, from an asp page,. say path is "C: emplatesBuild1.dot". I've tried a lot of different codes but none open it. If this is possible can I write to it with "response.write" statements.?
View Replies View RelatedI am implementing print template solution. I would like to use it in asp
app. I open new document then generate print preview then print and
finally close preview window, but I am not able to close previewed document.
I try to move document window out of screen - somewhere like
9999999,9999999 position, view preview then print and finnaly close
preview window. Then document window is invisible but still exists.
How can I close the document window after preview??
I belive it would be better solution if I could open printed document in
my ActiveX (with browser ActiveX included) but trying do it I receive
login page :-( . I am not able to share session between document and
implemented ActiveX.
I have just been asled to produce an facility on an existing web site that allows users to go to a page which contains four business card designs. They would then select a design and be able to fill in the details they want on the selected card whilst they are on line and send the information to the company for printing. If this make sense can anyone help?
View Replies View RelatedDoes anyone know of a good template class/system, which I can use in my ASP pages to seperate HTML from ASP?
View Replies View RelatedCan anyone do me a huge favour? I need an asp template page which will pull data and display it on that page, from an XML file.
The file doesnt contain all the data, its a query to data on a server within our work.
Ive tried endlessley from tutorials etc and the best ive had is a message saying "XML DATA RETRIEVED"
I just cant get the phonelist.xml file to display, basically its a list of staff name / email / phone extension.
I have seen PHP scripts that that define an iHTML template and then set an array that is used by the iHTML file to add code fragments. Does anyone know how an iHTML template can be used by ASP?
View Replies View Relatedi have 2 tables and i want the content of the one table where the second tables content doenst exist in the other table.
E.g.
Table 1
id1
1
2
3
4
Table 2
id1
1
4
so i would only get 2 and 3 in table 1.
I have different templates for different companies to be sent to the customer. first i get all the templates from the DB by giving: Select templates from tempates;
Now i want the user to select one..may be we can have a radio button displayed near the textarea in which i will be displaying the templates from DB. Once the agent selects one of the templates to be sent,that template should be sent as an email to the customer.
How do i go on achieving this ,with good formatted template in the DB?
As creating folders after a form submission is quite easy (as pointed out in my last post - thanks again) I was wondering If it was also possible to create a new permanent ASP page based on a template .
All that needs to be changed is the title of the page and the file name. However the new page must be a copy of the template (only with these changes in it.
I'm looking for an ASP template class, that's up to par with Smarty. I really need a few functions that Smarty has, like assign, section, custom functions and the ability to use arrays in my templates. I doubt anything like it exists in ASP, but I'm still hoping... anyone know of any template class that comes near Smarty?
View Replies View RelatedRight now I use difference include files for my header, footer, functions, config, etc. Has anyone had any success with this type of template system? Or maybe there is a better template system everyone is using?
Also, if anyone is familiar with "here document" syntax in PHP, how do I get that type of functionality for my ASP code? I tried creating functions for the header and footer such as getheader(pagename, pageid) but was unable to figure out how to write such a large piece of code to be output by a functions.
On the server i am using a asp script to loop thru an xml file that contains a number of email addresses. When i pick up a email address i would like to call a cfm template that sends the email. I have tried the below:
Server.Execute("sendemail.cfm?Email=john");
but it gives me a ASP 0231 error. i suspect that i can only call another asp script. Interestingly i only get an error when i use the string parameter any thoughts? i would like to use CF as the mail delivery vehicle.
At the moment i'm working on a template based newsletterscript and this a testscript to get some variables. This is actually working for one record but i want it to get al the records where the Newsid = "1" e.q.
It's not necessary to print/ write the results but this is just testing.
Actually the following part should be a select case... depending on the value of the column = template e.q "1" he should display this record in another format. Code:
I have an Access database; e.g., mydb; with 10 Tables (e.g., tbl1, tbl2, ..., tble10) in my database directory; e.g., fpdb.
I need to be able to copy the entire database with tables to another directory, where the name of directory will be provided by the user (therefore I do not know the directory name in advance).
How can I make a copy of existing Access DB vis ASP programming.
I'm a newbie to ASP coming from a PHP background and I wonder if there is - well I am sure there is - a command to check for the exists of a file which is on a ftp server (on the same as the file which tests it). Also is there a general site which explains all the asp commands in a logical form like php.net does for PHP
View Replies View Related