Excel Programming?
I have 60,000 records and each row/record has one cell that contains additional 100-200 lines of data (tab delimited i believe) .. weird format. So what I need to do is extract those data in that one cell into separate records, duplicating the fields with it.
Lets say i have one record and the record has about 10 columns of data. Column C would contain about 200 additional lines of data. I need to extract that and insert new rows to insert these data into individual records.
View Replies
ADVERTISEMENT
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
View Replies
View Related
i need some help to find a way to pas a asp variable in to the ssi include file commend
i have tryde to pass the varible like this:
<!--#include file="sets/<%=a1%>.asp" -->
that didn work for me so i tryed this way instead
a2 = "<!--#include file="sets/cenarion.asp" -->"
<%=a2%>
that didn want to wark either
im little lost how to get this to work im not sure if its even possible .
what im trying to do is pass the A1 varible to the include fille command couse A1 contains the name of the file. A1 gets its info from a request.querystring
View Replies
View Related
what software do I have to use for doing programming in asp and php. Atleast I want to learn basics.
View Replies
View Related
I am developing a blackjack game which is multiplayer, multitable game in which 4 users playing on each table.
There are 8 tables like this.
I am generating random cards through my random card function. Main problem is that I want to track cards for avoiding repitition. I can use application veriable for one table . But how to do for multitable ? We can't track it on session side as well as application side as all tables are in one application.
View Replies
View Related
Can any one tell me how many programming languages are there in the world? I tried to google it but could not really get an exact or complete list of them all.cheers.
View Replies
View Related
I think following code makes just one page Landscape. It restricts the range of document. But I can run this code in asp. How can I convert this macro code to asp code?
ActiveDocument.Range(Start:=Selection.Start, End:=ActiveDocument. _
Content.End).PageSetup
..Orientation = wdOrientLandscape
View Replies
View Related
I am building a site that offers the purchase of information. Clients can view a limited amount of info then they are able to view each recset in further detail once they purchase it. I am running into difficulties of how to facilitate this. I am using dbquicksite3 to build the ASP (I could do it on my own but it would take much longer). I am using Access 2000 for the DB and this also seems to be limiting me somewhat). I want to keep it simple because it is not a broad reaching website (probably several hundred recsets of purchase info and hopefully several thousand customers). Anyway, the problem is that I have a search for the basic results, I have a basic results page but I cannot figure out how to allow users to access only the pages that they purchase right after they purchase rather than watching my email account and sending the query results back via email. I suppose I could built a 'watcher' app that could parse the email from paypal for the order number and query my DB for the paidinfo/basic info results, combine them and send out an email in response....
Is this the best way? I have a log in but 9 levels does not help considering I have hundereds of recsets of info that can be purchased and if I give access by levels they would be able to view all in that tier.
View Replies
View Related
I have an Access Database consisting of 10 Tables 1,table10. I need to add a new column to an existing table (e.g., table 1) without affecting the existing data in other columns.
How can I add a new column to an existing Table via ASP programming.
View Replies
View Related
Why doesn't anyone ever have problems during the night when i'm not working and can post then? Why do karsh and vlince get to answer every question? And if they have jobs where they can post all day why can't i have their job?
Does no one out there feel like answering? Doesn't anyone program during the night? I know plenty of people that work the 2-10 shift, why don't they post at night? or do we need to wait for college kids to ask how to do their homework again.....It's getting to be that time of year.
View Replies
View Related
What is the best or most used software for programming in ASP and/or ASP.NET? I will mostly use to program web pages. I like to know if Visual Studio .NET will allow me to program web pages using ASP and ASP.NET.
View Replies
View Related
Just started learning ASP, seems like lots of people use VBScript to program with. Though, I have spent the last year learning Java. Just wondering if I can use this to program with? along with its API's ?
Also, is it worth while to learn VBScript ? Is it industry standard or needed? Im guessing it is from the way its the language used in most ASP books. Any insight would be great.
View Replies
View Related
guide me to start asp programming and shortest tips.
View Replies
View Related
My page sends an email using CDO to a username pulled from a database as follows:
With cdoMessage
Set .Configuration = cdoConfig
.From = "Admin <admin@MyCompany.com>"
.To = rs("USERName") & "@MyCompany.com"
.Subject = "Notification #" & rs("subject_Num")
.TextBody = txtVar
.Send
End With
this works great so long as USERName isn't garbage. If there are bad characters in it that IIS doesn't like, it get an error '8004020f' at the .send line.
I was wondering if there was an easy and / or publicly available code snippet that could check the user name for special chars. Ideally, it would email me if there was a problem with the USERName rather than just strip the bad chars out and send it to whatever is left.
View Replies
View Related
I have a problem with landscape pages in word document. I am creating a word document using asp programming. I want to set n. page as a landscape. But I can not do it.
for example I want to set first 3 page as a portrait then 4th pag landscape and then 5th page as a portrait again.
There is a code like ....
objWord.Application.Selection.PageSetup.Orientatio n = 1
But it set all pages as a landscape.
I just want to set only the active page as a landscape.
There is a macro option like makes landscape this point forward not all document. But I can not do this in asp programming.
How can I solve the problem?
View Replies
View Related
i ask you to explain what is object oriented programmind and how to use it in ASP. what is its advantages?can i take some documents of you suggest.
i want to learn object oriented programming. i am already using functions in asp alot. i thinkobject oriented programming means Class for ASP. but what are differences betweenfunction and class.
View Replies
View Related
is it possible for me to create my own classes and use them in web pages? Is this common with ASP. are there any ASP OOP tutorials you know of?
View Replies
View Related
I will save the word document in file system of server.
following macro code makes just first page landscape.
"wdSectionBreakNextPage" starts new section but I dont know How I ca
convert this macro code to asp?
I try to make just page landscape others are portrait in as
programming. I can do this by word macro but not by asp...
View Replies
View Related
if anyone knew of a good book or website that explained in detail how to program a good username and password protection script for a website. It doesn't have to be anything great, just something that is a little secure and works.
View Replies
View Related
I have a pdf editor software which opens pdf files in edit mode. I am opening a pdf file through this software in my code. The code is as follows:
Process.Start(Application.StartupPath.Substring(0, Application.StartupPath.ToString().IndexOf("Eviction")) + "PDF Editor 2PDFEdit.exe", "F:Covenant.pdf");
But, I want to pass some data to be displayed in the pdf file. This software allows to insert some textboxes(with name given to each textbox) in the pdf file and save them.
So, when I open this pdf file through my code, I want some values to be displayed in these textboxes.
View Replies
View Related
For the past couple of months we've been developing a fair number of sites and sub-sites for an intranet site using a mix of JScript and VBScript.
Personally I disklike ASP and consider it an inferior scripting environment compared to Perl, PHP or Java, and the only reason I consented to work on this project was that I could use JScript (hello!.. real hashtables, exception handling etc.).
The problem we're having at the moment, is that one developer only does VBScript, and I will only write large amounts of code if I use JScript. But various aspects of the sites are merging, and we're having problems passing varbles two and from VBScript and JScript. One hacked up solution i've used is as follows: Code:
View Replies
View Related
I always heard the term "data/database driven programming" model in ASP database, SQL programming, and web programming circles. But I don't quite sure what does it mean? Does it mean the web software's responds are based on data request from the user? Just like in Windows, we call it "event-driven programming" model because the windows program's responds based on user's responses? That's why we call "data driven programming" ?
View Replies
View Related
I want to give Excel facility into the the Browser for the user and after that I need to insert all the Excel data into the SQL Database table.
View Replies
View Related
i have a project i am currently working on, basically what i am doing is i have an excel spreadsheet with 2 fields a number that coordinates with another field which is a url, currently i have to copy paste the url in my browser to get what i want, which is a picture, each url is a picture and picture only, what im trying to do is create an asp web app that i can use that spreadsheet connect using asp and automatically download every url in the spreadsheet to a directory, while also renaming all the pics as the first field.jpg,so basically an asp downloader that downloads contents of url and renames it a certain number
View Replies
View Related
I've an asp page which brings back a query and displays it in a table. The
query takes around 30 seconds. Once the page displays they will have an
option to send it to excel.
From the examples I've seen they all require the
query to be re-ran again in asp (i.e. server side scripting) and as it takes
30 seconds to start with I want to try and take out the repeat of the query.
Does anyone know of any way you can do this in asp by passing the already
executed table to asp or via any other method?
View Replies
View Related
I want to access the data contained in the MS excel by giving a field value that has to be got from one HTML file including a textbox and one button -SUBMIT to submit the required field value. Finally i want to display the details of that particular field value which is recieved from the first file in HTML. Is it possible ?
View Replies
View Related
I have an ASP file which is opened in MS Excel.
I have used the "formatNumber" function to set the number
of decimals for variables which are displayed.
however Excel cuts off any zeros at the end.
e.g 4.650 displays as 4.65
the number of decimals I want to display to varies across
the page, e.g. I cant say "display the whole with 3
decimal places"
Is there any code I can put in my ASP page to stop Excel
truncating zeros at the end?
View Replies
View Related
i have a Print button to allow user to save reservation detail in ms excel. currently, when user clicks Print, a Save menu which allow user to open and save will appear. how can i skip this window? i want my system automatically open ms excel and at the same time open the Print window in ms excel and user also cannot modify any detail in ms excel. is it posible to that?
View Replies
View Related
I'm working on some reports, and have added the ability to
"download" the reports to excel. Not a big deal, fairly straight forward.
However, PHB wants to be able to create some pivot tables from said reports
(again.. no biggie) and when he goes to save the file, Excel wants to save
the file as a web page instead of and Excel spreadsheet.
Now.. I know the simple thing here is to just pick Excel from the drop down
box in the save as dialog.. but.. PHB would "prefer" to not have to do that.
Has anyone been able to jump this hurdle before? My good friend google
hasn't turned anything up. My preference is to give PHB the middle finger..
but alas.. the paycheck is keeping me from doing that.
View Replies
View Related
is there somewhere a file that holds constants for Excel Automation
ActiveX objects, such as adovbs.inc for ADO constants?
View Replies
View Related
I have an asp, sql business application. Want to give export option of all
reports to excel and pdf. Can I get that code which can embedd in the asp
pages to create this function?
View Replies
View Related
I need on-site manager's to be able to view a list of records on our website
(which they already can do). They need to be able to select any/all fields
and then export these items to an excel spreadsheet. The spreadsheet will
have dynamically created columns/rows to append and life is good.
What's the best way to go about this? I've used DTS to do this before, but
it's been a long time and I can't remember if there's a way to handle this
kind of stuff on a dynamic basis.
I guess my real question is: Is there a way to do this via ASP or should I
stick with a more SQL based approach?
View Replies
View Related
Is it possible to copy all info on a page into excel so that it can be sorted?? I know how to get the page to load automatically into excel, using the -:
Code:
<%
response.contentType = "application/vnd.ms-excel"
%>
however I lose some functionality if I do this, i know i could add a button that just re-runs the pages to load the info into excel, however some of the pages may take a while and I want to reduce time and load on the server. So I justed would like to know if it is possible using a script of somesort so that clicking a button will copy the whole page and then paste it into excel??
View Replies
View Related
