5/31/2009Create XML files from excel data sheets

Here is an example that shows you how to create a xml file from excel data (xls) using macros. Print #FileNum, Cells(1, 1); ' Print #FileNum, "" For r = 3 To 327 Print #FileNum, "" Print #FileNum, ""; Cells(r, 2); "" Print #FileNum, "Classified Feed" Print #FileNum, "" [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by: wiki
Posted on: 5/31/2009 at 3:43 PM
Tags: ,
Categories: VBA Macros
Actions: E-mail | Kick it! | DZone it! | del.icio.us
Post Information: Permalink | Comments (2) | Post RSSRSS comment feed

5/31/2009Export xls data in csv format or tab delimited format

Here is a macro that will help you export the data from your excel sheet to csv format or tab delimited format. [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by: wiki
Posted on: 5/31/2009 at 2:23 PM
Tags: , , , ,
Categories: VBA Macros
Actions: E-mail | Kick it! | DZone it! | del.icio.us
Post Information: Permalink | Comments (24) | Post RSSRSS comment feed

5/26/2009File Name Extractions

File Name Extractions. A new file is created in the folder called filelist.txt. This will have all the file names with extensions. [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by: wiki
Posted on: 5/26/2009 at 5:33 PM
Tags: ,
Categories: Software Testing
Actions: E-mail | Kick it! | DZone it! | del.icio.us
Post Information: Permalink | Comments (1) | Post RSSRSS comment feed