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 173
Search took 0.01 seconds.
Search: Posts Made By: maccas
Forum: Excel VBA August 3rd, 2007, 02:29 AM
Replies: 2
Views: 3,911
Posted By maccas
If its the text of the hyperlinks would a find...

If its the text of the hyperlinks would a find and replace all (Ctrl+h) not do it for you?

If its the link in the hyperlink that's got corrupted then a bit of coding would be required. Try the...
Forum: Excel VBA August 2nd, 2007, 06:31 AM
Replies: 4
Views: 1,423
Posted By maccas
Do you have ScreenUpdating set to false? This...

Do you have ScreenUpdating set to false? This will often cause the behaviour you've described for dragging the form around.

Alternatively it could just be that you computer is trying to process...
Forum: Excel VBA August 2nd, 2007, 06:12 AM
Replies: 1
Views: 3,501
Posted By maccas
Hmmm, Sounds like you've got a missing...

Hmmm,

Sounds like you've got a missing reference in your code on your friend's computer. You are quite correct that DATE is a core VBA function (part of the DateTime class) and the only time I've...
Forum: Excel VBA March 8th, 2007, 06:46 AM
Replies: 1
Views: 1,328
Posted By maccas
Why don't you try using the worksheet function...

Why don't you try using the worksheet function SUBSTITUTE instead? Worksheet functions are precomplied so tend to work quicker the UDFs

Maccas
Forum: Excel VBA March 8th, 2007, 06:29 AM
Replies: 2
Views: 1,955
Posted By maccas
This is a two part problem that relies on two...

This is a two part problem that relies on two fairly standard Excel VBA solutions. Part 1 relates to cycling through a number of workbooks to extract information, part 2 relates to e-mailing...
Forum: Excel VBA March 6th, 2007, 04:36 AM
Replies: 2
Views: 3,658
Posted By maccas
Sorry couln't get that second link to print out...

Sorry couln't get that second link to print out ok. Tkae the text from the > character and you should be ok.

Maccas
Forum: Excel VBA March 6th, 2007, 04:35 AM
Replies: 2
Views: 3,658
Posted By maccas
There's a class modules that's been written (by...

There's a class modules that's been written (by Stphen Bullen) to extend the functionality of UserForms. You can use this to chose and amend your icon amongst other things. Have a look at this post...
Forum: Excel VBA February 6th, 2007, 02:12 PM
Replies: 8
Views: 33,954
Posted By maccas
Well then, I'm a bit confused as that command...

Well then, I'm a bit confused as that command always works for me. I'm not 100% sure you've got the reference linked up ok but it sounds like you've done it right. Forgive me if this is preaching to...
Forum: Excel VBA February 6th, 2007, 09:06 AM
Replies: 8
Views: 33,954
Posted By maccas
Have you added the reference?

Have you added the reference?
Forum: Excel VBA February 1st, 2007, 07:41 AM
Replies: 3
Views: 11,145
Posted By maccas
Use the worksheet function SUMIF. have a look in...

Use the worksheet function SUMIF. have a look in help (F1) if you don't know how to use it.

Maccas
Forum: Excel VBA February 1st, 2007, 07:08 AM
Replies: 8
Views: 33,954
Posted By maccas
Sorry - should have said that you need to add a...

Sorry - should have said that you need to add a reference to "Microsoft Shell Controls and Automation" (Tools -> References... in the VBE)

Maccas
Forum: Excel VBA February 1st, 2007, 06:47 AM
Replies: 6
Views: 1,197
Posted By maccas
I think that you don't need the else statement...

I think that you don't need the else statement where you've put it. This is because the code in this pursuant section will only fire off when Available.Text does not equal "yes" whereas the...
Forum: Excel VBA January 30th, 2007, 10:12 AM
Replies: 8
Views: 33,954
Posted By maccas
Dim dblShellRetn As Double dblShellRetn =...

Dim dblShellRetn As Double

dblShellRetn = Shell("y:/my documents/simulator.sas", vbNormalFocus)
Forum: Excel VBA January 30th, 2007, 04:28 AM
Replies: 1
Views: 1,523
Posted By maccas
Dmitri, If its a non-MS app then I'm...

Dmitri,

If its a non-MS app then I'm guessing that it doesn't expose an object model to allow you to automate it? Casting that option aside the only sensible suggestion I can come up with is to...
Forum: Excel VBA January 29th, 2007, 04:34 AM
Replies: 2
Views: 889
Posted By maccas
Excuse me if you've already got this one cleared...

Excuse me if you've already got this one cleared up but you can solve the problem with Excel worksheet formulae alone - no need for VBA. Just type the following in cell A3:

=MAX(A1-15,0)

HTH,...
Forum: Excel VBA January 18th, 2007, 10:12 AM
Replies: 8
Views: 1,774
Posted By maccas
You can't do that - to the best of my knowlegde -...

You can't do that - to the best of my knowlegde - without going into the WinAPI, a nasty horrible place that's best avoided unless really necessary. Even then I wouldn't be sure of quite how to go...
Forum: Excel VBA January 18th, 2007, 09:31 AM
Replies: 8
Views: 1,774
Posted By maccas
Sorry - written at speed. You can drop the dim i...

Sorry - written at speed. You can drop the dim i as interger.

To add a reference you need to be in the VBE (Visual Basic Editor) then select from the menu Tools -> References... You should now...
Forum: Excel VBA January 18th, 2007, 07:58 AM
Replies: 8
Views: 1,774
Posted By maccas
s this the sort of thing you're after? NB will...

s this the sort of thing you're after? NB will need references to "Microsoft Shell Controls and Automation" and "Microsoft Internet Controls"

[code]
Sub test()

Dim shSh As Shell32.Shell
Dim...
Forum: Excel VBA January 10th, 2007, 05:25 AM
Replies: 4
Views: 4,733
Posted By maccas
The trouble with the problem as posted is that...

The trouble with the problem as posted is that it's hard to guess exactly what you mean by empty charts and exactly how you'd like to hide up the empty charts.

I've written a bit of code below...
Forum: Excel VBA January 8th, 2007, 01:28 PM
Replies: 5
Views: 6,957
Posted By maccas
Try setting Application.EnableEvents = False as...

Try setting Application.EnableEvents = False as the first line of the sub (Application.EnableEvents = True back on at the end). This will stop Excel registering events whilst you're running your...
Forum: Excel VBA January 5th, 2007, 08:50 AM
Replies: 1
Views: 835
Posted By maccas
I think you're stuck with this protection...

I think you're stuck with this protection problem. You'll have to unprotect / protect the worksheet when running the update to get it to work.

If you're worried about leaving the sheet...
Forum: Excel VBA January 5th, 2007, 08:33 AM
Replies: 2
Views: 4,517
Posted By maccas
I've heard of issues with...

I've heard of issues with Application.FileDialog(msoFileDialogSaveAs)
before. Have you tried using Application.GetSaveAsFileName instead? This will involve you extracting the requested file save...
Forum: Excel VBA January 5th, 2007, 08:20 AM
Replies: 4
Views: 2,221
Posted By maccas
As it turns out you've effectively come up with...

As it turns out you've effectively come up with the only solution to this problem.

There's a Microsoft KB article on this http://support.microsoft.com/kb/q138621/ which also provides a neat...
Forum: Excel VBA December 20th, 2006, 05:00 AM
Replies: 4
Views: 1,999
Posted By maccas
Try using late binding then. Here's a reworking...

Try using late binding then. Here's a reworking of the original post without the requirement to use references:


Sub test()

Dim strSaveFilename As String

Dim scrFSO As Object...
Forum: Excel VBA December 19th, 2006, 10:54 AM
Replies: 4
Views: 1,999
Posted By maccas
You can do this with the Scripting libaray....

You can do this with the Scripting libaray. Example as follows:


Sub test()

Dim strSaveFilename As String

Dim scrFSO As Scripting.FileSystemObject
Dim scrFile As Scripting.File
Showing results 1 to 25 of 173

 


All times are GMT -4. The time now is 06:34 PM.


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