VBA to send a macro free version of workbook via Outlook

[daithiboy]

Hello All,

I am wondering if anyone can help to figure out how to send a macro free version of my workbook by email.

I'm not too familiar with using other applications and objects in VBA, especially if I might need to create and delete a temporary workbook.

I have seen other examples which show how to fire up Outlook and attach the workbook, but I can't find anything which sends a .xlsx instead of .xlsm.

Any help would be greatly appreciated.

Dave

 

[onlyadrafter]

Hello,

google Ron de Bruin, specifically here:

Mail the whole workbook

www.rondebruin.nl

or google - save xlsm as xlsx vba

and look at this post

xlsm file with vba code to save copy as xlsx on close

I have an xlsm file that I cannot open on excel online. So I am trying to create a code that every time I close the xlsm file it saves the information to a xlsx file that I can access on excel online. I have the following code: Sub SaveAs() Dim FName As String Dim FPath...

www.mrexcel.com

 

[daithiboy]

Hello,

google Ron de Bruin, specifically here:

Mail the whole workbook

www.rondebruin.nl

or google - save xlsm as xlsx vba

and look at this post

xlsm file with vba code to save copy as xlsx on close

I have an xlsm file that I cannot open on excel online. So I am trying to create a code that every time I close the xlsm file it saves the information to a xlsx file that I can access on excel online. I have the following code: Sub SaveAs() Dim FName As String Dim FPath...

www.mrexcel.com

Thanks a million for the links. I’ll have a go at it.