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


--
naresh_kalyan
------------------------------------------------------------------------
naresh_kalyan's Profile: http://www.excelforum.com/member.php...o&userid=32515
View this thread: http://www.excelforum.com/showthread...hreadid=556940

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

--
www.alignment-systems.com


"naresh_kalyan" wrote:


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


--
naresh_kalyan
------------------------------------------------------------------------
naresh_kalyan's Profile: http://www.excelforum.com/member.php...o&userid=32515
View this thread: http://www.excelforum.com/showthread...hreadid=556940

Thanks John.
Is it possible with Visual Basic ?

Kalyan


--
naresh_kalyan
------------------------------------------------------------------------
naresh_kalyan's Profile: http://www.excelforum.com/member.php...o&userid=32515
View this thread: http://www.excelforum.com/showthread...hreadid=556940

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.


--
www.alignment-systems.com


"naresh_kalyan" wrote:


Thanks John.
Is it possible with Visual Basic ?

Kalyan


--
naresh_kalyan
------------------------------------------------------------------------
naresh_kalyan's Profile: http://www.excelforum.com/member.php...o&userid=32515
View this thread: http://www.excelforum.com/showthread...hreadid=556940

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 |
+-------------------------------------------------------------------+

--
naresh_kalyan
------------------------------------------------------------------------
naresh_kalyan's Profile: http://www.excelforum.com/member.php...o&userid=32515
View this thread: http://www.excelforum.com/showthread...hreadid=556940