• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. G

    Sharing a macro

    What is the simplest way to take a recorded macro and send it to another user so it can be used on their own files?
  2. G

    Excel sheet linked to another excel sheet - cell format not following

    Luke, I took my own advice and did the Source and Destination files - and it does work as expected. Back to the drawing board. I believe since I original source came from an xls file, even though it's been resaved as xlsx, is what is causing the issue. I'll try creating a new file and...
  3. G

    Excel sheet linked to another excel sheet - cell format not following

    Luke, When I go into the Connection Properties of my data source (xml), I don't see any place to retrieve cell format. Also, even though the cells are formated for 'Short Date' or 'Currency', the cell does not apply the format to the data until the cell is 're-evaluated'. I'm looking for a...
  4. G

    Excel sheet linked to another excel sheet - cell format not following

    I have a source excel file with 1 worksheet. The file is .xlsx. When I use the file as a XML Data Import source, all of the data comes over, but the cell formatting is incorrect. Source date of 06/17/1926 results in 9665. If I do a find/replace on the entire worksheet for each number...
Back
Top