Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making a good report.
Message
 
To
05/01/2001 10:41:29
General information
Forum:
Visual Basic
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00459442
Message ID:
00459920
Views:
29
>Yes I have Excel 2000 on my computer.
>Wich ones are the step to do that I need.?
>TIA

After having generate your file with a .CSV extension, add this code to the declaration of your form:
Private Const SW_SHOW = 5
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
When ready, call this function like this:
lngResult = ShellExecute(Me.hwnd, "print", "c:\path\YourFileName.CSV", vbNullString, "", SW_SHOW)
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Reply
Map
View

Click here to load this message in the networking platform