Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: Changing format

  1. #1
    Guest

    Default

    Hello
    does anyone know how to use VBA to conver one formate of database to another formate of database when it is loaded?

    Please HELP!!!

    Thank you

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    In Access can't you use Macro > TransferDatabase and then choose the format that you require and export.

    Then do the same again but use Import.

    I don't know much about access.
    Regards,

    Gary Hewitt-Long

  3. #3
    Guest

    Default

    I don't know very much about access either. I am using excel, but when I go to macro I can't find transferdatabase there.
    Is Access the only place where I can do that?

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes, its under macros in Access.

    Macros in Access are tottally diferent to Macros in Excel. You can still write code in Modules though. The Macros in Access are made up from pre determined procedures that you link together. You should see when you look.

    Good Luck )

    Regards,

    Gary Hewitt-Long

  5. #5
    Guest

    Default

    Thank you Gary for the information
    Also, do you know how to write the code in module or the procedure of coding in module to do the formating in excel by any chance?
    I just learned how to use VBA 3 days ago.
    Thanks again

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Chippenham, UK
    Posts
    144
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you mean file formats or general formatting?

    Regards,

    Gary Hewitt-Long

  7. #7
    Guest

    Default

    I am trying to do a data formating. For example if I have a data
    Color Taste
    3 4
    5 6

    can I change its format to
    Color 3 5
    Taste 4 6

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try this (If you want you can record a macro to do the steps).

    • Select the range.
    • Copy it.
    • Click on an empty cell (Preferably on an empty worksheet)
    • Go to Edit, Paste Special, and Click on Transpose.
    • Insert a column that acts as your "first" column
    • Put a "1" (Without the quotes) in the first cell of that "new" column.
    • Press Control, and drag the fill handle all the way down until you have all your data covered.
    • Select the first cell again.
    • Go to Data, Sort, select the first column and select "Descending"
    • Eliminate this "new" column


    Now, you can stop the macro. I think that will help.

    _________________
    Regards,

    Juan Pablo G.
    MrExcel.com Consulting

    [ This Message was edited by: Juan Pablo G. on 2002-02-28 23:17 ]

  9. #9
    Guest

    Default

    Thank you so much for helping
    so, once I have recorded the macro, how can I set up the macro. So when the file to be formated can run the macro automatically when the file is loaded to the excel?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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