Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 25 of 500
Search took 0.05 seconds.
Search: Posts Made By: Shasur
Forum: Excel VBA July 23rd, 2015, 10:19 PM
Replies: 2
Views: 1,638
Posted By Shasur
Hi Find method will help you to get the...

Hi

Find method will help you to get the match. If there are multiple matches please use the following

http://vbadud.blogspot.in/2007/10/excel-vba-findall-method.html?m=1
Cheers
Shasur
Forum: Excel VBA February 15th, 2015, 10:41 AM
Replies: 1
Views: 1,590
Posted By Shasur
Hi Can you try the WorksheetFunction.Sum in...

Hi

Can you try the WorksheetFunction.Sum in your VBA code

Cheers
Shasur
Forum: Excel VBA December 5th, 2014, 03:19 AM
Replies: 1
Views: 2,139
Posted By Shasur
Hello Bharat Here is a small snippet. Hope...

Hello Bharat

Here is a small snippet. Hope it helps

http://vbadud.blogspot.in/2007/08/detecting-duplicate-values-excel-vba.html

Cheers
Shasur
Forum: Excel VBA December 5th, 2014, 03:18 AM
Replies: 1
Views: 742
Posted By Shasur
Hi Did yo get a chance to try...

Hi

Did yo get a chance to try https://github.com/josh3ennett/excelFormulaUtilitiesJS

This would do the needful

Cheers
Shasur
Forum: Excel VBA December 5th, 2014, 03:16 AM
Replies: 1
Views: 570
Posted By Shasur
Hi I hope you had your hands dirty with VBA...

Hi

I hope you had your hands dirty with VBA too. The following snippet does a bit of what you want

For i = 3 To ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row
...
Forum: Excel VBA November 20th, 2014, 09:35 PM
Replies: 1
Views: 1,037
Posted By Shasur
Hi In VB you need to have this as three Add...

Hi

In VB you need to have this as three Add statements (http://msdn.microsoft.com/en-us/library/x4k5wbx4(v=vs.84).aspx)

Try if it works for you

Cheers
Shasur
Forum: Excel VBA November 19th, 2014, 02:55 AM
Replies: 7
Views: 841
Posted By Shasur
Hi Please try if the following link works...

Hi

Please try if the following link works for understanding array

http://vbadud.blogspot.in/2007/10/excel-vba-findall-method.html?m=1

Please try to download Excel VBA reference, which is...
Forum: Excel VBA November 18th, 2014, 04:49 AM
Replies: 7
Views: 841
Posted By Shasur
Hi Please use the following ...

Hi

Please use the following
http://vbadud.blogspot.in/2007/04/improve-macro-performance.html?m=1

to improve performance. At times it could cause your macro some problems

Cheers
Shasur
Forum: Excel VBA November 18th, 2014, 04:42 AM
Replies: 7
Views: 841
Posted By Shasur
Hi Bharat Can you share the error that...

Hi Bharat

Can you share the error that occurs. It should help to identify

also try if you can use Excel as a database and do a query. Since you are performing loop to find match it would...
Forum: Excel VBA November 14th, 2014, 09:06 AM
Replies: 1
Views: 582
Posted By Shasur
Hi I believe you are attempting to use a...

Hi

I believe you are attempting to use a Webmail client / trigger through Web. Can you try using Outlook etc. This will be elegant solution
...
Forum: Excel VBA November 14th, 2014, 09:01 AM
Replies: 7
Views: 841
Posted By Shasur
Hi The Cells.Find / Range.Find method is a...

Hi

The Cells.Find / Range.Find method is a good one. Here are some examples

http://msdn.microsoft.com/en-us/library/office/ff839746(v=office.15).aspx
...
Forum: Excel VBA November 14th, 2014, 08:58 AM
Replies: 2
Views: 744
Posted By Shasur
Hi You can try the following also to get the...

Hi

You can try the following also to get the last row


Cells.SpecialCells(xlCellTypeLastCell).Row

Cheers
Shasur
Forum: Excel VBA November 5th, 2014, 07:08 AM
Replies: 5
Views: 2,349
Posted By Shasur
Hi The format gets aligned to the pointed...

Hi

The format gets aligned to the pointed cell. Using.caption doesn't change the formating but this is not dynamic

Cheers
Shasur
Forum: Excel VBA November 5th, 2014, 07:05 AM
Replies: 1
Views: 585
Posted By Shasur
Hi Can you try the following ...

Hi

Can you try the following

http://stackoverflow.com/questions/20791892/excel-macro-vba-selecting-multiple-columns-and-rows-to-copy-to-new-worksheet

Cheers
Shasur
Forum: Word VBA November 4th, 2014, 01:55 AM
Replies: 2
Views: 2,121
Posted By Shasur
Hi Please try recording Macros to start with...

Hi

Please try recording Macros to start with and then understand the autogenerated code; you can pick up faster

http://msdn.microsoft.com/en-us/library/office/hh314613%28v=office.14%29.aspx
...
Forum: Word VBA November 4th, 2014, 01:51 AM
Replies: 2
Views: 3,003
Posted By Shasur
Hi Alison A small hint through Word VBA ...

Hi Alison

A small hint through Word VBA


For i = 1 To 100
Selection.TypeText Text:="VR1 Requirement " & i
Selection.TypeParagraph
Next i
Forum: Excel VBA November 4th, 2014, 01:44 AM
Replies: 5
Views: 2,349
Posted By Shasur
Hi Can you try if the following works ...

Hi

Can you try if the following works


Shp.OLEFormat.Object.Formula = "=A1"


Cheers
Shasur
Forum: Excel VBA November 4th, 2014, 01:12 AM
Replies: 1
Views: 801
Posted By Shasur
Hi The following links should give you the...

Hi

The following links should give you the much needed insight on Forms Controls in Excel
...
Forum: Excel VBA November 4th, 2014, 01:08 AM
Replies: 2
Views: 804
Posted By Shasur
Try the conditional formatting feature in Excel....

Try the conditional formatting feature in Excel. It should solve your problem (and headache :))
...
Forum: Excel VBA November 4th, 2014, 01:05 AM
Replies: 2
Views: 1,396
Posted By Shasur
Hi If you are creating the appropriate...

Hi

If you are creating the appropriate folders in the target machine it should work. Can you please check if the folders are created in the machine where you install

Also please use relative...
Forum: Excel VBA November 4th, 2014, 12:50 AM
Replies: 1
Views: 859
Posted By Shasur
Hi Can you please post the VBA code /...

Hi

Can you please post the VBA code / snippet used for this. It would really help

Cheers
Shasur
Forum: Excel VBA November 4th, 2014, 12:49 AM
Replies: 2
Views: 945
Posted By Shasur
Hi Ramya It would've been much simpler if...

Hi Ramya

It would've been much simpler if you connect from .NET to SQLServer / Oracle . Excel also does more or less the same

The following link should be useful for your requirement
...
Forum: Excel VBA November 4th, 2014, 12:42 AM
Replies: 1
Views: 1,266
Posted By Shasur
Hi Tore The reason for the error is...

Hi Tore

The reason for the error is faktura_kopi needs to have dimension

Include the following statement before the For loop and it should work

ReDim faktura_kopi(rader , kolonner )

...
Forum: Excel VBA November 3rd, 2014, 07:21 PM
Replies: 2
Views: 642
Posted By Shasur
Hi The If statement should end with "End...

Hi

The If statement should end with "End If", which is missing

Regards
Shasur
Forum: Excel VBA December 12th, 2013, 01:20 PM
Replies: 1
Views: 2,037
Posted By Shasur
Hi Can you post a sinppet from the code and...

Hi

Can you post a sinppet from the code and also the line number where the error occurs

Cheers
Shasur
Showing results 1 to 25 of 500

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.