Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 500
Search took 0.10 seconds.
Search: Posts Made By: Shasur
Forum: Excel VBA July 23rd, 2015, 11:19 PM
Replies: 2
Views: 1,148
Posted By Shasur
Hi Find method will help you to get the match....

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,311
Posted By Shasur
Hi Can you try the WorksheetFunction.Sum in your...

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: 1,806
Posted By Shasur
Hello Bharat Here is a small snippet. Hope it...

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: 614
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: 486
Posted By Shasur
Hi I hope you had your hands dirty with VBA too....

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
ActiveSheet.Hyperlinks.Add...
Forum: Excel VBA November 20th, 2014, 09:35 PM
Replies: 1
Views: 905
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: 766
Posted By Shasur
Hi Please try if the following link works for...

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 good...
Forum: Excel VBA November 18th, 2014, 04:49 AM
Replies: 7
Views: 766
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: 766
Posted By Shasur
Hi Bharat Can you share the error that occurs....

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 slow...
Forum: Excel VBA November 14th, 2014, 09:06 AM
Replies: 1
Views: 477
Posted By Shasur
Hi I believe you are attempting to use a Webmail...

Hi

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

Hi

The Cells.Find / Range.Find method is a good one. Here are some...
Forum: Excel VBA November 14th, 2014, 08:58 AM
Replies: 2
Views: 610
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: 1,954
Posted By Shasur
Hi The format gets aligned to the pointed cell....

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: 471
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: 1,893
Posted By Shasur
Hi Please try recording Macros to start with and...

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

should...
Forum: Word VBA November 4th, 2014, 01:51 AM
Replies: 2
Views: 2,737
Posted By Shasur
Hi Alison A small hint through Word VBA For i...

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: 1,954
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: 701
Posted By Shasur
Hi The following links should give you the much...

Hi

The following links should give you the much needed insight on Forms Controls in...
Forum: Excel VBA November 4th, 2014, 01:08 AM
Replies: 2
Views: 677
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,248
Posted By Shasur
Hi If you are creating the appropriate folders...

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 paths...
Forum: Excel VBA November 4th, 2014, 12:50 AM
Replies: 1
Views: 726
Posted By Shasur
Hi Can you please post the VBA code / snippet...

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: 820
Posted By Shasur
Hi Ramya It would've been much simpler if you...

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...
Forum: Excel VBA November 4th, 2014, 12:42 AM
Replies: 1
Views: 1,050
Posted By Shasur
Hi Tore The reason for the error is faktura_kopi...

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 )


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

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: 1,629
Posted By Shasur
Hi Can you post a sinppet from the code and also...

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

 


All times are GMT -4. The time now is 12:31 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.