Hi friends:),

 I am trying to generate and data from access using query through front end by an combo box (i.e) ,for exmp i am have 5 datas which have an master field name of employee name based on the employee name i am taking the other datas by using combo box and command button . I got the good reslut by our community guy's .Now i want to export data to excel automatically using macor . pls help me in this issue. is it possible for me to export the data to the excel file without giving an file.xls name (i.e.) default or the excel sheet that i prefer which already contain macros .

 Or export the data with out macro by VB coding is also preferrable.Bye

P.A.P.Raguv

Well, of course you cannot export to a file without knowing its name. But if you mean that you don't want to be prompted on-screen for a file name, of course you can put the filename into your code.

Create a new macro
Set the action to "OutputTo"
Set Object Type to the table or query you want to output
Set OutputFormat to Microsoft Excel (*.xls)
Set the aoutput file to the path & filename, eg: “C:\Temp\TableOfStuf.xls” (don’t include the quote marks. Leave this blank to be prompted for the file name.)
Set Autostart to No.

When you run the macro, it will create your file...
If the file already exists, you will be asked if you want to overwrite it.

In VB this would be:

Hi brain,
          I got ur idea and its work ,sorryi did'nt mention that i am using an front end for generating this one (i.e.)previously i am using an combo box and an command button to genetare by report to view it as report preview through an front end (From View) but i want to convert this method to export the data directlly to the excel by the same combo box & command button ... if ur not able to understand my say pls reply me....

P.A.P.Raguv