Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
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 59
Search took 0.01 seconds.
Search: Posts Made By: gcianfanelli
Forum: Word VBA August 27th, 2007, 03:52 PM
Replies: 3
Views: 1,986
Posted By gcianfanelli
I think you've misunderstood how the Hyperlinks'...

I think you've misunderstood how the Hyperlinks' Add method should be used.

The first parameter (the Anchor parameter) represents the object that you want associated with a hyperlink. This can be...
Forum: Word VBA June 24th, 2007, 03:16 AM
Replies: 1
Views: 2,908
Posted By gcianfanelli
If you're happy working with .NET and are using...

If you're happy working with .NET and are using Office 2003 you could consider a VSTO addin.

Otherwise create a COM addin.

Unlike VBA addins these won't ever be disabled by holding down the...
Forum: Pro VB 6 February 7th, 2006, 07:55 AM
Replies: 2
Views: 1,361
Posted By gcianfanelli
assuming vb6, you'll need to create a wrapper...

assuming vb6, you'll need to create a wrapper class for the TextBox object. You'll need to initialise that class with the instance of your dynamically-created textbox, and then consume within it the...
Forum: C# February 2nd, 2006, 06:59 AM
Replies: 3
Views: 1,186
Posted By gcianfanelli
adam_kahtava: I don't think that's true ...

adam_kahtava: I don't think that's true

there are several attributes you can specify in order to consume your .NET assembly from COM

there are many tutuorials on the subject. Take a look at...
Forum: Pro VB 6 January 30th, 2006, 01:55 PM
Replies: 5
Views: 23,609
Posted By gcianfanelli
Dmitriy: yes this is possible In brief, in...

Dmitriy: yes this is possible

In brief, in your .NET assembly you will need to expose each class's methods and properties by marking that class with a special COM interoperable attribute.

To...
Forum: Excel VBA January 4th, 2006, 10:37 AM
Replies: 2
Views: 2,180
Posted By gcianfanelli
the Workbook event you're looking for is the...

the Workbook event you're looking for is the AddinInstall event - it gets called when the workbook is installed as an addin

in the VB ide, double-click the special "ThisWorkbook" class of your...
Forum: Excel VBA October 27th, 2005, 08:30 AM
Replies: 1
Views: 921
Posted By gcianfanelli
you've got several functions to help you. Check...

you've got several functions to help you. Check the help on how to use ISTEXT, ISNONTEXT, ISNUMBER. There's also a useful TYPE function which tells you what kind of content exists in the cell

you...
Forum: VB.NET 2002/2003 Basics September 20th, 2005, 06:12 AM
Replies: 4
Views: 8,881
Posted By gcianfanelli
The String object constructor in vb.net has 3...

The String object constructor in vb.net has 3 overloads, one of which is similar to the VB6 function

Try something like

Dim myRepeatedCharacter As String
myRepeatedCharacter = New String("A",...
Forum: Pro VB 6 August 26th, 2005, 07:26 AM
Replies: 5
Views: 3,668
Posted By gcianfanelli
In VB6 this would be possible by setting up the...

In VB6 this would be possible by setting up the label control as an array of labels (ie. lblTest(0), lblTest(1), lblTest(2), etc)

Unfortunately VBA doesn't support control arrays. To achieve this...
Forum: Excel VBA August 24th, 2005, 02:59 AM
Replies: 4
Views: 2,000
Posted By gcianfanelli
to truly add a control at runtime in VBA you need...

to truly add a control at runtime in VBA you need to execute the Add method of the UserForm object's Controls property. This method expects the ProgID of the control you want to add - something like...
Forum: Excel VBA August 8th, 2005, 07:59 AM
Replies: 4
Views: 5,332
Posted By gcianfanelli
The problem you're having is because your DLL...

The problem you're having is because your DLL doesn't know about the instance of the Excel application you want to use.

I think you have 2 options:

1. Create a COM Addin for Excel
This will...
Forum: Excel VBA August 8th, 2005, 07:17 AM
Replies: 4
Views: 5,332
Posted By gcianfanelli
try passing in the Worksheet object itself e.g. ...

try passing in the Worksheet object itself e.g.

Public Sub create(Worksheet As Excel.Worksheet)
MsgBox "message generated from VB6 DLL"
MsgBox vrble

Worksheet.Range("A1").Value = "test dll"...
Forum: Excel VBA July 21st, 2005, 03:37 AM
Replies: 2
Views: 2,763
Posted By gcianfanelli
i think you need to use the VBA Format function,...

i think you need to use the VBA Format function, something like

calEvent(0) = Format$(calEvent(0), "yyyymmdd")
Forum: XML July 6th, 2005, 09:15 AM
Replies: 2
Views: 566
Posted By gcianfanelli
You could try ActiveSheet.Rows.Clear

You could try

ActiveSheet.Rows.Clear
Forum: XML June 15th, 2005, 07:07 AM
Replies: 2
Views: 814
Posted By gcianfanelli
Yes you can: <xsl:call-template...

Yes you can:

<xsl:call-template name="MyTemplate"/>

<xsl:template name="MyTemplate">
Look its worked!
</xsl:template>
Forum: VB How-To May 10th, 2005, 02:25 PM
Replies: 1
Views: 1,218
Posted By gcianfanelli
Try http://word.mvps.org/

Try http://word.mvps.org/
Forum: VB How-To May 5th, 2005, 04:23 AM
Replies: 4
Views: 4,183
Posted By gcianfanelli
are you suggesting that the calls to create the...

are you suggesting that the calls to create the ShapeRange object are being executed hundreds of times in an interation?

I would definitely consider setting up the shape as an AutoText in the...
Forum: VB How-To May 5th, 2005, 03:39 AM
Replies: 4
Views: 4,183
Posted By gcianfanelli
I do a lot of this kind of stuff, but haven't...

I do a lot of this kind of stuff, but haven't encountered (or tried) creating shapes in Word VBA via .NET

Some immediate workarounds spring to mind:
if the shapes you're creating aren't...
Forum: VB How-To May 4th, 2005, 07:55 AM
Replies: 15
Views: 2,964
Posted By gcianfanelli
When you say "this won't work", you might want to...

When you say "this won't work", you might want to be a little bit more specific

In fact, if you're using the VB editor, your example
Replace(strString,""","'")
won't even compile and the editor...
Forum: Excel VBA May 3rd, 2005, 05:39 AM
Replies: 5
Views: 1,081
Posted By gcianfanelli
It's not needed: "Trim" on its own will do just...

It's not needed: "Trim" on its own will do just fine.

just remembered that Trim$ is technically more optimal than Trim: Trim on its own will accept a variant as a parameter, whereas Trim$ only...
Forum: Excel VBA May 3rd, 2005, 04:58 AM
Replies: 5
Views: 1,081
Posted By gcianfanelli
Use the Trim function to remove any excess white...

Use the Trim function to remove any excess white space to the left and right of the string.

I also use the Len function, rather than compare with a literal string (your zero-length string, that...
Forum: Excel VBA March 14th, 2005, 06:20 AM
Replies: 5
Views: 8,944
Posted By gcianfanelli
You can only increase the size of an array using...

You can only increase the size of an array using the Preserve keyword if you are re-sizing the last dimension of that array.

If you have VB Help installed, place your cursor on the Preserve...
Forum: Excel VBA March 6th, 2005, 01:41 PM
Replies: 6
Views: 1,431
Posted By gcianfanelli
Maybe it can't be done this way, although you...

Maybe it can't be done this way, although you could cheat and write the text to a floating text frame which is set to be the same size etc as cell A1. This still would, however, mean that the...
Forum: Excel VBA March 6th, 2005, 11:53 AM
Replies: 2
Views: 811
Posted By gcianfanelli
Declare it as a public function, or property ...

Declare it as a public function, or property

eg.

Public Property Get Wrb() As Excel.Worksheet
Set Wrb = ThisWorkbook.Sheets("Sheet1")
End Property

or
Forum: Excel VBA March 6th, 2005, 08:38 AM
Replies: 6
Views: 1,431
Posted By gcianfanelli
I use SetTimer and KillTimer API functions with a...

I use SetTimer and KillTimer API functions with a callback to my timer procedure. I haven't seen it raise an error before so you may want to use that instead

eg:

Public Declare Function...
Showing results 1 to 25 of 59

 


All times are GMT -4. The time now is 10:50 PM.


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