in
All Tags » VBA » export (RSS)

Browse by Tags

  • Transfertext Header Rows

    Hello, I am creating a text file from a table using the following vba script but the field names/headers are not included. Is there a way to include the headers in a transfertext. I have them included in my SPEC. Thank you. ic SCRIPT: Private Sub cmdFileExp_Click() Dim sysdat As Variant, mo As Variant...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-04-2010

  • VBA Export Table to CSV file

    Hi I want to make a "export"button on a form to transform a table into a .csv file. Can somebody help me with the right VBA code? I've tried things like: DoCmd.TransferSpreadsheet acExport, "RESULTS", "C:\Temp\Results.csv" Hopefully somebody can help me J
    Posted to Access (Forum) by microsoft on 12-20-2009

  • Export Access Data to Excel Template Using VBA

    I use the TransferSpreadsheet method to export Access data to an Excel Template file (.xlt) worksheet called 'DataSheet': Cmd.TransferSpreadsheet acExport, , "qry1ForTandI_FormExportToExcel", strFile, True, "DataSheet" The Excel Template already has worksheet called 'DataSheet'...
    Posted to Access (Forum) by microsoft on 12-15-2009

  • Export module to text file using VBA (Access 97)

    I guess everything is in the title. I need a simple VBA code that would export a given module to a text file. Any ideas?
    Posted to Access (Forum) by microsoft on 10-30-2009

  • Acess VBA - Export query to Excel + Create New Sheets

    Hi all, Just a quick question... I have an access DB that exports a query called "lastName" to Excel. This works fine, but I want to be able to create a new sheet based on a variable called textInput. Here is my code right now... Private Sub Command6_Click() Dim db As DAO.Database Dim qdf As...
    Posted to Access (Forum) by microsoft on 08-17-2009

  • Using VBA to export all queries, modules, forms, reports to another database

    Howdy, I need to write a VB function that exports all of its database's queries, modules, forms, and reports to another database. I'll give this function a string containing the full path of the destination database. I've been trying hard to use ADO instead of DAO, and I would like to continue...
    Posted to Access (Forum) by microsoft on 08-08-2009

  • Using VBA to export data to Excel

    Hi all, I'm having problems exporting data to Excel using VBA. What I need to do is complicated, and well above my skill level, so I hope you can help. I need to transfer data from a query into and Excel worksheet that already exists. How do I specify a specific column and row for the data to populate...
    Posted to Access (Forum) by microsoft on 07-19-2009

  • Exporting Access 2007 Report to an Excel Template

    I have a report that I create in Access, and would like to export the data in it to an Excel template. In particular, I would like to have 3 things happen: 1. A new .xls file to be created based on the .xlt file 2. The .xls file should have the date appended to filename (i.e. filename_mmddyyyy.xls) 3...
    Posted to Access Coding/Macros (Forum) by microsoft on 07-10-2009

  • Multiple reports in access being export at same time

    I have a Access database that has a form in it that shows 6 reports. Form this form a user can print, view, or export to excel any of the 6 reports. However, the question is how do I set it up that the user can hit one button and have all 6 reports export to an excel spreadsheet and be different sheets...
    Posted to Access (Forum) by microsoft on 06-26-2009

  • Problem: use vba to export to csv

    I am using macros to export testing data from a powerpoint to a Microsoft Excel Comma Separated Values File and it works fine. My question is that if I have 20 different users running the same powerpoint test and 2 or more just happen to hit the submit button at the same time will both their data show...
    Posted to Powerpoint (Forum) by microsoft on 05-30-2009
Page 1 of 1 (10 items)