Computing.Net > Forums > Programming > Print Excel from VB

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Print Excel from VB

Reply to Message Icon

Name: kboucher
Date: September 17, 2003 at 11:08:17 Pacific
OS: xp
CPU/Ram: not sure
Comment:


I've created an inventory program which allows the user to query different information and have it write to a .csv file. It would be most desirable if the file could be in excel format but this does not seem to allow seperate columns. (.xls) I would then like the ability to print a saved file. (without having to open it) Is that possible? Any further questions please just email me. Thanks!




Sponsored Link
Ads by Google

Response Number 1
Name: Chi Happens
Date: September 17, 2003 at 17:08:12 Pacific
Reply:

You should be able to send the file to print using the ShellExecute command and specify PRINT as the executable and the filespec (the entire file path and name) as the command line option. Example:

ShellExecute Handle,"PRINT", FileName, "", "", SW_SHOWNA

Chi Happens


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: Print Excel from VB

Vb Print Doubt www.computing.net/answers/programming/vb-print-doubt/4015.html

Manipulate access report from VB www.computing.net/answers/programming/manipulate-access-report-from-vb/6098.html

Error from VB .net www.computing.net/answers/programming/error-from-vb-net/5811.html