VBA - Export Specific Column every 30 rows to .txt file

[peternellza]

Hi VBA Wizards,

I have been battling to get this working. The purpose of this is that our customers need to enter a particular format to order in our b2b system. We have a problem with our ERP handling the .xml so limit the customer's orders in the b2b system to 30 lines per order. We would like to provide them with a template whereby they can enter the part number (column A), quantity (Column B) and this will concatenate in Column C as with a semicolon "A2;B2"

What I would like to achieve is to have a button the user can select once they have entered their data into Column A & B (Maximum 5001 lines) which will export the concatenated data into a .txt file splitting files every 30 rows but only where there is data contained in column A & B.

The user should be able to choose the destination to save the files that will be exported. There should also be no blanks or extra line in the .txt file.

I have tried so many methods and cannot get this working, just too complex for my understanding and skill level.

Many thanks !!

Article	Quantity	Output Format
ABC	10	ABC;10
DEF	5	DEF;5
23244	10	23244;10
		;
		;
		;
		;
		;
		;
		;
		;
		;
		;
		;
		;
		;
		;
		;
		;
		;
		;
		;

 

[Marc L]

Hi,​

​

first, for such basic beginner level VBA procedure the 'Output Format' column is useless …​

​

Well elaborate how should be name the exported text files and where (particular location or in same workbook folder ?) …​

An attachment of an expected text file may help better …​