Excel Automation
I developed an application using VB6 as FE and Access as BE ( Lan based solution). This application involves picking up preformatted excel workbook with multiple worksheets as template . This excel workbook is more like a form ( containing checkboxes and option radio buttons etc). This also contains clients logo, Header, footer. In this application, on a button click event, the Excel file is picked up from a fixed location, opened, and some data like name of the user, address etc which are available in Access are filled into predefined cells of the excel.
In case any of the fields is already filled, the application reads that fileld and performs validation. After this the workbook is saved at the original location. Most of the fields are not stored in database and data is not in a tabular form.
Now I need to make this application web enabled instead of being on LAN.
Can the above excel automation be acheived in conventional ASP or ASP.net.
I can force the excel path to be fixed path on server ( IIS). I would be too happy if the said excel workbook can be picked up from client machine, modified and stored back at same location.
View Replies
ADVERTISEMENT
I have a recordset containing some data.
Using that recordset I want to populate them in a work book in differrent
sheets, using client side VBScript.
Previously, I used server side automation for this. But it gives error
"ActiveX Component can't create object" then and there. Some times the
automation works fine.
View Replies
View Related
We have a excel document, which is been updated regularly. After everyday
updating, we export as HTML file and upload it.
As a ASP programmer, I want to write a script, which can parse this excel
file and make it as a web ready file.
Is there any simple way to do this?
Our data entry operator, is very new to computers and all he know is a
little in Excel.
View Replies
View Related
I have a very small ASP function that basically allows me to add items to a list and it all gets stored in an Access DB. The output is a loop that displays all of the items.
I wanted to know if anyone knows how or if with ASP I can update an RSS file so that when it saves the new list item it also updates the RSS feed with the new items as well. Sort of like updating a Text file just not sure how or even if it can be done.
View Replies
View Related
I have an ASP page using Jet 4.0 oldeb provider for mdb. (ADO 2.8). I use
the _same_ code in ASP from my well working VB application.
The problem is:
when I do the same "SELECT * FROM table WHERE field1 LIKE '%asdf%' " query,
it works in Access (SQL query) or in my VB .exe code, but generates OLE
automation error in ASP. The same code!!!
If I use "=" instead of LIKE, it works. (field1 is string type). But I need
LIKE
View Replies
View Related
I am getting ready to build another ASP page with a form on it. This form is part of a very complex application I am in the middle of building. It is an event management and scheduling application. The whole idea of this page is to register an individual for the event and to schedule their activities they want to participate in.
Here is were it gets complicated... We have over 30 events and they are all happening at different times. Some are overnight and others are half day and other are full day. We even have some that are two days long.
Some of the events can hold 80 people but their are 40 instructors for that time period. I solved this problem by creating section numbers kind of like in a college. Here is my actual question:
How can I build drop down boxes that change according to what is selected in a previous one. I am using the DB to populate the drop down boxes. Here is an example of what should happen: Code:
View Replies
View Related
I need to generate one document on the server and then send it to de client. I having problems of security when i try to open word by code. How can i do that?
View Replies
View Related
i have a software application and i have to import around 250 users data into the app.
I want to automate this step,it the most common info
like FN,LN,e-mail etc.
The app runs on IIS and uses ASP. I am looking for a GUI input Automation tool which will have scripting capability to take input from a text file and fill the user input fields "automagically".can testing tools like winrunner do this for me?
View Replies
View Related
I have a script that populates my access database upon form submision.I was asked to find a way to automatically Populates 10 records, that do not change, to the database
once a month.I thought of using WHS to to call IExplorer to execute and launch the URL. and set the windows scheduler to execute it once a month.
But my 10 records that I need to add have different names. How do I set the loop to call the record set
for each field name.Another approche is to set those uncahgeable data in a flat file and use my asp script to call the file and append the records in the table.
What is the best approch
View Replies
View Related
i have a problem in email using ASP.i have created 3 fields named EMP MAIL,TRAINING START DATE,TRAINING END DATE.now the user enters these 3 details and on clicking the SENDMAIL button the mail should be reached to that particular employee 1 week before the date entered in the TRAINING END DATE field.after testing the application this all is working fine(i used CDONTS in ASP).
The problem is that every day user has to run my application atleast once only then all the mails that are to be sent on that particular day will be sent.
i think this is no good as user will enter the details once for any day and he or she may not run my application every day..in order to send mails automatically what should i do..pls any body can give me any suggestion?
View Replies
View Related
I'm about to create an ASP script which will essentially parse SQL
tuples (rows) into a Word file, creating labels, although would need
to use the pre-defined label templates within word.
Can anyone direct me in the right direction?
View Replies
View Related
I want to do some time based house cleaning chores on a server based on server time/date. I know how to do it based on a call from the client using asp, but is it
possible to have a program residing on the server that comes alive based on server time (not a client call) and does it's tasks such as delete an inactive page, or more importantly, send out a cdonts e-mail to a client list? I should also mention that this is a shared Windows 2003 Server (Interland Blue Halo).
View Replies
View Related
I've develop a simply exe app that merge two or more document in one using MsWord automation.
I call this exe from an asp page (giving authorization to IAWM IUSR...). This run ok on a web server with Xp and IIS 5.1 but don't work on W2K3 and IIS 6.0.
View Replies
View Related
I am facing some problems with generating the word documents usin ASP pages. This is the automated process and it is breaking often Since Microsoft is not providing any support for this issue, I though using WordPerfect 12 for the automated document generation would hel me a lot. Is there any possibility of facing the same problem with wor
perfect too?
View Replies
View Related
I have problem in word automation. I have a code in VB that opens word document and performs some Find & Replace operations in it and then shows to the user the document. The script runs perfectly on local machine which has Word2000 and OS-win 2000 professional. But When I test the same script on Server which has Os-2000 server Edition and word2000 then it does not opens the word doc eventhough script has line "WApp.visible = true".
I am using Word.Application and Word.Document object in my script. When I create a word document with same script but close it in end of script and then open it with shell script command it works perfectly. But my requirement is not to save the doc but only show it to user and leave it for users choice to save it or not.
View Replies
View Related
Could someone point me in the right direction? I've
migrated three FrontPage 2002 websites to a new web
server. Each web site has a Access 2000 database on the
data server.
I have the global.asa on each site pointing
to a .udl file which is pointing to the appropriate access
DB on the data server. We're not allowed to use DSN's.
Front Page 2002 will not allow me to create a network
connection to an Access (only SQL). Only one of the three
web sites work. On the other two I keep getting the
following message when I open an ASP page: Code:
View Replies
View Related
I have a page in my website which display the weekly timeslots. The code that generates these slots is giving me the following error:
Microsoft VBScript runtime error '800a01b0'
File name or class name not found during Automation operation: 'regExp'
It used to work fine, I have no clue what has gone wrong.
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
I need to write an ASP page that will allow users to upload an Excel file,
the contents of which should then be imported into an SQL database.
Problem I am facing is how to do this efficiently. So far I have a page
that
will accept an upload, then display the data from the Excel file, my first
thought was to loop each row, then run an update/insert based on the data
found...Obviously this is not going to be very efficient, I'd exepect time
outs often
Has anyone got any ideas to get round this?
View Replies
View Related
I try to use asp to extract excel data. if the item field in excel is empty,
can I use "" to represent empty ?
will this (" ") work ?
rs("Item") = ""
rs.open "SELECT * FROM [Sheet1$]", oConn
do until rs.EOF
if rs("Item") = "" then
emptyfield = true
else
emptyfield = FALSE
end if
rs.movenext
Loop
View Replies
View Related
Is it possible for me to send the output of an ASP file to an Excel Sheet
View Replies
View Related
I can connect to an Excel worksheet and get records with no problem, if
I know the worksheet's name. However, when my users upload their excel
files, I don't know what the active sheet they want to work from is
called.
I have two options - either force them all to give the saem name to
every worksheet they upload, or providing them with an input field
where they can provide the name of the relevant worksheet
Rather than force my users to name all their worksheets "sheet1", is
there a way I can use ASP to find out the names of the worksheets in a
workbook?
View Replies
View Related
You know how you can connect an ASP page to a SQL server to retrieve data from a database/table and display it. Well what I want to do is connect my ASP page to an Excel spreadsheet and retrive the data and display the info on my ASP page. How do i go about doing this?
View Replies
View Related
