I am trying dummy now so I hope I'll get what I need. Thanks!!
I can't help you anymore. Hope you can find the cause of error on your own
You can create similar file with dummy data I don't think it is difficult Can you point to the line...
I cannot upload a file, at least I don't see permission for that :)
You're welcome It will be better to upload sample of your workbook to see the error .. Try to declare...
Thank you! It runs, Ill try some others stuff that I need to add for matching, but I have another...
You're welcome Glad I can offer some help
Thank you!! I will and I'll let you know :)
I am using the below macro for generating individual XML files I would like to generate them in a batch.
Please let me know how do I modify/alter the code to do the same:-
Private Sub CommandButton1_Click()
Dim strFile_Path As String
Dim Filename As String
‘Change cell reference accordingly
Filename = Sheets(“Sheet2”).Range(“C10”)
‘Filename = InputBox(“Enter File Name”, “File Name”, 8)
strFile_Path = “C:\Users\temp\” & Filename & Format(Now(), “dd-MMM-yyyy h-m-s”) & “.xml”
Open strFile_Path For Output As #1
For iCntr = 2 To 2329
Print #1, Sheets(“Sheet1”).Range(“D” & iCntr)
Please share using the share button above.
If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.
Found the answer useful and wants to credit the user, then vote the answer (vote up).
Enter the destination URL
Or link to existing content