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...
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...
Does the query you're basing the report on have a parameter set up in it? If so, that's where the box is coming from. You can check this by going into design view of your query. Then select Query from the menu bar, then select Parameters.
If not, make sure that all your fields in your report...
Thanks for the suggestion, but it did not work. Now I'm getting the error that the file already exists and I know that it doesn't. Anything else I could try?
(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...
Bryan,
A built-in Excel macro may be the way you want to go. I am actually working on the same thing. I'm able to perform about everything I want to in the macro (change page orientation, margins, fields widths, etc) but I don't know how to call this macro from the VB code. Right now, I'm...
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)...
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,
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!
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.