Sorry VBS file could not get attached.
Copy paste the below code in a notepad and save it with extension *.VBS*
**
Dim myExcel
Set myExcel = CreateObject("Excel.Application")
myExcel.DisplayAlerts = False
myExcel.AskToUpdateLinks = False
myExcel.AlertBeforeOverwriting = False
myExcel.Workbooks
,
when you know that your system will be Switched on.
It will automatically open your excel workbook and send email.
If you need help on Scheduling the VBS file in windows let me know.
Thanks,
Vish
http://www.learnexcelmacro.com
Thanks,
Vish
--
FORUM RULES (986+ members already BANNED for
,
when you know that your system will be Switched on.
It will automatically open your excel workbook and send email.
If you need help on Scheduling the VBS file in windows let me know.
Thanks,
Vish
http://www.learnexcelmacro.com
Thanks,
Vish
--
FORUM RULES (986+ members already BANNED for
Hi Vishwa,
Hope this helps. Please let me know.
Thanks,
Vish
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
Hi Vishwa,
By Weekends you mean Saturday and Sunday or Only Sunday?
Thanks,
Vish
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
Hi,
You can put the below function any where in any of your module. It will
work same as Workbook_Open() Event.
Sub Auto_Open()
End Sub
For more detail read this:
http://www.learnexcelmacro.com/2011/12/auto-open-macro-auto-run-macro/
On Monday, June 25, 2012 1:26:16 PM UTC+5:30, Mitr wrot
Hi,
Is your table going to be the same? I mean the number of columns and rows
going to be same??
On Wednesday, June 6, 2012 12:51:31 AM UTC+5:30, Joseph wrote:
>
> Hi,
>
> I have a table and need to extract data that is non-zero.
>
> Attached is the sample file for your reference.
>
> Thanks,
>
