Re: $$Excel-Macros$$ Re: Macro to generate PDF document
in the pdf writer there is thedirect options to do this. If you dont have the pdf writer , you will have to develop the pdf file format as binary file from scratch.Thats touh. On 4/9/11, ashish koul wrote: > can u attach the sample and also r u using excel 2007 > > > On Sat, Apr 9, 2011 at 3:55 PM, Simran Singh wrote: > >> >> Hello Experts, >> >> >> I have an excel sheet, wherein I have list of candidates joined in a >> particular week. Now I have to prepare their offer letter in a PDF format. >> I >> am looking for a macro which takes the name, salary and DOJ form the excel >> sheet and generate a PDF format document with the help of word document >> and >> after all these steps it create a mail and attach that pdf file in the >> mail >> . >> >> Regards, >> Simran Singh >> 9871805778 >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > P Before printing, think about the environment. > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Can We creat Auto Mailer In Excel.
Thanks a lot There is a problem to send the emails with graphics signatures , and the preset signatures are not getting into the email. Please provide some help to do macros in outlook also On Thu, Apr 7, 2011 at 11:07 AM, C.G.Kumar wrote: > Its awesome.Hats off to Ashish. > Regards, > C.G.Kumar > > > On Thu, Apr 7, 2011 at 10:35 AM, ashish koul wrote: > >> try this >> >> On Thu, Apr 7, 2011 at 9:10 AM, Harkesh Kumar >> wrote: >> >>> Hi Experts, >>> >>> >>> We required your help for creat auto mailer in excel. or any other way, >>> >>> I have to send 200 mails with different attachment. can we creat auto >>> mailer in excel thourgh macros. >>> >>> Please help me out. >>> >>> Thanx in Advance . >>> >>> >>> Regards >>> Harkesh >>> >> >> >> >> -- >> *Regards* >> * * >> *Ashish Koul* >> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >> *akoul*.wordpress.com <http://akoul.wordpress.com/> >> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> >> >> >> P Before printing, think about the environment. >> >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more tha
Re: $$Excel-Macros$$ Group Survey : Your feedback is important
Dear Ayush, Now a categorisation is very necessary where all the helps and supports recieved and asked should get categorised according to 1.Functional requirements 2.Excel Features Wise 3.Support Providerwise With the Excel Files attached in each case such that users can access the previously resolved cases togatherly in a smart way. Sanjoy Nath 09818243468 On Wed, Apr 6, 2011 at 8:46 PM, Ayush wrote: > Dear members, > > Thanks for all your contribution to group. I am very happy to see the > great participation in the group. > > For me its very important to know what you feel about the group, So that I > can take any action or initiative on the basis of your feedback. > This is an anonymous survey , so feel free to share your views and the > activities you would like to see in this group. Your valuable feedback is > highly appreciated. > > To participate in survey, Please follow the below link > http://www.surveymonkey.com/s/L8BTDNQ > > Thanks again and Keep Posting. :) > > Best regards, > Ayush Jain > Group Manager > > P.S. I send this feedback email every month. If you have already > participated , You may ignore this email. If you want to give feedback or > suggestion again, You are most welcome. > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro and you have to type the utilisation ratios and reactions beside the members including the sizes also. Have you ever calculated how much time you spend on t
Re: $$Excel-Macros$$ How to send mail with excel
This really works
One thing more.You have to keep your outlook opened to get this done
On Wed, Apr 6, 2011 at 1:32 AM, Sanjoy Nath wrote:
>
> Public olApp As Object
> Public oNewMail As Object
> Public FilePath As String
>
> Public isthereFileAttach As Boolean
> Public bd As String
> Public sb As String
>
>
>
>
>
>
> Public Sub ONE_ONE(ByVal recipient As String)
>
> Set olApp = CreateObject("Outlook.Application")
> Set oNewMail = olApp.CreateItem(olMailItem)
>
> With oNewMail
> .Display
> .Recipients.Add recipient
> sb = Sheet1.Cells(13, 3)
> .Subject = sb
>
> bd = Sheet29.Cells(1, 3)
> If bd = "" Then
> ' bd = Sheet1.Shapes("TextBox 1").Select
> bd = Sheet29.Cells(1, 3)
> End If
>
> .Body = bd
> If isthereFileAttach Then
> .Attachments.Add FilePath
> End If
>
> .Send
> End With
> Set oNewMail = Nothing
> Set oApp = Nothing
>
> End Sub
>
> Public Sub send_oneone()
>
> UserFormTITLE.Show
>
> isthereFileAttach = True
>
> For r = 2 To 100 Step 1
>
>
>If Len(Trim(Sheet29.Cells(r, 2))) > 3 Then
>
>
> If Mid(Sheet1.Cells(15, 3), 3, 1) = "\" Then
> FilePath = Sheet29.Cells(15, 3)
> Else
> isthereFileAttach = False
> End If
>
>
>
> Call ONE_ONE(Trim(Sheet29.Cells(r, 2)))
>
>End If
>
>
> Next r
> End Sub
>
>
> Sub send_to_all_oneone()
> Call Sheet29.send_oneone
> End Sub
>
>
>
> On Tue, Apr 5, 2011 at 5:09 AM, santosh subudhi <
> santoshkumar.subu...@gmail.com> wrote:
>
>> Hi,
>>
>>
>> http://www.rondebruin.nl/sendmail.htm
>>
>> http://msdn.microsoft.com/en-us/library/aa203718(office.11).aspx
>>
>>
>> http://msdn.microsoft.com/en-us/library/aa203718(office.11).aspx#odc_thesendmail20utility
>>
>> Try the other links with other options available in the sites
>>
>> Regards
>> Santosh
>>
>>
>> On Wed, Mar 30, 2011 at 12:31 PM, L.K. Modi wrote:
>>
>>>
>>>
>>> this add in is not working
>>>
>>>
>>>
>>>
>>>
>>> On Wed, Mar 30, 2011 at 10:42 AM, ashish koul wrote:
>>>
>>>> try this addin see if it helps
>>>>
>>>> http://www.rondebruin.nl/mail/add-in.htm
>>>>
>>>>
>>>>
>>>>
>>>> On Tue, Mar 29, 2011 at 8:02 PM, shariq khan wrote:
>>>>
>>>>> Can any one help me?
>>>>>
>>>>>
>>>>>
>>>>> I looking for code to send an email from excel to the number of users,
>>>>> few in TO and some are on CC.
>>>>>
>>>>>
>>>>>
>>>>> I also need to add the below table in the body of the mail looks like
>>>>> the below example
>>>>>
>>>>>
>>>>>
>>>>> _
>>>>> Hi,
>>>>>
>>>>>
>>>>>
>>>>> Please find the attached score if the candidates
>>>>>
>>>>>
>>>>>
>>>>> *Name*
>>>>>
>>>>> *Marks1*
>>>>>
>>>>> *Marks2*
>>>>>
>>>>> *sum*
>>>>>
>>>>> *SK*
>>>>>
>>>>> *75*
>>>>>
>>>>> *75*
>>>>>
>>>>> *150*
>>>>>
>>>>> *RL*
>>>>>
>>>>> *25*
>>>>>
>>>>> *25*
>>>>>
>>>>> *50*
>>>>>
>>>>> *NM*
>>>>>
>>>>> *85*
>>>>>
>>>>> *85*
>>>>>
>>>>> *170*
>>>>>
>>>>> *HL*
>>>>>
>>>>> *25*
>>>>>
>>>>> *25*
>>>>>
>>>>> *50*
>>>>>
>>>>>
>>>>>
>>>>> Please let me know if you have any concerns
>>>>>
>>>>>
>>>>>
>>>>> Thanks
>>>>>
>>>>> Shariq
>>>>>
>>>>>
>>>>> _
>>>>>
>>>>>
>>>>>
>>>>> And we ha
Re: $$Excel-Macros$$ How to send mail with excel
pot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>> >>> >>> >>> -- >>> *Regards* >>> * * >>> *Ashish Koul* >>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >>> *akoul*.wordpress.com <http://akoul.wordpress.com/> >>> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> >>> >>> >>> P Before printing, think about the environment. >>> >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Regards > Santosh > santoshkumar.subu...@gmail.com > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to
Re: $$Excel-Macros$$ Multi User in Excel file
No Sharing Dows not Work. You have to Create the Database kind of thing you have to get the data and read the data through ODBC or through the get external Data->Synchronise On Fri, Mar 25, 2011 at 10:17 PM, SAJID MEMON wrote: > Dear Dilipji & Thamuji > As per your opinion i had done, but when i save the file on > that time all data comes. I want when 1st your type 2nd user see that data > as chatting wise. > > Give me tips > Awaiting > Sajid Memon > > -- > Date: Fri, 4 Mar 2011 17:19:02 +0530 > Subject: Re: $$Excel-Macros$$ Multi User in Excel file > From: sanjoy.nath...@gmail.com > To: excel-macros@googlegroups.com > > > Sometimes that also does not work > then with the macro we need to create a copy of the file and relocate the > path to new file > > > > On Mon, Feb 28, 2011 at 1:54 PM, §»VIPER«§ wrote: > > Sajid > > Tools > Share Workbook > > > -- > *Thanks & Regards > > Thamu > * > > > > On Sun, Feb 27, 2011 at 10:38 PM, Dilip Pandey wrote: > > Hi Sajid, > > Yes, it can be done. > Share your file and provide the LAN path of the file to all the > respective users. Sharing of the file (workbook) will allow all the > users to enter data in the file at the same time. > Other options for customization and security would be to allow users > to edit ranges. > > > Best Regards, > DILIPandey > > On 2/26/11, SAJID MEMON wrote: > > > > Dear All Experts, > > > > I have LAN in my office and want to type in a excel file (Example : > abc.xls) > > data. Can other person type in same file entering data like Multi User. > > > > Plz give me tips > > > > awaiting your positive responce. > > > > Regards > > > > Sajid Memon > > > > > > -- > > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials at http://www.excel-macros.blogspot.com > > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > > http://www.facebook.com/discussexcel > > > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY, mvp > MBA,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > > > * > * > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > > -- > Your Sincerely > Sanjoy
Re: $$Excel-Macros$$ Re: hello all, its very urgent;;;
great On Wed, Mar 23, 2011 at 3:22 PM, Bhushan Sabbani wrote: > Dear Vijay, > > Please visit the site http://chandoo.org there is great dashboard along > with the tip and trick for preparing the same. > > > Warm Regards > Bhushan Sabbani > +91 98208 26012 > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro and you have to type the utilisation ratios and reactions beside the members including the sizes also. Have you ever calculated how much time you spend on that and how much errorprone are these ?? We can help you in these matters also. We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide tools to you which will read the data from your dimensions in specific layer and will type them in the excel format.And can prepare the drawings of some other feature from the extracted dimensions. We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for MIS purposes and the custom checking tools for word processing industries/Quality control departments. We have given you the examples with CAD and Excel Only.But we have expertise in STAAD Pro ,TEKLA PDF technologies also.We work in the digitisation works also. -- -- Some important lin
Re: $$Excel-Macros$$ Is there any carrer in excel.
great scopes Excel breaks all Domains and enters everywhere On Tue, Mar 22, 2011 at 2:37 PM, Bhushan wrote: > Dear Expert, > > 1. Is there any carrer in excel,This there good demand for excel > knowledge in reputed company. > 2. Is any scope in further growth as MIS. > 3. Is there any course or institute related to MIS. > 4. Because i am in MIS feild for prv 1.5 years the above question > have asked often to myself that i am not wasting thetime after MIS. > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro and you have to type the utilisation ratios and reactions beside the members including the sizes also. Have you ever calculated how much time you spend on that and how much errorprone are these ?? We can help you in these matters also. We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide tools to you which will read the data from your dimensions in specific layer and will type them in the excel format.And can prepare the drawings of some other feature from the extracted dimensions. We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for MIS purposes and the custom checking tools for word processing industries/Quality control departments. We have given you the examples with CAD and Excel Only.But we
Re: $$Excel-Macros$$ Playing Gif files in excel
On Fri, Mar 11, 2011 at 5:05 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Sanjoy, > > Thanks for your early reply. > > Can you tell me how can I add the Gif file in Html and insert the same into > the sheet. > > Regards > Santosh > On Fri, Mar 11, 2011 at 11:48 AM, Sanjoy Nath > wrote: > >> >> add the gif file in html and insert that html file to the sheet >> >> >> On Thu, Mar 10, 2011 at 11:00 PM, santosh subudhi < >> santoshkumar.subu...@gmail.com> wrote: >> >>> Hi, >>> >>> Can anyone help me in playing a gif file in excel >>> >>> I am using excel 2003 and 2007 version. >>> >>> I want to play a gif file in worksheet and in userform both. >>> >>> -- >>> Regards >>> Santosh >>> santoshkumar.subu...@gmail.com >>> >>> -- >>> >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> Your Sincerely >> Sanjoy Nath >> Engineer >> EOL Gurgaon >> EOL/M/NZ/Engg.Dept.(Haryana Division) >> >> >> >> We prepare custom tools (Softwares) to prepare Autocad Drawings >> Of the Engineering Components.Some Of Our Clients Provide the >> Design Calculation Steps And Sample Drawings (Templates for Eg the >> Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, >> Layouting, General Engineering Components , Mechanical Engineering >> Components, >> Civil/Structural Engineering Components,Architectural Components) to >> follow >> and to meet their standards and specifications.The Tools we develop are >> entirely customised and specific for clients own requirements and >> they are not re distributed to others. >> >> Let me be precise regarding our job profile and what we can do for you >> Suppose you have to develop any design component repeatedly for different >> projects >> Only Some of its parameters are changing and you need the drawing for that >> component. >> you cannot prepare the block for that.Since even in the custom Block in >> Autocad you >> cannot controll all the parameters automatically and very few users in >> Autocad can follow >> the technicalities to handle the customisable blocks in Autocad. >> On the Other hand , customisable blocks cannot decide the dimensions by >> themselves nor can >> compute the design calculations.But And it takes a long time to develop >> the drawings. >> Moreover if there is any revision in the General Arrangement drawings or >> Facilities, >> the entire things need to change and you have to start from the scratch >> again and >> draftsman forget to change some of the dimensions or the BOQ values in the >> tables >> attached to the drawings.These things are ridiculous to your clients. >> We can understand these issues since we are in the design/Detailing and >> drafting industry >> for last 10 years and have worked for more than 6 companies(Directly as >> employee or in parttime) >> in 3 domains >> (Piping,Architecture and Structural) >> And now we have attained the expertise to develop the dxf files from >> Excel/EXE Applications. >> We can develop and provide the tools (EXE tools or Excel Files as you need >> and as much you ask for) >> to develop these drawings automatically. >> >>Suppose you want to develop the drawings of doors/Panels with some >> given features many/some of >> which will change every time from task to task or from revision to >> revision or from project to project. >> You have to revise the drawings and your draftsman/detailer will take 30 >> minutes to 1 hour to revise each
Re: $$Excel-Macros$$ Align cells with same value - vba almost working - please help
----- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro and you have to type the utilisation ratios and reactions beside the members including the sizes also. Have you ever calculated how much time you spend on that and how much errorprone are these ?? We can help you in these matters also. We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide tools to you which will read the data from your dimensions in specific layer and will type them in the excel format.And can prepare the drawings of some other feature from the extracted dimensions. We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for MIS purposes and the custom checking tools for word processing industries/Quality control departments. We have given you the examples with CAD and Excel Only.But we have expertise in STAAD Pro ,TEKLA PDF technologies also.We work in the digitisation works also. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Playing Gif files in excel
add the gif file in html and insert that html file to the sheet On Thu, Mar 10, 2011 at 11:00 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi, > > Can anyone help me in playing a gif file in excel > > I am using excel 2003 and 2007 version. > > I want to play a gif file in worksheet and in userform both. > > -- > Regards > Santosh > santoshkumar.subu...@gmail.com > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro and you have to type the utilisation ratios and reactions beside the members including the sizes also. Have you ever calculated how much time you spend on that and how much errorprone are these ?? We can help you in these matters also. We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide tools to you which will read the data from your dimensions in specific layer and will type them in the excel format.And can prepare the drawings of some other feature from the extracted dimensions. We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for MIS purposes and the custom checking tools for word processing industries/Quality control departments. We have given you the examples with CAD and Excel Only.But we have expertise in STAAD Pro ,TEKLA PDF technologies also.We work in the digitisati
Re: $$Excel-Macros$$ Extracting address from a file
no sample is there. One thing more , for this , we can use the formula like =indirect(Address(row,column) and no things like macro is necessary for all kinds of transformations On Wed, Mar 9, 2011 at 10:41 PM, CAN wrote: > First of all, thank you for all the help that I received so far. You > guys are great. > > Today I have the following problem. I have a file where all the data > is on column A. The data is listing the name of a person in row 1, > in row 2 and row 3 it list the address. > > from the sample below I like to re-arrange the data so row 1 will be > left as is on column A, row 1. The information on column A, row 2 > moves to column B, row 1, and finally the data on column A, row 3 > moves to column C, row 1. After that the process loops to populate > row 2, row 3, etc, etc. > > See below how the data is now > > 1 7461-001 M Y Y JOSEPH LOPEZ 12 $111.25 01/01/09 $25.00 09 > 17921 NW 79 CT > MIAMI FL 33015 > 2 7461-002 M Y Y ESPERANZA DIAZ 12 $111.25 01/01/09 $25.00 > 7461 NW 175 ST. > MIAMI FL 33015 > 3 7461-003 M Y Y BERNARDO ARAUJO 12 $111.25 01/01/09 $25.00 > 7461 NW 176 TERR > MIAMI FL 33015 > 4 7462-004 M Y Y JUAN AMAT 12 $111.25 01/01/09 $25.00 09 DAY > 7462 NW 175 ST. > MIAMI FL 33015 > > This is how I need it to be > > 1 7461-001 M Y Y JOSEPH LOPEZ 12 $111.25 01/01/09 $25.00 09 DAYS > 17921 > NW 79 CTMIAMI FL 33015 > 2 7461-002 M Y Y ESPERANZA DIAZ 12 $111.25 01/01/09 $25.00 09 DAYS > 7461 NW 175 ST. MIAMI FL 33015 > 3 7461-003 M Y Y BERNARDO ARAUJO 12 $111.25 01/01/09 $25.00 09 DAYS > 7461 NW 176 TERRMIAMI FL 33015 > 4 7462-004 M Y Y JUAN AMAT 12 $111.25 01/01/09 $25.00 09 DAYS 7462 NW > 175 ST. MIAMI FL 33015 > > > I have attached a sample file for illustrations. On sheet 1 is the > original file, and on sheet 2 is how I need to file to be. Notice > that you will be able to identify the first row of each record because > it contains a numerical indicator starting a 1. In other words. 1 > space, 2 space, 3 space, 4 space, etc, etc. > > I am sending a file with the name extract-address.xls > > Thank you in advance for all the help > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(D
Re: $$Excel-Macros$$ Help in Excel
find the file it is done On Wed, Mar 9, 2011 at 4:04 PM, Rajiv Kumar wrote: > > > -- > *Thanks & Regards > > * > *Rajiv Kumar > * > *Mawana Sugar Works, Mawana > * > *Mo.No: 09027414899* > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro and you have to type the utilisation ratios and reactions beside the members including the sizes also. Have you ever calculated how much time you spend on that and how much errorprone are these ?? We can help you in these matters also. We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide tools to you which will read the data from your dimensions in specific layer and will type them in the excel format.And can prepare the drawings of some other feature from the extracted dimensions. We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for MIS purposes and the custom checking tools for word processing industries/Quality control departments. We have given you the examples with CAD and Excel Only.But we have expertise in STAAD Pro ,TEKLA PDF technologies also.We work in the digitisation works also. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : ht
Re: $$Excel-Macros$$ how to increse rows in excel 2007 from 65 k to more
you can do it from registry On Mon, Mar 7, 2011 at 4:06 PM, dpk wrote: > how to increse rows in excel 2007 from 65 k to more > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro and you have to type the utilisation ratios and reactions beside the members including the sizes also. Have you ever calculated how much time you spend on that and how much errorprone are these ?? We can help you in these matters also. We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide tools to you which will read the data from your dimensions in specific layer and will type them in the excel format.And can prepare the drawings of some other feature from the extracted dimensions. We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for MIS purposes and the custom checking tools for word processing industries/Quality control departments. We have given you the examples with CAD and Excel Only.But we have expertise in STAAD Pro ,TEKLA PDF technologies also.We work in the digitisation works also. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
Re: $$Excel-Macros$$ need help in excel - data merge acorrs columns
use concatenate function or & operator like =A1 & B1 & C1 etc On Tue, Mar 8, 2011 at 3:02 PM, sudhir kumar wrote: > Hi, > > Can u send Excel Sheet of this example. > > thanx > > > On 7 March 2011 12:17, Krish wrote: > >> Hi , >> >> I have data in row and column 1-3, and needs to club the data in >> single row and column since the data acorss three columns, >> >> Pls help me. >> >> Regards, >> Krish Kandy. >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> > Sudhir Verma > Asstt. Mngr. A/c's > 9818479722 > * > P think Before you print > * > * > ** > Life is Very beautiful !!! > * > * > ¨`•.•´¨) Always > `•.¸(¨`•.•´¨) Keep > (¨`•.•´¨)¸.•´ Smiling! > `•.¸.•´. > * > * > * > *Happy **Valentine** Day * > \ ¦ / > (ò ó) > _ ___o0o___(_)___o0o__ > ___¦_¦_¦_¦_¦ > ¦_¦_¦_¦_¦__ > ___¦_¦_¦_¦_¦ > *Drink Bear Save Water* > * > * > > -- > > ------ > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have w
Re: $$Excel-Macros$$ Multi User in Excel file
Sometimes that also does not work then with the macro we need to create a copy of the file and relocate the path to new file On Mon, Feb 28, 2011 at 1:54 PM, §»VIPER«§ wrote: > Sajid > > Tools > Share Workbook > > > -- > *Thanks & Regards > > Thamu > * > > > > On Sun, Feb 27, 2011 at 10:38 PM, Dilip Pandey wrote: > >> Hi Sajid, >> >> Yes, it can be done. >> Share your file and provide the LAN path of the file to all the >> respective users. Sharing of the file (workbook) will allow all the >> users to enter data in the file at the same time. >> Other options for customization and security would be to allow users >> to edit ranges. >> >> >> Best Regards, >> DILIPandey >> >> On 2/26/11, SAJID MEMON wrote: >> > >> > Dear All Experts, >> > >> > I have LAN in my office and want to type in a excel file (Example : >> abc.xls) >> > data. Can other person type in same file entering data like Multi User. >> > >> > Plz give me tips >> > >> > awaiting your positive responce. >> > >> > Regards >> > >> > Sajid Memon >> > >> > >> > -- >> > >> -- >> > Some important links for excel users: >> > 1. Follow us on TWITTER for tips tricks and links : >> > http://twitter.com/exceldailytip >> > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> > 3. Excel tutorials at http://www.excel-macros.blogspot.com >> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> > >> > To post to this group, send email to excel-macros@googlegroups.com >> > >> > <><><><><><><><><><><><><><><><><><><><><><> >> > Like our page on facebook , Just follow below link >> > http://www.facebook.com/discussexcel >> > >> >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY, mvp >> MBA,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > > * > * > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and
Re: $$Excel-Macros$$ Entry of more than 16 characters in a cell
Will that behave as number? that will behave as text then On Sat, Feb 26, 2011 at 8:57 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > XL has a specification limit of 15 decimal digits of precision (see > Help, "Specifications"). There's nothing you can to in XL itself to > extend the precision. There are a few add-ins around that you can Google > that claim to give up to 200 decimal digits of precision, but I haven't > tried any of them. > > > > Regards,Anil Bhange > > IP Phone - 512320 | Mobile - 90290 32123 > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Ashish Khandelwal > *Sent:* Saturday, February 26, 2011 1:31 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Entry of more than 16 characters in a cell > > > > Hi friends, > > > > > > When I enter a 16 digit number in a cell, the last digit become 0. How can > I enter a 16 or more digit number in a cell. > > > > > > Thanks & Regards, > > > > Ashish. > > > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools
Re: $$Excel-Macros$$ Problem on picking series in chart
I you hide the data columns , Excel Will not show those columns in the chart Excel Only shows the chart of visible columns and the filtered data On Sun, Feb 27, 2011 at 10:33 PM, Dilip Pandey wrote: > Hi Gaurav, > > I hv tried opening the attached file but it appears to be corrupted, > please share the xls version of this file so that Group members can > view the same. > > Best Regards, > DILIPandey > > On 2/26/11, Gaurav Ahuja wrote: > > Hi All, > > > > I am trying to construct chart with series selected from a table with > only > > selected series to be represented in chart. > > > > I tried using check-box for every series but the legend still reflects > all > > the series (including not selected series). i Hope there is a better way > to > > handle this. > > > > I have attached spreadsheet for reference (raw data and not with > > checkboxes). > > > > Please help. > > > > Thanks > > > > Gaurav > > > > -- > > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials at http://www.excel-macros.blogspot.com > > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > > http://www.facebook.com/discussexcel > > > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY, mvp > MBA,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime)
Re: $$Excel-Macros$$ Open an Excel File into its own seperate window in Excel.
This is really great. And we need to know the options for %2 %3 also in the open parameters On Sun, Feb 27, 2011 at 10:18 PM, Dilip Pandey wrote: > Hi Susan, > > Seems to be interesting issue:- > Two workarounds:- > > 1) Try closing the other Excel by key combination Ctrl + W. Also > check what happens when you are pressing Alt + F4 > > 2) Look out for the option "Windows in Taskbar", it should be there in > the "Option" dialogue box. (I am not familiar with Excel 2010, hence > can't guide you exactly where is this option) > > Best Regards, > DILIPandey > > On 2/27/11, Susan wrote: > > This isn't a Macro or VBA issue , it is a Windows XP, Excel 2010 file > > extension issue: > > > > > > > > Some time ago I found out and could configure Windows that will allow > more > > than one Excel workbook to open up in its own Excel window. Today I > cannot > > remember. nor can I find the "How To" instructions in the internet. I > have > > one Excel workbook open and want to open another workbook so it will open > in > > a separate Excel window. When I close the Excel file at the Excel Close > box > > it only closes that file and not the other Excel file I have open. Can > you > > send me the "How To" instructions? Below I did a print screen of where to > > change Excel, in Editing Action for Type: Microsoft Excel Worksheet. > > > > > > > > Description: cid:image001.jpg@01CBD5C9.84053E30 > > > > > > > > > > > > > > > > > > > > > > > > > > > > Susan > > > > > > > > -- > > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials at http://www.excel-macros.blogspot.com > > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > > http://www.facebook.com/discussexcel > > > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY, mvp > MBA,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicali
Re: $$Excel-Macros$$ income tax calculator
Thank you Nemi On Thu, Mar 3, 2011 at 12:01 PM, Nemi Gandhi wrote: > Sudhir vermaji, > > Attaached herewith income tax calculator in excel format. See if its > useful? > > -- > Nemi Gandhi > 98204 92963 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro and you have to type the utilisation ratios and reactions beside the members including the sizes also. Have you ever calculated how much time you spend on that and how much errorprone are these ?? We can help you in these matters also. We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide tools to you which will read the data from your dimensions in specific layer and will type them in the excel format.And can prepare the drawings of some other feature from the extracted dimensions. We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for MIS purposes and the custom checking tools for word processing industries/Quality control departments. We have given you the examples with CAD and Excel Only.But we have expertise in STAAD Pro ,TEKLA PDF technologies also.We work in the digitisation works also. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips t
$$Excel-Macros$$ Excel to CAD
We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro and you have to type the utilisation ratios and reactions beside the members including the sizes also. Have you ever calculated how much time you spend on that and how much errorprone are these ?? We can help you in these matters also. We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide tools to you which will read the data from your dimensions in specific layer and will type them in the excel format.And can prepare the drawings of some other feature from the extracted dimensions. We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for MIS purposes and the custom checking tools for word processing industries/Quality control departments. We have given you the examples with CAD and Excel Only.But we have expertise in STAAD Pro ,TEKLA PDF technologies also.We work in the digitisation works also. -- Your Sincerely Sanjoy Nath -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com
1.Lets Excelize 2.Lets Excel 3.ExcelStromers Only 4.ExcelStormers 5.One Stop Excel 6.ExcelAiming 7.Excelopedia On Thu, Mar 3, 2011 at 6:06 PM, Srinivasan Ethirajalu < srinivasan.ethiraj...@gmail.com> wrote: > Best use all the tags and change the tag after a week. > > On Thu, Mar 3, 2011 at 9:49 AM, Jenie wrote: > >> Hi Ayush, >> >> >> >> Welcome in Planet Excel >> >> Explore Excel Universe >> >> >> >> Planeto-Excel >> >> >> >> Universe in Excel >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *kanwaljit Singh >> *Sent:* Wednesday, March 02, 2011 2:54 PM >> >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ 22 days left - Launch of discussexcel.com >> >> >> >> Excelerator <http://en.wikipedia.org/wiki/Cryptographic_accelerator> >> >> On Tue, Feb 22, 2011 at 11:29 PM, Ayush Jain >> wrote: >> >> Dear members, >> >> I am too excited to share that discussexcel.com website development is in >> good progress and we are ready to launch the website on 4th Anniversary of >> our Google group. i.e. 16th -17th March. >> >> In the meantime, Can you advise a good tagline, punchline for website. >> >> My thoughts are : >> 1) building excel-lence >> 2) Excellence in Excel >> 3) Let's discuss and learn excel >> >> what do you think, Let me know >> >> Keep watching this space for more >> >> Regards >> Ayush Jain >> Group Manager. >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> >> >> >> >> -- >> Sincere Regards >> CA Kanwaljit Singh Dhunna >> +91-987 6739 911 >> +91-950 1031 007 >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Srinivasan Ethirajalu, > +919677042736 > > -- > > -- > Some important links for excel users: > 1.
$$Excel-Macros$$ Fwd: excel to cad
-- Forwarded message -- From: saaanjooo Date: Thu, Mar 3, 2011 at 6:09 PM Subject: excel to cad To: Excel To Cad Cc: saaanj...@gmail.com We prepare custom tools (Softwares) to prepare Autocad Drawings Of the Engineering Components.Some Of Our Clients Provide the Design Calculation Steps And Sample Drawings (Templates for Eg the Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes, Layouting, General Engineering Components , Mechanical Engineering Components, Civil/Structural Engineering Components,Architectural Components) to follow and to meet their standards and specifications.The Tools we develop are entirely customised and specific for clients own requirements and they are not re distributed to others. Let me be precise regarding our job profile and what we can do for you Suppose you have to develop any design component repeatedly for different projects Only Some of its parameters are changing and you need the drawing for that component. you cannot prepare the block for that.Since even in the custom Block in Autocad you cannot controll all the parameters automatically and very few users in Autocad can follow the technicalities to handle the customisable blocks in Autocad. On the Other hand , customisable blocks cannot decide the dimensions by themselves nor can compute the design calculations.But And it takes a long time to develop the drawings. Moreover if there is any revision in the General Arrangement drawings or Facilities, the entire things need to change and you have to start from the scratch again and draftsman forget to change some of the dimensions or the BOQ values in the tables attached to the drawings.These things are ridiculous to your clients. We can understand these issues since we are in the design/Detailing and drafting industry for last 10 years and have worked for more than 6 companies(Directly as employee or in parttime) in 3 domains (Piping,Architecture and Structural) And now we have attained the expertise to develop the dxf files from Excel/EXE Applications. We can develop and provide the tools (EXE tools or Excel Files as you need and as much you ask for) to develop these drawings automatically. Suppose you want to develop the drawings of doors/Panels with some given features many/some of which will change every time from task to task or from revision to revision or from project to project. You have to revise the drawings and your draftsman/detailer will take 30 minutes to 1 hour to revise each of these several components.We can save this valuable time for you through the tools. Moreover many a time it happens that you have to prepare the scaled drawings from the data in STAAD pro and you have to type the utilisation ratios and reactions beside the members including the sizes also. Have you ever calculated how much time you spend on that and how much errorprone are these ?? We can help you in these matters also. We can extract the data in tables/Dimensions in the Autocad Drawing to Excel (With Automations)such that you can prepare the BOQs easily.Suppose you have a drawing and the dimensions of some feature in a certain layer.We can provide tools to you which will read the data from your dimensions in specific layer and will type them in the excel format.And can prepare the drawings of some other feature from the extracted dimensions. We can develop the same kind of tools for Word ,STAAD Pro , Tekla , PDF , Excel Also which are applicable for MIS purposes and the custom checking tools for word processing industries/Quality control departments. We have given you the examples with CAD and Excel Only.But we have expertise in STAAD Pro ,TEKLA PDF technologies also.We work in the digitisation works also. Contact jhatso...@gmail.com with subject "jhatsolve" -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ how i convert pdf file to Excel using macro.
>From the Adobe Pdf File>Export >xml open excel and import that xml and done On Sat, Feb 19, 2011 at 12:47 PM, rashid memon wrote: > Dear Experts, > > i want to convert PDF file to Excel so plz provide me macro > > file is attached... > > > Looking forward to receive your kind attention. > > > Thanks & Best Regards > > Rashid Hussaini > > Email:- *mr.rashidme...@gmail.com* > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Excel Formula Help
As Your formula is circular , it will cause error Go to Excel Options>Formula>Iterations>Check the box on restart excel Error will not get there On Fri, Feb 18, 2011 at 8:33 PM, vitorjose wrote: > I prepare construction estimates and am required in some cases to add > costs for providing a performance bond. I arrive at a total price > lets say $1,000,000 then add in bond cost at $10 per thousand > (10,000). If am successful i receive a contract for 1,010,000 from my > customer. When i go to my bonding company to purchase my bond they > charge me based on the total contact amount, the bond costs me > 10,100. So you see i am 100 short from what i included in my > estimate. This doesn't seem like a big amount but when you get to > much larger projects it can be significant. At first glance this > could be done by turning on creating a circular reference and turning > on iteration. I am wondering if there is any other way of doing this > which doesn't create a circular reference. > > Thanks for your help > Victor P > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ RE: Excel graphs and formula for adding time spent
mod 60 calculations and mod 100 calculations are not same thing mathematical operators work in the mod 100 mode and time works in the mod 60 mode On Wed, Feb 16, 2011 at 2:38 AM, Prakash Gusain wrote: > Dear Vinod, > > The sum formula is giving correct solution if you mean by 0:20 mins. > Kindly explain where are you facing the issue or why do you think the sum > for 4:30 is not correct. > > -- > Best Regards! > Prakash Singh Gusain > > *Please visit my blog (**click here <http://prakashgusain.blogspot.com/>** > )* > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Excel intrinsic constants/enumerations
Please provide the file and what you want. We can help better On Wed, Feb 16, 2011 at 2:56 AM, Jeff wrote: > Sanjoy, > > Thanks for your reply. I suspect you are saying that if I press F2 in > something like Visual Studio I will get a page come up that will show the > values for the constants/enumerations. (I'm not at a place that I can check > VS).My question may be a bit more fundamental. When I try to compile > the compiler says such are not defined. So I think I need to do something > similar as C and include some header file that defines the constants. In my > research I've come across the statement Imports which might be the way but > unfortunately it did not work for me. > > Does it make sense what I'm asking? I'm sure it's simple for all the > experienced VB.NET <http://vb.net/> programmers. > > Thanks, > > Jeff > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Nedd help with product distribution in production plan
use the solver optimeser. Parameterise the weightages.If you provide me the weightages , then I can write the macro for you that will autocalculate and distribute the optimum load to each shift. On Fri, Feb 18, 2011 at 2:21 PM, pawel lupinski wrote: > Hi All, > I need to ask you for help, cos I've stacked. > > I nedd help with distribution products from schedule to different shift. > > See attachement, it will put some light on it. > > Thanks in advance > > Pawel > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ columns into rows, with a twist
nkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > P Before printing, think about the environment. > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Excel intrinsic constants/enumerations
in editor press F2 you will get all On Tue, Feb 15, 2011 at 11:13 AM, Jeff wrote: > I'm starting to write some code in VB (may end up as vbscript, or vb) and > would like to understand how the proper way to get all the internal > constants declared? A couple of examples might include xlDayofWeek or > vbCRLF. Do I include a header file that defines them for me? > > Thank for your insight? > > Jeff > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Solution required
Dear Jitender, Use the mail merge option in the word On Sat, Feb 12, 2011 at 9:38 PM, Jitender kumar wrote: > Dear Excel Gurus, > > Urgent help required from your part, Plz help me on the file attached. > Problem in file > > Thanks in advance > > Regards > > Jitender > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ removing multiple data and converting column into row
Please send the excel file. On Fri, Jan 28, 2011 at 1:31 PM, vikalp wrote: > hellow everybody, > kindly help me with the problem i am facing i want to remove > repititive record from folloeing data and get useful data for the > perpose of mailmerge example is given bellow > example data I have > a b c d > 1 x 20 35 > 1 x 25 35 > 1 x 26 145 > 1 x 35 2568 > 2 y 24 85 > 2 y 25 7431 > 2 y 620 556 > 3 z 25 451 > 3 z 25 451 > > data format I require > > a d c1 d1 c2 d2 c3 d3 c4 d4 > 1 x 20 35 25 35 26 145 35 2568 > 2 y 24 85 25 7431620 556 > 3 z 25 451 25 451 > > knly help me please > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ name
Select the Column and From Formula tab there is the name manager. [ ] kind of things are not allowed in naming On Mon, Jan 24, 2011 at 1:46 PM, airen wrote: > How do i name a column in Excel 2003. For eg in excel 2007, i have a > table named table1 having column Item...now i could name use > table1[Item] as name...but unfortunately this convention is not > applicable in Excel 2003...So is there any solution?? > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Sort
pls send your excel sheet. I can prepare the tool for you. On Sun, Dec 5, 2010 at 10:30 AM, wrote: > Pl send your excel sheet. > > Rgds > > Vaibhav J > Sent on my BlackBerry® from Vodafone > > -Original Message- > From: Dick > Sender: excel-macros@googlegroups.com > Date: Sat, 4 Dec 2010 18:41:13 > To: MS EXCEL AND VBA MACROS > Reply-To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Sort > > I have a strange sort question. In column B there is information > every > 7 rows. Then you skip 1 row (Blank) Then there is the same > information > but with different dates in the next 7 rows and so on. Is it possible > once there is information in All seven rows to delete that > information > and move everything thats below it up. Keeping everything together. > Without cut, copy and pasting. I know some VB. Thanks in advance. > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel
If you need the more shortcut then I can develop a macro for that On Wed, Sep 22, 2010 at 4:45 PM, Sanjoy Nath wrote: > Just open the notepad and find and replace all the spaces with comma > and after that close the file > and rename the file extension from .txt to .csv > > > see the magic > > reverse process to get the thing in txt again > > > ITS WILL WORK GREAT > > 2010/9/22 Abhidha Dixit > >> Dear ALL >> >> Please help how can i transpose the data from notepad to excel with the >> similar colomn gap so that when we copy this again to notebook i shall get >> the data with the samilar spaces >> >> thanks >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 7000 subscribers worldwide and receive many nice notes about >> the learning and support from the group.Let friends and co-workers know they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > > > -- > Your Sincerely > Sanjoy Nath > Engineer > EOL Gurgaon > EOL/M/NZ/Engg.Dept.(Haryana Division) > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ hi-- how to transpose data in the similar gap from notepad to excel
Just open the notepad and find and replace all the spaces with comma and after that close the file and rename the file extension from .txt to .csv see the magic reverse process to get the thing in txt again ITS WILL WORK GREAT 2010/9/22 Abhidha Dixit > Dear ALL > > Please help how can i transpose the data from notepad to excel with the > similar colomn gap so that when we copy this again to notebook i shall get > the data with the samilar spaces > > thanks > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ How to skip non working days to calculate number of days betewwn dates ??????
use networkdays function and set the holiday list in options On 2/22/10, gurumurthy sastry Kondury wrote: > > You can use the network days function. > > Please tell me if it clarifies your doubt. > > Guru > > > On Mon, Feb 22, 2010 at 5:37 PM, Abdul Rasheed wrote: > >> >> >> How to skip non working days to calculate number of days betewwn dates >> ?? >> >> Such as sunday or any vacations came between working days. >> >> >> >> Thanking You >> >> Abdul Rasheed >> >> >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our Facebook Group @ >> http://www.facebook.com/group.php?gid=287779555678 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Help: Making Scatter plot
done On 2/23/10, Sanjoy Nath wrote: > > done > > > On 2/18/10, janet dickson wrote: >> >> Hi Excel Savvy >> Help me on making a scatter plot (attached file contain raw data). >> >> It may look like am not asking too much or not reading (but not true i >> have tried to read the *F1 Help *but it was not useful) >> >> Thanks >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our Facebook Group @ >> http://www.facebook.com/group.php?gid=287779555678 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> >> > > > -- > Your Sincerely > Sanjoy Nath > Engineer > EOL Gurgaon > EOL/M/NZ/Engg.Dept.(Haryana Division) > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Scatter_Plot_Help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ I lossed my password how to recover that
se send the file I will do it On Fri, Feb 12, 2010 at 11:47 AM, Puttaswamy wrote: > Please help me friends... I need that very badly > > > On Thu, Feb 11, 2010 at 8:04 PM, Puttu wrote: > >> Hi Team, >> >> Can any hlep me how recover my password, I lossed it. If i want to >> attach let me know how can i attach to this blog? >> >> Thanks >> Putta >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,700 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > > > -- > Putta > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) plea -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ excel vba help
Dear Jason, To do this you do not need the macros Go to edit-> Fill-> Down That will work Sanjoy On Mon, Feb 8, 2010 at 3:24 AM, jason nix wrote: > I am trying to teach myself how to use the vba. I want to use a copy/paste > and loop macro for some equations. I already know how to use my formulas to > automatically calculate but I need help getting info into the right cell. > The basics of it goes like this; I want to get a number to copy to the x > cell and then copy the next number to the x cell. > 1 x > 2 > 3 > 4 > 5 > etc. > I have been looking online for three days and all of the examples that I > find do not run for one reason or another. Any plain SIMPLE explanations and > examples would help greatly. Thanks > > > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Need Help
Dear Imran Select A3 to A9 Data-> Text to Column-> Delimited-> other-> choose underscore and that will solve the issue. Sanjoy On Sun, Feb 7, 2010 at 10:40 AM, Imran khan wrote: > Dear Friends, > > Please help me for solution of attached file. I am stuck now and need your > help on this regard. > > Thanks, > > Imran Khan > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Help - Sheet protection restricts hide/unhide rows from vba code
Dear Nick , ActiveSheet.Unprotect Password:=(enter the password you need) then it will work okay On Sat, Feb 6, 2010 at 1:04 PM, Nick wrote: > Thanks for your input. i have already tried that using: > > ActiveSheet.Unprotect Password:=(password) at the start of the code > and then unprotect at the end. > > It solves the problem but when i goto "Tools > Protection > Unprotect" > while the sheet and vba password is active, it doesn't ask for a > password to unprotect the sheet. > In otherwords, if i distribute my sheet to others it functions as it > should but they can unprotect it without even needing a password. > This shouldn't happen? Any responses are welcome. > Thanks in advance. > > Nick Cui > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Converting .xlsm to .xls
Dear Harpreet , If you open the file in 2007 and File>Save As to 2003 format that will solve the issue. You can take your friends help who have 2007 Sanjoy On Sat, Feb 6, 2010 at 8:01 AM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > Hi Group, > > I work on Office 2003, and it becomes a problem to work on a xls made in > office 2007. Any ideas to convert into office 2003. Please suggest > > Harpreet Gujral > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Formula required
Dear Suresh, Please find the solution Sanjoy On Fri, Feb 5, 2010 at 5:11 PM, Sivakumar E.S wrote: > Hi > > Find attached solution for your problem. > > Regards > Sivakumar ES > > > > > > On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote: > >> Hi, >> >> I have the very large data to consolidate. To consolidate I need a >> formula. >> >> Below is the example. >> >> My Input data will be >> >> *Input* >> Hari >> Yes >> Hari >> No >> Hari >> Yes >> Hari >> No >> Hari >> No >> Girish >> Yes >> Girish >> No >> Girish >> Yes >> Girish >> Yes >> Girish >> Yes >> Girish >> No >> Girish >> No >> >> >> And output data should be >> >>*Output* Yes No Hari 2 3 Girish 4 3 >> >> If anyone know this, pls let me know >> >> >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,700 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe test_data.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Help - Sheet protection restricts hide/unhide rows from vba code
Dear Nick ,
you should use the cde to unprotect the sheet
ThisWorkbook.Unprotect (Password)
'do all your tasks
'then finally
ThisWorkbook.Protect (Password)
This will resolve your issue
Sanjoy
On Fri, Feb 5, 2010 at 5:56 PM, Nick wrote:
> Hello all,
>
> I have small problem after writing a code that hides/unhides certain
> rows based on cell with a drop down list of variables. I find that
> when i password protect the sheet and select from the drop down list,
> the rows do not get hidden according to the selected variable. So in
> essence, the protection is not allowing the vba code to hide/unhide
> rows.
>
> Example of code: Selection.Rows("40").EntireRow.Hidden = False
>
> Does anyone know how to overcome this problem? I would like to protect
> the sheet but still allow rows to hide/unhide in accordance with the
> vba code.
> I imagine the solution maybe a code which disables the password prior
> to performing the hide and then re-instating the password afterwards?
>
> Thanks in advance guys!
>
> Nick Cui
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Formula required
Please give the file attached I will make it for you. On Fri, Feb 5, 2010 at 3:32 PM, suresh k wrote: > Hi, > > I have the very large data to consolidate. To consolidate I need a formula. > > Below is the example. > > My Input data will be > > *Input* > Hari > Yes > Hari > No > Hari > Yes > Hari > No > Hari > No > Girish > Yes > Girish > No > Girish > Yes > Girish > Yes > Girish > Yes > Girish > No > Girish > No > > > And output data should be > >*Output* Yes No Hari 2 3 Girish 4 3 > > If anyone know this, pls let me know > > > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ BeforeSave - Enabling Macros
Dear Paul, If you set the important calculations with Macro , then people will become bound to enable macros.That will help you to achieve your motive. Sanjoy On Thu, Feb 4, 2010 at 9:44 PM, PWS wrote: > Interesting situtaion which I sure others have come across before. I > cannot think of a solution, I wonder if anyone else has or can? > I have the requirement to not allow a workbook to be saved if a user > has not entered information into a specified cell. > > I thought that is easy I will write a procedure which, using the > BeforeSave event checks that the criteria (the cell has the required > information) has been fulfilled and if not will cancel the save > event. I wrote a nice warning box advising the user that the workbook > could not be saved without the criteria being fulfilled and thought > that was that. > > The first user who tried this opened the workbook, did not enable > macros, and was therefore able to save the workbook without the > required information because the Before Save event did not fire > because macro had been disabled. > > I suppose I am asking is there any way to not open a work unless macro > are enabled? > > PWS > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Logical Concatenating
Dear Ramesh, Please save the file in 2003 format ans send. I will Solve the problem for you. Sanjoy On Thu, Feb 4, 2010 at 6:46 PM, Ramesh-Hyderabad wrote: > Hi Gurus, > > I have a requirement where I have to check for the minimum date and > maximum date instances for each employee and concatenate both in a > single cell as shown in spreadsheet. I have added a spreadsheet as an > illustration. > > Request you to look into it and do the needful at the earliest. > > With kind regards, > Ramesh > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ open multiple web pages in IE 7 from excel
Are you working for SEO or ADSENSE?
If so Dont do this...
Google will bann
Since Excel Macro will open the links within Seconds...
Sanjoy
On Thu, Feb 4, 2010 at 10:59 AM, sreejith k.s wrote:
> Hi sandeep,
>
> i think it is very useful one but unfortunately its not working for me,
>
> can you please help me out.
>
> thanks in advance
>
> On Wed, Jan 20, 2010 at 5:42 PM, Anil wrote:
>
>> Hi Sandeep,
>>
>> Enter all the URLs in a column and then use the below code to open all
>> the Web Pages,
>>
>> go to vba editor and go to tools->references-> check "Microsoft
>> Internet Controls"
>>
>> Dim sURL As String
>>
>>i = 1 'starting cell where URL is Entered in Column D
>>
>> do while range("D"&i).value <>""
>>sURL = Range("D"&i).Value
>>With oBrowser
>>.Visible = True
>>.Navigate sURL
>>Do Until Not .Busy And .ReadyState = READYSTATE_COMPLETE
>>'DoEvents
>>Loop
>>End With
>>MsgBox "Continue !", vbInformation
>> i = i + 1
>> Loop
>>
>>
>> On Jan 18, 11:08 pm, Sandeep Kadam wrote:
>> > Hi,
>> >
>> > I want open multiple web pages in IE 7 using excel macros.
>> >
>> > Can i use Arrays to store weblinks & for loop to move the loop to the
>> next link.
>> >
>> > I tried but its not working.
>> >
>> > Regards,
>> > Sandeep
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain @ jainayus...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,700 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ minimize a userform
Formname.hide will hide Minimisation option is not there On Thu, Feb 4, 2010 at 11:42 AM, memonkavi wrote: > dear sir > > how to minimize a userform in excel vb? > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,700 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Your Sincerely Sanjoy Nath Engineer EOL Gurgaon EOL/M/NZ/Engg.Dept.(Haryana Division) -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,700 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
