dlingo,
you can shell excel in your system. like this
tt = Shell("D:\Program Files\Microsoft Office\Office\excel.exe c:\Whatever.xls", vbMaximizedFocus)
this will open c:\Whatever.xls as excel is opened
you have to put the path of excel.exe as it is in your system.
cheers
Hello Daniel,
i realised later that i had to reboot my system for the new address to take effect. this is something i hoped to avoid as i wanted to interface two systems on different networks. currently i run a first program, manually change the address, then run a second program, and manaully...
try this
1. add the Microsoft Internet Transfer Control 6.0 to the project
'Place this code in some command button . .
With Inet 'the object added when you add the control in (1.)
.URL = "ftp://111.111.111.111/" 'enter your own server addr.
.UserName = "UsernameInServer"...
If you just want to see serial numbers well
For i = 1 To 15
Print i
Next
that'd give you 1 to 15. 1 and 15 can be variables visible at the point the code will run
for alphabets(upper case)...
For i = 65 To 90
Print Chr(i)
Next
for alphabets(lower case)...
For i = 97 To 122
Print Chr(i)...
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.