ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing on notepad from excel worksheet... Please Help!! (https://www.excelbanter.com/excel-discussion-misc-queries/122438-printing-notepad-excel-worksheet-please-help.html)

riggi

Printing on notepad from excel worksheet... Please Help!!
 
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



All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com