+ Reply to Thread
Results 1 to 2 of 2

Macro to convert to .xml - date does not work

  1. #1
    Forum Contributor
    Join Date
    06-19-2012
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    158

    Macro to convert to .xml - date does not work

    Hi there,

    I have a file that has a macro to convert the contents into an .xml file is all the criteria are met.

    However, when I get the conversion results, only the date from the first line is in the .xml file; the rest of the dates are blank (even though they are formatted the same). Any help at all is greatly appreciated!

    (I'm not sure if the file actually attached... if not I will try again)
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: Macro to convert to .xml - date does not work

    Hi Tamarissa
    I noticed during executing the code that Range("E4") has some remarks .. Did you notice these notes?
    For example :
    Location/UWI Rainbow Lake Proecessing Plant on line 13 cannot exceed 25 digits.

    Try fix the problems and everything will be ok ..
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Convert VBA Code to work as a Macro
    By nwb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2015, 01:01 PM
  2. Convert Work Hours, Days or Work Week to Months
    By mycon73 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2014, 09:04 AM
  3. Macro doesn't work if fx run on different date from the current date
    By santhisrinivas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2012, 01:08 PM
  4. Macro to convert date to text
    By Jongering in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2012, 04:27 AM
  5. [SOLVED] Macro to convert text to date.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2012, 10:29 PM
  6. Macro to convert date
    By mind4power in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2012, 01:37 PM
  7. Convert 2003 macro to work with 2007
    By luckyros in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2009, 02:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1