Hi
Can a VBS script take an xlsx file that has more than 65000 rows and create as many target files whose rows number count do not exceed that?
This script should work independent of Excel in windows xp.
Thanks
Used Windows notepad, typed Sendkeys "%{f4}" and saved the file with vbs extension.
However, when executing, I get:
Windows Script Host
Script: C:\test.vbs
Line: 1
Char: 1
Error: Type mismatch: 'Sendkeys'
Code: 800A000D
Source: Microsoft VBScript runtime error
What am I doing wrong?
Win XP...
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.