473,386 Members | 1,738 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

badly struck! how to pass values from asp to excel



hi
i am opening an excel file in the same explorer window as the form. i am
storing values entered in excel in database. while saving the field in
the db i need to save a field from the form also.

how can i get a form value inside the vba code or to put it like this
how can i refer the form value inside excel???

i m simply opening a template of excel file.

pls suggest

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 22 '05 #1
1 1355
you cant.. I mean you'd have to have the values in the code before you
generate the Excel file, that is assumign you are generating it from code
and not just pointing to an existing one.

--
Curt Christianson
Site & Scripts: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"VbUser25" <mo**************@YAHOO.com> wrote in message
news:eB**************@TK2MSFTNGP15.phx.gbl...


hi
i am opening an excel file in the same explorer window as the form. i am
storing values entered in excel in database. while saving the field in
the db i need to save a field from the form also.

how can i get a form value inside the vba code or to put it like this
how can i refer the form value inside excel???

i m simply opening a template of excel file.

pls suggest

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 22 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Matthew Robinson | last post by:
http://www.houseproudlancs.co.uk/index.new.htm is the worst, can somebody please have a look and tell me where im going wrong? It shows fine in opera, konqueror, mozilla, netscape but not IE. i...
2
by: Gav | last post by:
Hi, I am new to PHP and was just curious, how "fool proof" is PHP against bad code? I.e. is it possible to cause major headaches for the server (infinite loops etc) with bad code or is the PHP...
1
by: Gil | last post by:
This is a question involving CORBA but the problem shows up using Sun C++. The problem doesn't occur with Visual C++ 6. I'm using a string in the following form in my CORBA IDL declaration so...
10
by: Garmt de Vries | last post by:
In an overview of book titles in many languages, which I wrote about in another thread, I've run across a problem with some titles in scripts that are written from right to left, like Arabic and...
5
by: Paul Reddin | last post by:
Hi, using ROWNUMBER() is affecting the plan of a view very badly... is there a way of writing the following view to ensure rownumber() is done as the last thing done? i.e after the calling...
0
by: vinod babu via .NET 247 | last post by:
(Type your message here) -------------------------------- From: vinod babu Here my adding a new row code Private Sub cmdadd1_Click(ByVal sender As System.Object, ByVal e As...
8
by: Seeker | last post by:
Hello, In using Solaris Pro Compiler to compile Pro*C code. I am getting this error: make: Fatal error in reader: parser_proc_online.mk, line 26: Badly formed macro assignment Based on other...
3
by: Nemo | last post by:
I have been tinkering with CSS in a rather unstructured manner. Fascinating stuff, but I'm a bit out of my depth on some issues and I am appealing for help on the following items. I've cobbled the...
0
by: gireesh21 | last post by:
Hi all, To handle the Cross-thread operation not valid: exception i am using the asynchronous access for the form to handle the controls but it will cause the my application struck, please help me...
2
by: na23sh | last post by:
can somebody help me on how to run a visual basic project with a visdata.On a user pc without installing visual basic 6?i have tried the package depolyment wizard but it didn't work?can you help me...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.