antoanand1981
New Member
- Joined
- Mar 20, 2012
- Messages
- 12
Hi,
Currently I've the below code which i used to send an email from Excel, However, Now I've moved the code from 2010 to 2016 and its is not working for .Publish (True). Please help
With TempWB.PublishObjects.Add( _ SourceType:=xlSourceRange, _
Filename:=TempFile, _
Sheet:=TempWB.Sheets(1).name, _
Source:=TempWB.Sheets(1).UsedRange.Address, _
HtmlType:=xlHtmlStatic)
.Publish (True)
Currently I've the below code which i used to send an email from Excel, However, Now I've moved the code from 2010 to 2016 and its is not working for .Publish (True). Please help
With TempWB.PublishObjects.Add( _ SourceType:=xlSourceRange, _
Filename:=TempFile, _
Sheet:=TempWB.Sheets(1).name, _
Source:=TempWB.Sheets(1).UsedRange.Address, _
HtmlType:=xlHtmlStatic)
.Publish (True)