Please Help in creating a macro to send a module!

[access12]

Hi,

Need urgent help if possible please!

I want to create a macro to send a module, the module however must output in an excel xls version, to top it off the output must be split into different tabs of which I have already created in vba!

So I've made a macro > sendobject and argument is> Module, 0-2 Days, Excel97-Excel2003Workbook(*.xls), abc@12.com, , , days, test, No,

the 0-2 days is the file name and the email is made up for confidential reasons!

PLEASE ASSIST

[June7]

Never heard of sending a module. What do you mean by 'module' - VBA code?

You have a macro so what happens - error message, wrong results, nothing?

I don't use macros, only VBA.

[access12]

Sorry I'm such a noob! So basically I've created 4 query's, then used VBA to get these onto 1 excel file on 4 different tabs, i need to create a macro to fire this file out as one file with 4 tabs, preerably by using sendobject as i do for other files (they only have 1 tab so there straightforward)

[June7]

Can't use SendObject or TransferSpreadsheet to export multiple sheets to same workbook. Each export will be to a new workbook. Will need custom code to export data. Review http://forums.aspfree.com/microsoft-...el-413629.html