Reg : Excel

[naresh_kalyan]

Dear all,
If I create a GUI thru userform using VBA in EXCEL, without opening
MsExcel Application is it possible to control my excel sheet thru GUI
only.
I mean can we create a .EXE file for that GUI in a local drive and all
controling (Opening, entering values, save as etc.) can be done from
there itself.

Thanks in Advance.

Kalyan

 

[Guest]

You cannot create an .exe with excel vba. You can partially hide excel from
the user, but it generally looks clunky.

 

[naresh_kalyan]

Thanks John.
Is it possible with Visual Basic ?

Kalyan

 

[Guest]

yes, it'll look a lot better - you simply control excel using the object
model. That's the way I did this once.

If this helps then please rate the post as helpful.

 

[naresh_kalyan]

Dear all.
I have to enter some values in the GUI which can be passed to the
MsExcel.
"Entering the values" in GUI----> "Printed" in one Excelsheet --->
"Saving" it.

Upto Here, I can able to do with all you professional's support.

Now, the problem is ....
I have 50 Parts Details to enter in the GUI.( Some times it can
be varies from 20 to 100), Hence "Entering Values" are to be done
repeatedly. For this reason I need the same "form1" to be repeated.

Please, find the Attachment which can describe the "FLOW CHART".
Except the *Highlighted in GRAY *portion everything can be done as of
now.

Please, Help me.

Thank you for your patience and time.

Kalyan


+-------------------------------------------------------------------+
|Filename: Query3.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4971 |
+-------------------------------------------------------------------+