User Profile

Collapse

Profile Sidebar

Collapse
Arne Vanhoof
Arne Vanhoof
Last Activity: Jan 18 '12, 10:04 PM
Joined: Apr 27 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Arne Vanhoof
    started a topic VBA: Auto fill in form of open website
    in Access

    VBA: Auto fill in form of open website

    Dear all,

    I already searched and found a lot solutions to navigate to a page by vba and fill in form controls.
    However, I want to fill in form controls of an open window in IE, but I have no idea how to appoint the open IE window to use in VBA code.

    Does anyone has an idea how to solve this issue?

    Thanks in advance
    See more | Go to post
    • Arne Vanhoof
      replied to VBA: Export query to Excel and format as table
      in Access
      Hi,

      Because it is part of a tool that will be distributed amongs several users.
      Then the template also needs to be distributed what will make everything a lot complicated.

      Kind regards
      See more | Go to post

        Leave a comment:

      • Arne Vanhoof
        started a topic VBA: Export query to Excel and format as table
        in Access

        VBA: Export query to Excel and format as table

        Hi all,

        First of all I will try to explain what I want to achieve.

        In my Access database I will export some queries to serveral worksheets within the same workbook.
        However I want the different worksheets immediately in a table format.

        This is the solution I have at the moment:

        With regard to the export I use:
        Code:
         .TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Queryname",
        ...
        See more | Go to post
        No activity results to display
        Show More
        Working...