+ Reply to Thread
Results 1 to 3 of 3

[Excel 2k3] Importing spreadsheet specs from Access Tables and Render it in Excel

  1. #1
    Registered User
    Join Date
    11-17-2011
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    [Excel 2k3] Importing spreadsheet specs from Access Tables and Render it in Excel

    Hi,


    I have made a VBA code that takes Spreadsheet's properties (columns, rows lenghts weights data inside ...) from Access Tables and render them in an Excel spreadsheet; if I choose 3 files to import, then I'll have 1 description column and 6 columns for data (2 columns per files)


    The code is here:

    https://skydrive.live.com/?cid=a8365...9&sc=documents

    the print file is the spreadsheet

    and coaching is the UserForm that imports the data from access and send them to print sheet

    you can view files with VB or NotePad++ if you want

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: [Excel 2k3] Importing spreadsheet specs from Access Tables and Render it in Excel

    Hi iboumiza, I cannot access the code from that link.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

  3. #3
    Registered User
    Join Date
    11-17-2011
    Location
    Canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: [Excel 2k3] Importing spreadsheet specs from Access Tables and Render it in Excel

    Ok, I attached the files
    sheet.txt
    and
    print.txt

    the render function is not working... it renders just the description column and 1 data column

    Thanks
    Last edited by iboumiza; 12-19-2011 at 08:48 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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