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 85
Search took 0.01 seconds.
Search: Posts Made By: maxpotters
Forum: Excel VBA January 18th, 2007, 02:02 PM
Replies: 0
Views: 1,069
Posted By maxpotters
Importing data from web using WebQuery

Hi all,

I am trying to retrieve data from the internet using the WebQuery function of Excel (Data->Import Data-> Web Query etc).
This all works fine, however I would like to retrieve data from an...
Forum: Beginning VB 6 August 25th, 2006, 04:15 PM
Replies: 3
Views: 1,262
Posted By maxpotters
Hi, The dll has code which is independent on...

Hi,

The dll has code which is independent on the executable. It does check items on the form of the executable, either in variables or arrays. I need to be able to just store/remember them, since...
Forum: Beginning VB 6 August 25th, 2006, 01:18 PM
Replies: 3
Views: 1,262
Posted By maxpotters
store variables from DLL file

Hi all,

I have created a DLL with Visual Basic 6.0. Now, when I run subroutines in this DLL from, for example, a standard EXE, all the variables used in this specific subroutine are cleared from...
Forum: Excel VBA January 4th, 2006, 02:55 PM
Replies: 2
Views: 4,306
Posted By maxpotters
Hi, I'm not sure where to download it, but...

Hi,

I'm not sure where to download it, but it comes with the Visual Basic 6.0 (this is not VBA) software.
Forum: Excel VBA January 4th, 2006, 02:51 PM
Replies: 3
Views: 3,290
Posted By maxpotters
Shell "REGSVR32.EXE /u /s """ & path & """",...

Shell "REGSVR32.EXE /u /s """ & path & """", vbMinimizedNoFocus

This works fine
Forum: Excel VBA January 2nd, 2006, 06:08 PM
Replies: 3
Views: 3,290
Posted By maxpotters
Regsvr32

Hi,

I am now trying to uninstall a DLL using the regsvr32 executable by using the Shell statement in VBA. However, when running this code
==============================================
Shell...
Forum: Excel VBA January 2nd, 2006, 05:46 PM
Replies: 1
Views: 2,399
Posted By maxpotters
Hi, For those who are interested: All...

Hi,

For those who are interested:

All DLLs should export two functions— DllRegisterServer and DllUnregisterServer. They are used to register and unregister the ActiveX component in the...
Forum: Pro VB 6 January 2nd, 2006, 05:25 AM
Replies: 2
Views: 901
Posted By maxpotters
Hi, I'm working on references myself, so I...

Hi,

I'm working on references myself, so I found this line:

ThisWorkbook.VBProject.References.Item(youritem).GUID

This will return a 16-character string
Forum: Pro VB 6 December 31st, 2005, 08:04 AM
Replies: 0
Views: 1,769
Posted By maxpotters
Object Library (VBA Excel), asking help here

Hi all,

I am having trouble with updating a reference to a DLL file programmatically. Let's call this file MYDLL.dll. I check whether MYDLL.dll is missing (i.e. IsBroken). If so, I try to remove...
Forum: Excel VBA December 31st, 2005, 08:03 AM
Replies: 1
Views: 2,399
Posted By maxpotters
Object Library

Hi all,

I am having trouble with updating a reference to a DLL file programmatically. Let's call this file MYDLL.dll. I check whether MYDLL.dll is missing (i.e. IsBroken). If so, I try to remove...
Forum: Beginning VB 6 December 25th, 2005, 03:46 AM
Replies: 1
Views: 997
Posted By maxpotters
See Excel VBA, I replied there...

See Excel VBA, I replied there...
Forum: Excel VBA December 25th, 2005, 03:43 AM
Replies: 3
Views: 16,069
Posted By maxpotters
Hi, I never used this code, but this doesn't...

Hi,

I never used this code, but this doesn't seem like a hard problem, so i tested this:

Last_Col = Cells.Find("*", SearchOrder:=xlByColumns, LookIn:=xlValues, SearchDirection:=xlNext).Column...
Forum: Excel VBA December 25th, 2005, 03:34 AM
Replies: 1
Views: 1,858
Posted By maxpotters
Hi First step: Goto Project>References and...

Hi

First step: Goto Project>References and add the "Microsoft Office Object Libary x.x" and the "Microsoft Excel Library x.x", where x.x represents your current Microsoft Office version.
...
Forum: Excel VBA December 24th, 2005, 05:44 AM
Replies: 0
Views: 2,461
Posted By maxpotters
Updating Reference

Hi all,

I am trying to update an old reference with a newer one. I also check whether the link has broken. Here is my code

---------------------------------------------------------------------...
Forum: Excel VBA October 23rd, 2005, 02:52 AM
Replies: 1
Views: 1,384
Posted By maxpotters
Hi, I would split up the first line: ...

Hi,

I would split up the first line:

CommandBars.Add(Name:="ImpactAnalysis", Temporary:=True)
CommandBars("ImpactAnalysis").Visible = True

-Max
Forum: Excel VBA October 23rd, 2005, 02:50 AM
Replies: 0
Views: 1,026
Posted By maxpotters
Error whilst DLL code completed succesfully

Hi all,

I have a problem concerning a (which seems to be) correctly made DLL routine for Excel (an ActiveX DLL made in VB6.0)
I put several messageboxes in the code to check whether there are any...
Forum: Excel VBA October 21st, 2005, 09:27 AM
Replies: 1
Views: 2,658
Posted By maxpotters
Hi, If I'm not mistaking, there is a...

Hi,

If I'm not mistaking, there is a function Worksheet_Calculate. This is ran when a recalculation occurs

maybe this helps
Forum: Excel VBA October 6th, 2005, 05:35 AM
Replies: 0
Views: 855
Posted By maxpotters
Protection method fails

Hi,

I have a problem with the following code:
mxlWorkbook.Protect Structure:=True , Windows:=True
mxlWorkbook is known, so that is not the issue. Also, when I run the DLL (where this code is put...
Forum: Excel VBA October 6th, 2005, 05:29 AM
Replies: 2
Views: 4,102
Posted By maxpotters
Hi Patrick, Goto the VB Editor. Here...

Hi Patrick,

Goto the VB Editor. Here double-click on ThisWorkbook (which can be found in the Project Explorer --View>Project Explorer).
A blank field will show up at the right. From the left...
Forum: Excel VBA October 6th, 2005, 05:26 AM
Replies: 1
Views: 1,237
Posted By maxpotters
Hi, Depending on where your data comes from,...

Hi,

Depending on where your data comes from, try this:
The subroutine below here can be made in the Sheets-code in VBE.
The worksheet must also be the sheet where the changes are made.
...
Forum: Excel VBA October 6th, 2005, 05:18 AM
Replies: 1
Views: 2,377
Posted By maxpotters
Just for the other curious ones, here is the...

Just for the other curious ones, here is the solution:

Cells.Locked = True (make all cells in the sheet locked)
Application.DataEntryMode = true

DataEntryMode makes it able to select...
Forum: Excel VBA October 6th, 2005, 05:16 AM
Replies: 1
Views: 1,111
Posted By maxpotters
Hi, Im not sure I understand this correctly...

Hi,

Im not sure I understand this correctly but let me have a try.

In sheet "B", in cell A1 type:

=IF(Sheet1!B1="tshirt",Sheet1!A2,"")

What this formula does is that it checks cell B1 in...
Forum: Excel VBA October 6th, 2005, 05:09 AM
Replies: 1
Views: 1,567
Posted By maxpotters
Hi, I have had this same problem a few...

Hi,

I have had this same problem a few months ago. My code even crashed on simple statements like Sheet1.Range("A1").Value = 12 (this due to the compilor not making visible the options)
Here is...
Forum: Excel VBA September 28th, 2005, 12:00 PM
Replies: 3
Views: 1,492
Posted By maxpotters
Hi, Try this this: replace...

Hi,

Try this this: replace ActiveSheet.Shapes("Picture" & i).visible = false with
ActiveSheet.OLEObjects("Picture" & i).Visible = True

Hope this helps
-Max
Forum: Pro VB 6 September 21st, 2005, 10:12 AM
Replies: 1
Views: 1,438
Posted By maxpotters
Hi, Ill also answer here Try setting...

Hi,

Ill also answer here

Try setting Application.UserControl = True
Showing results 1 to 25 of 85

 




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