You also need to release it when you are done. You can use the following, which I believe works for whatever you default browser is (IE, Netscape, whatever) I think. Anyway, here is the code:
oShell = CREATEOBJECT( 'WScript.Shell' )
oShell.Run( "http://www.tek-tips.com" )
oShell =...
For Excel2000, use -4158 for a tab delimited text file.
**oExcel.ActiveSheet.SaveAs("C:\myfile.txt", -4158)
one way to figure out what the constants are is to record a macro in Excel, do what you want to do, then look at the macro in the VBA editor. If you step into it ('f8'), when...
Jonscott8,
Thanks for the info. I did find a .h file with excel constants defined in it, which I #INCLUDE 'd in my prg and that did the trick. Need a copy?
John
Just wondering if you have a header file, or where I can find what the VBA Excel constants are defined as. For example, I am trying o do the same thing, except with a pie chart. The line of code:
objExcel.ActiveChart.ChartType = xlColumnClustered
does not work, xlColumnClustered is not...
somewhere on your system (probably C:\Program Files\Microsoft Visual Studio\Vfp98\Filespec) there are some examples of what I think you want to do, i.e. there are 2 reports, 60frx1.frx and 60frx2.frx. you maight want to run those and see if they are a good example for you, then check out the...
yeah, check out www.amyuni.com, I think they have some info on it. Or if you got the money to spend, just buy the full version of Acrobat, then you can just choose acrobat as your printer and it will print to PDF. Good Luck.
There is also "The Hacker's Guide", that is a good one, I think it is still available at http://www.hentzenwerke.com.
By the way, LOVE the handle ('93 YJ)
actually, I'm pretty sure you can delete everything in that field if you are not sure what you are looking at. Of course, if you have it set up to print landscape instead of portrait, or any other non-default print settings, you will probably want to retain those. Good luck!
open the report as a table (i.e. "use myreport.frx)
in the first record, there is a memo field called "expr".
you need to delete the contents of the memo field, it holds all of your printer specific information. good luck!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.