Ohh my god!!!:)
It woks like charm!!!
Excellent link, thanks allot Mr.BOBHC(EXCEL NINJA)
but also having a problem in dependent data validation with dynamic data validation together,
i am trying but not working together.
for more information please see attachment
Note:Ref. hp to ig columns...
Hello Everyone,
Please anyone have an idea the problem i am facing how to resolve without using vba code.
For Problem Scenario Please check attachment jgp file,
now i want to do data validation list on j1 that showing 3 words (super dealer, dealer & retailer) that on selection on j1...
thanks to all,
Now my template is working nice which i wanted but not from
SecurityManager.DisableOOMWarnings = False
this code.
lastly i have downloaded 3rd party application (api function)
and now its working cool with only one click.
thanks again for support.
thanks for reply again,
here is link
https://rapidshare.com/files/2003985118/Mail_Merge_updates.xls
or
may be this one
https://rapidshare.com/files/3801969919/Mail_Merge_updates.xls
password for login: 123
password for code: alif.laila
note: please click mail merge button in which...
hello everyone
i have design one template in 2003 excel for mail merge and every thing is working fine but only one problem which i am getting is that when i try to send button in my excel so after completing full process give me warning message
A PROGRAM IS TRYING TO SEND AN EMAIL MESSAGE...
Hello Everyone,
I have seen that topic, really that presentation is very nice which shown in gif file and xls.
So here i have one issue with my sales excel file which i use to send 3 different branches on weekly bases
so how to generate same gif chart report using my sales data for 3...
Hello Everyone,
I have 2 excel files, one for weekly transfer report of branches and secound for weekly sales report òf branches. is it possible to merge two excel files based on common column barcode.
i just eager to know in excel because i can do this using sql query easily without any...
Hello Everyone,
For Example:
If today's date is 27/march/2012, so weeknum function will show you 14th week, but is there any way to show all 14th week's dates in
{workbook(1).range("A2:A8").value} field
can anyone help me to solve my problem.?
Thanks
Hello,
Thanks to all for that links which you provided me.
and about that link i already work on it.
http://www.rondebruin.nl/sendmail.htm
Thanks again.
but the problem is the thing which i want that doesn't mension here in that link and here in my excel file i wanted to design macro/vba...
Hello,
I have a 4800 email address in single excel column, so is it possible to send in outlook To: field,......?on one click of command button or something like same directly using macros.
can anyone help me ?
Thanks
Note: Actually this excel sheet usually we use for advertisment.
Hello prasad dn
here the way you explain me its very nice and draw attraction. so please could you tell me how to do this. i am very need full for this.
thanks
i have one excel file in which i have design some macro code but when i double click that file fistly ask the security warning with disable, enable and help tab.
so is it possible....? without asking me that box i want to open excel file with macros running code
how can i fix that problem...
I have design one excel file for tax calculation and in the file i used some macors code but i can't able to protect them so Can Anyone help me.? please.
Thanks
Thanks everyone for important and valueable comments.
I have used macros for input box of both the columns.
and its working very fine and good so now its fullfill my requirement now.
thanks again.
Hello............
I am working on one excel file for tax calculation purpose but i stuck on one problem.
In details/Example
i have a 3 column like a1 has percentage column, b1 has amount column and last/c1 column show total amount of consignment which we received, here what i want to do if...