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 54
Search took 0.01 seconds.
Search: Posts Made By: BrianB
Forum: Excel VBA July 14th, 2005, 09:23 AM
Replies: 1
Views: 1,202
Posted By BrianB
You do not say exactly where your data is coming...

You do not say exactly where your data is coming from. However your general method is a bit questionable.

One way of importing data is to use the Menu Data/Get External data.

I more often use...
Forum: Excel VBA July 14th, 2005, 09:09 AM
Replies: 1
Views: 2,574
Posted By BrianB
No one can answer this because you have not shown...

No one can answer this because you have not shown the code or line it crashes on.

The proper method of writing code likely to be used in various Excel versions is to use the oldest.

MS is...
Forum: Excel VBA July 14th, 2005, 08:53 AM
Replies: 1
Views: 1,749
Posted By BrianB
There is not a lot you can do with forms other...

There is not a lot you can do with forms other than experiment with the various properties of the form and its contents.

One way of going beyond this would be to put a picture as a background. See...
Forum: Excel VBA June 6th, 2005, 10:10 AM
Replies: 1
Views: 742
Posted By BrianB
Before proceeding. If you somehow want to make...

Before proceeding. If you somehow want to make totals of the data a pivot table will do the job fast and accurately.

Here is some code to do what you asked (I think). Again, using Select is not a...
Forum: Excel VBA May 10th, 2005, 06:27 AM
Replies: 2
Views: 2,600
Posted By BrianB
You code seems to be OK. You do not mention if...

You code seems to be OK. You do not mention if sheets are deleted.

You are probably trying to delete the one remaining sheet, which is not possible. A workbook must contain at least one sheet.
...
Forum: Excel VBA April 28th, 2005, 05:37 AM
Replies: 2
Views: 1,240
Posted By BrianB
You are going to need a macro. This is a fiddly...

You are going to need a macro. This is a fiddly (although not difficult) job at best and lack of sufficient information here is a problem. No-one is going to write it for you (unless yo want to pay...
Forum: Excel VBA April 28th, 2005, 05:06 AM
Replies: 2
Views: 911
Posted By BrianB
There are several ways of managing this depending...

There are several ways of managing this depending on how you want to use the data. Such as :-

1. Data/Filter/Autofilter
2. Sort the data
3. Macro


-----------------------
Regards BrianB...
Forum: Excel VBA April 28th, 2005, 05:02 AM
Replies: 1
Views: 1,509
Posted By BrianB
You need to create an Excel application object in...

You need to create an Excel application object in Word VBA code.

Google or Word forum search for 'CreateObject' - lots of code around.

-----------------------
Regards BrianB
Most problems...
Forum: Excel VBA April 25th, 2005, 07:49 AM
Replies: 1
Views: 1,188
Posted By BrianB
Have a look at VBA 'Shell' and 'SendKeys' in...

Have a look at VBA 'Shell' and 'SendKeys' in Help. They contain an example using Calculator. We need to include Wait statements in the code to allow time for things to happen on screen because the...
Forum: Excel VBA April 22nd, 2005, 06:50 AM
Replies: 1
Views: 1,071
Posted By BrianB
Here is some code that you can amend. It shows...

Here is some code that you can amend. It shows the basic principles.

'====================================================
'- TRANSFER DATA FROM A SHEET TO MASTER
'- DEPENDING ON A CELL IN THE...
Forum: Excel VBA April 22nd, 2005, 06:26 AM
Replies: 3
Views: 705
Posted By BrianB
It is declaring a variable to be accessible to...

It is declaring a variable to be accessible to all code modules.

Not sure where you have got this because VBA nowadays uses Public instead, which allows a variable to be accessible to all code...
Forum: Access VBA January 26th, 2005, 05:07 AM
Replies: 1
Views: 2,079
Posted By BrianB
for the record :- Dim FileName As String ...

for the record :-

Dim FileName As String
FileName = Screen.ActiveDatasheet!csv_file


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup...
Forum: Access VBA January 25th, 2005, 11:36 AM
Replies: 1
Views: 2,079
Posted By BrianB
ACTIVEDATASHEET PROBLEM [SOLVED]

I am trying to use ActiveDatasheet in VBA code to access the default form that comes from doubleclicking a table name. The code to run from a button will eventually open a text file that acted as the...
Forum: Excel VBA December 15th, 2004, 11:26 AM
Replies: 1
Views: 1,398
Posted By BrianB
This is a method. However, if you want to print...

This is a method. However, if you want to print the rows Excel will put each one on a separate page. Better to hide the unwanted ones.

Sub test()
Dim PrintRange As Range
'-----------------------...
Forum: Excel VBA December 13th, 2004, 05:09 AM
Replies: 7
Views: 26,251
Posted By BrianB
Don't really know the answer, but in the absence...

Don't really know the answer, but in the absence of other replies ...
it may be that the code is running too fast for the server. Try adding a line of code after that for the connection to delay...
Forum: Excel VBA December 13th, 2004, 05:04 AM
Replies: 1
Views: 1,483
Posted By BrianB
Yes. Record a macro to see how. ...

Yes. Record a macro to see how.


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run faster.
It is easy until...
Forum: Excel VBA December 13th, 2004, 05:03 AM
Replies: 1
Views: 940
Posted By BrianB
1. Difficult to answer without knowing the...

1. Difficult to answer without knowing the questions. However I guess it would be easy to use a single text box and refresh it with the new question once one has been answered. An example of this...
Forum: Excel VBA December 13th, 2004, 04:56 AM
Replies: 1
Views: 1,914
Posted By BrianB
Open up the .idb file in Notepad to see if it is...

Open up the .idb file in Notepad to see if it is actually in a format that Excel can recognise. Otherwise most applications will export to a more common format such as .txt/.csv/.dbf etc.

...
Forum: Excel VBA December 13th, 2004, 04:53 AM
Replies: 2
Views: 1,363
Posted By BrianB
The cell needs to be formatted as General instead...

The cell needs to be formatted as General instead of Text.


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows run...
Forum: Excel VBA December 9th, 2004, 08:25 AM
Replies: 3
Views: 1,431
Posted By BrianB
I think that it is more likely that there is at...

I think that it is more likely that there is at least one #N/A in the column where the VLOOKUP() has not found a value.

If non-matches are expected then the following method puts zero instead :-...
Forum: Excel VBA December 3rd, 2004, 08:03 AM
Replies: 1
Views: 2,167
Posted By BrianB
Thereis no need to link to a .csv file. You can...

Thereis no need to link to a .csv file. You can use File/open.


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee to make Windows...
Forum: Excel VBA December 2nd, 2004, 05:50 AM
Replies: 1
Views: 6,060
Posted By BrianB
Record a macro. Right click the object to get...

Record a macro.
Right click the object to get the menu/order/bring to front


-----------------------
Regards BrianB
Most problems occur from starting at the wrong place.
Use a cup of coffee...
Forum: Excel VBA November 15th, 2004, 04:04 AM
Replies: 4
Views: 3,681
Posted By BrianB
The general method is :- 'Partial code Set...

The general method is :-

'Partial code
Set foundcell = Cells.Find(What:="PIDLDT")
foundcell.EntireColumn.Select


-----------------------
Regards BrianB
Most problems occur from starting at...
Forum: Excel VBA November 9th, 2004, 04:48 AM
Replies: 1
Views: 2,833
Posted By BrianB
I guess the way to handle this would be to...

I guess the way to handle this would be to attempt to insert a gradually increasing size string into the cell and trap any error produced.



This is true of Excel 97 but 2000 up will take more...
Forum: Excel VBA November 1st, 2004, 04:17 AM
Replies: 1
Views: 884
Posted By BrianB
Something like this :- Dim Database As...

Something like this :-

Dim Database As Worksheet
Dim LastRow As Long
Dim CustomerNumber As Long
'--------------------------
Set Database = Worksheets("DataSheet")
LastRow =...
Showing results 1 to 25 of 54

 


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


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