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 150
Search took 0.01 seconds.
Search: Posts Made By: Birger
Forum: Excel VBA February 24th, 2005, 03:58 AM
Replies: 7
Views: 2,114
Posted By Birger
Maybe you can get around the problem by adding...

Maybe you can get around the problem by adding the reference to the control before you reference it in your code.

Application.VBE.ActiveVBProject.References.AddFromFile...
Forum: Excel VBA February 24th, 2005, 03:03 AM
Replies: 7
Views: 2,114
Posted By Birger
What I mean is, ask them to look in the Control...

What I mean is, ask them to look in the Control Toolbox from the Excel View menu. From the extended objects they can select in the bottom item of the Toolbox menu (More controls...), they should be...
Forum: Excel VBA February 23rd, 2005, 08:06 PM
Replies: 7
Views: 2,114
Posted By Birger
Ask your Belgium colleagues to look for a...

Ask your Belgium colleagues to look for a calender control in their native language. It probably doesn't have the english name.
Forum: Excel VBA February 23rd, 2005, 03:48 PM
Replies: 6
Views: 2,069
Posted By Birger
I don't have W98 running anymore, so I can't say....

I don't have W98 running anymore, so I can't say. However, from a file point of view, if you can address the folders (Desktop or any other) from a dos-prompt, I would regard them as folders. I...
Forum: Excel VBA February 23rd, 2005, 02:30 PM
Replies: 6
Views: 2,069
Posted By Birger
Maybe FAT32 used in Win98 could be the problem....

Maybe FAT32 used in Win98 could be the problem. To my knowledge NTFS preserves the U/L case whereas FAT32 doesn't. Try change MatchTextExactly to False or change the filenames.
Forum: VB How-To February 23rd, 2005, 01:36 PM
Replies: 2
Views: 17,753
Posted By Birger
Don't know how much you need, but see if you can...

Don't know how much you need, but see if you can use any of this:

http://p2p.wrox.com/topic.asp?TOPIC_ID=13521

It's simple to use in VB. Make a new exe, add a class module, name it TC1 and add...
Forum: Excel VBA February 22nd, 2005, 03:59 PM
Replies: 5
Views: 7,325
Posted By Birger
vbaxl11.chm is available from here: ...

vbaxl11.chm is available from here:

http://www.microsoft.com/downloads/details.aspx?familyid=2204a62e-4877-4563-8e83-4848dda796e4&displaylang=en
Forum: Excel VBA February 22nd, 2005, 02:37 PM
Replies: 5
Views: 7,325
Posted By Birger
Can't you use 'vbaxl10.chm' that should come with...

Can't you use 'vbaxl10.chm' that should come with the Office installation?
Forum: VB How-To February 22nd, 2005, 03:28 AM
Replies: 7
Views: 2,483
Posted By Birger
Sorry! But try to describe which applications you...

Sorry! But try to describe which applications you are using, what you have achieved until now and if you're talking Office, post your question in a Wrox vba forum.
Forum: Excel VBA February 20th, 2005, 03:40 PM
Replies: 7
Views: 2,531
Posted By Birger
Guess it's a typo when you write you use...

Guess it's a typo when you write you use FindNext. Use 'Go to..' , select 'Special' and then choose 'Last cell'. The code equivalent is:

Selection.SpecialCells(xlCellTypeLastCell).Select

Maybe...
Forum: Excel VBA February 20th, 2005, 03:11 PM
Replies: 7
Views: 2,531
Posted By Birger
One way to do it is to save the cell-address you...

One way to do it is to save the cell-address you find with FindNext (ActiveCell) and then select from C17 to that address. Add this code to the bottom of your own code:

Dim lastCell As String...
Forum: VB How-To February 19th, 2005, 02:35 PM
Replies: 7
Views: 2,483
Posted By Birger
Looks to me as if you're using VB6!? ...

Looks to me as if you're using VB6!?

madhukp's code should work in .NET if you use '/someDirectory/file.doc' provided it's on your own machine/server.
Forum: Excel VBA February 15th, 2005, 02:36 PM
Replies: 3
Views: 1,709
Posted By Birger
Try this: "=vlookup(2, K2:M6,2)" oops!...

Try this:

"=vlookup(2, K2:M6,2)"

oops! This should do it:

Formula = "=vlookup(" & Num & ", K2:M6,2)"
Forum: Excel VBA February 14th, 2005, 11:23 AM
Replies: 2
Views: 2,070
Posted By Birger
If you want to copy a range from Excel, try...

If you want to copy a range from Excel, try change your code a little:

Sub FromWord_CopyPasteExcelRange()
Dim xlApp As excel.Application
Dim xlWkBk As excel.Workbook
Dim xlWkSht As...
Forum: Excel VBA February 14th, 2005, 11:01 AM
Replies: 2
Views: 2,070
Posted By Birger
Just make a reference to 'Microsoft Excel xx.0...

Just make a reference to 'Microsoft Excel xx.0 Object Library' from Tools-References in the VBA editor.
Forum: Excel VBA February 13th, 2005, 10:08 AM
Replies: 2
Views: 1,163
Posted By Birger
Didn't this answer help you? ...

Didn't this answer help you?
http://xtremevbtalk.com/showthread.php?s=491309ca074207f277cbf26748d0ac95&t=211056
Forum: Excel VBA February 13th, 2005, 09:06 AM
Replies: 2
Views: 1,163
Posted By Birger
Which mistakes?

Which mistakes?
Forum: Excel VBA February 12th, 2005, 07:09 AM
Replies: 3
Views: 3,324
Posted By Birger
Try some of this code - got most of it from the...

Try some of this code - got most of it from the net so it's not tested:

vb6:

Public xlApp As Object
Public xlWbk As Object

Private Sub Command1_Click()

On Error Resume Next
Forum: Excel VBA February 4th, 2005, 12:37 PM
Replies: 5
Views: 976
Posted By Birger
You don't say anything about how you determine...

You don't say anything about how you determine whether a cell value has changed or if it matters what it has been changed to and from. Do you compare with another value?

If it doesn't matter, try...
Forum: Excel VBA February 3rd, 2005, 01:19 PM
Replies: 5
Views: 976
Posted By Birger
What do you mean with 'remains the same' and...

What do you mean with 'remains the same' and 'changes'? You don't mention anything about changing the cellvalues in f2/f3, you're asking how to compare those cells and from that maybe change the...
Forum: Excel VBA January 20th, 2005, 04:22 PM
Replies: 8
Views: 1,538
Posted By Birger
You have to save the settings somewhere. The...

You have to save the settings somewhere. The easiest way to do so in to put the settings in a vacant area of a sheet, but this provides that you save your workbook before closing it. I expect you'll...
Forum: Excel VBA January 19th, 2005, 05:09 PM
Replies: 8
Views: 1,538
Posted By Birger
Hi Bruce and thanks for helping. Sometimes...

Hi Bruce and thanks for helping.

Sometimes I can be very stubborn, and I think this is one of those times. I've got some good results using a class and I'm going to pursue that approach for some...
Forum: Excel VBA January 19th, 2005, 08:24 AM
Replies: 8
Views: 1,538
Posted By Birger
I see what you mean. Only I think I'll have to do...

I see what you mean. Only I think I'll have to do a lot of coding, which is what I want to avoid.

Placing the buttons on top of each other is a question of space and design.

Disabling...
Forum: Excel VBA January 18th, 2005, 06:04 PM
Replies: 8
Views: 1,538
Posted By Birger
How to handle control properties in a form

I like to place buttons on top of each other and then use the Visible and Enabled properties to show/hide/disable them when clicking a specific button. However, as it's a pain to code in each button...
Forum: Excel VBA January 15th, 2005, 04:39 PM
Replies: 4
Views: 5,776
Posted By Birger
Didn't notice the last part of your Q. ...

Didn't notice the last part of your Q.

Hiding the userform doesn't mean you can't execute some other code. E.g. if you hide the userform by clicking a button you could code this in the button...
Showing results 1 to 25 of 150

 




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