Hi folks,

I am try to create a form that will create a XLS file in netowork DRIVE so that everyone can access it.

WANT to save the file with different username.

LIKE mine is vishu.xls
if any other user use the form that will create the file with different user name like maxy.xls

Code:

echo off
color f0
mode 50,30
Title HP Sales tracker


echo **********this is a form for all the users*************

echo Customer name      Phone number      Printer      Service ticket      Lead>>

"\\ndokfs03\chat\agent data\vishu.xls"

:1
Echo please enter the following details
echo.
:cn
set /p "cust_name= Pleaser enter customer name : "
if not defined cust_name goto :cn
echo.
:pn
set /p "ph_no= Pleaser enter Phone number: "
if not defined ph_no goto :pn
echo.
:pr
set /p "printer= Pleaser enter Printer: "
if not defined printer goto :pr
echo.
:s
set /p "st= Pleaser enter Service ticket: "
if not defined st goto :s
echo.
:ld
set /p "lead= Pleaser enter lead number: "
if not defined lead goto :ld



echo. >>sales.doc
echo %cust_name%      %ph_no%      %printer%      %st%      %lead%>> "\\ndokfs03\

chat\agent data\vishu.xls"



cls
:mo
set /p "mo= Do you want to add more details? y or n"
if not defined mo goto :mo
if "%mo%"=="y" goto :1
else EOF:


Thanks and regards

VishuIs this going to be used on multiple computers or profiles?

If it is, just save it as %username%.xls

If not though, you can have the user enter the name with a code like this:

Code: [Select]SET /p _username=""
ECHO %Variables%>>%_username%.xlsThank you.

Tired was not working.

But it is working now.

Please let me know if I can change font size?To my knowledge, no. You can't change the font size with a batch file.I mean dos font size.

I want to format my form.You can change the default font and font size for all command prompt windows by clicking the icon at the top left CORNER of the window and choosing "Properties" and then "Font". You cannot change the font type or size programmatically.
Is there any command. I want it to be clanged by command. Quote from: vishuvishal on August 06, 2010, 05:15:45 PM

Is there any command. I want it to be clanged by command.