Search results

  1. Y

    Export to excel with Date format

    Any idea how can I format the column in exported excel sheet? I have a calculated field X/Y and I see the output as 50.14 in Access Query. When I export this into Excel using VBA, this becomes 50.13567890....I want to have 50.14 in exported excel
  2. Y

    Export to excel with Date format

    thanks
  3. Y

    Export to excel with Date format

    Getting some help from google :) ...
  4. Y

    Export to excel with Date format

  5. Y

    Export to excel with Date format

    Can you please share some steps to do that? I am ok with this approach. You are suggesting to create a subroutine and call that subroutine in macro...correct? I think that works ok in excel but not in access....request you to suggest some steps..
  6. Y

    Export to excel with Date format

    Thanks for your response. It is Access macro and VBA. In excel it is easy as you can assign a subroutine to a button. In Access you have to assign a macro to a button and your macro and VBA code are different. Code "PATH\filename" & "_" & Format(Date, "mmddyyyy") & "_" & Format(Time, "hhmmss")...
  7. Y

    Export to excel with Date format

    I have a code in VBA to export data in excel. this works fine and add a date in exported file name. But the Access macro does not like the following code while VBA works fine.. "PATH\filename" & "_" & Format(Date, "mmddyyyy") & "_" & Format(Time, "hhmmss") & ".xlsx" When I create a macro in...
Top Bottom