Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

xlsx splitter by rows

Status
Not open for further replies.
drgt

drgt

Technical User
Jun 20, 2021
8
GR
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
 
Sort by date Sort by votes
Wrong forum. You should ask your question in VBScript
This is a classic Visual Basic 6 place.

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
NEVER used - get all possible info by ip
Replies
4
Views
257
strongm
strongm
f0rg3tfu1
  • Locked
  • Question
circular reference caused by alias in query definition
Replies
7
Views
400
strongm
strongm
sal21
  • Locked
  • Question
for strongm... navigate in listview by cell.
Replies
2
Views
144
sal21
sal21
sal21
  • Locked
  • Question
GET street address by lat and lng 1
Replies
11
Views
237
strongm
strongm
Niki_S
  • Locked
  • Question
How to insert data into a grid by using another grid in vb 6?
Replies
2
Views
146
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top