Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks guys.... it really helped. I really appreciate.
NickHK wrote: Using "Speed of car A ="; VarA the ";" means print in the next column, the same as you see in the debug window. To control the output, build the string yourself : "Speed of car A =" & VarA NickHK wrote in message ups.com... Hi all, Is there a way to print a number from excel sheet to notepad file and not changing the format. For example when I try to print 78E-02 on the notepad, it prints 0.78. Secondly, while printing in notepad from VB(excel) for instance - Print # 1 "Speed of car A ="; VarA It leaves a blank after = sign. Print results Speed of car A = 250 Is there a way of printing the value of the variable without the space?? Your help will be really appreciated. Thanks, Riggi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing on notepad from excel worksheet... Please Help!! | Excel Discussion (Misc queries) | |||
Notepad to excel | Excel Discussion (Misc queries) | |||
Excel Worksheet Printing | Excel Worksheet Functions | |||
notepad to excel | New Users to Excel | |||
notepad in excel | Excel Programming |