Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. misssaraliz

    Convert Excel to ASCII Fixed Width

    I need to know how to convert an Excel file to fixed width ASCII. Is this just a matter of saving as a different file type? Does it involve changing the type of cells (ie. general)? I'll have to remove all the column headers, right and then produce a file layout? Please let me know the steps...
  2. misssaraliz

    Filename Syntax in Macro

    I posted a few weeks ago on this same issue but didn't get any resolution so I'm going to try again. Thanks to all of you who tried to help. I need to know the syntax for creating a file that will automatically be saved with the date the report is run. Everything is set up in a macro in...
  3. misssaraliz

    Autosave File With Today's Date

    (This is a cross-post) I already have a macro set up that will automatically export a report and save it in Excel. My problem is in trying to save the file with the date the export was run (mmddyy) listed in the filename. Here is an example of what my filename needs to look like (using today...
  4. misssaraliz

    Autosave File With Today's Date

    I already have a macro set up that will automatically export a report and save it in Excel. My problem is in trying to save the file with the date the export was run (mmddyy) listed in the filename. Here is an example of what my filename needs to look like (using today 2/20/02 as an example)...
  5. misssaraliz

    Set Header equal to Cell Contents

    How can I set a custom header equal to the data contained in a particular cell of the spreadsheet (say cells A1 through A2)? I am setting this up in a macro. Thanks,
  6. misssaraliz

    Print Excel Report in VB

    What is the code to print an Excel spreadsheet in VB? I've only seen code on how to print reports within Access. I already have code set up that exports and saves the Access report to Excel format. My trouble is with the printing of the Excel spreadsheet. Thanks so much!
  7. misssaraliz

    Export Access 97 Report to Excel

    I am exporting a report from MS Access 97 into Excel. The same report with different data will be exported daily using a command button that runs a visual basic command to export the report into Excel. The visual basic command also automatically assigns a new name to the report daily using the...
  8. misssaraliz

    Export Access 97 Report to Excel

    I am exporting a report from MS Access 97 into Excel. The same report with different data will be exported daily using a command button that runs a visual basic command to export the report into Excel. The visual basic command also automatically assigns a new name to the report daily using the...
  9. misssaraliz

    Export Access 97 Report to Excel

    I am exporting a report from MS Access 97 into Excel. The same report with different data will be exported daily using a command button that runs a visual basic command to export the report into Excel. The visual basic command also automatically assigns a new name to the report daily using the...

Part and Inventory Search

Back
Top