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 | 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 26
Search took 0.01 seconds.
Search: Posts Made By: zone
Forum: Excel VBA September 4th, 2007, 11:59 AM
Replies: 4
Views: 1,041
Posted By zone
I understood that. That was not what I meant. ...

I understood that. That was not what I meant.
Thanks for your feedback.
Cheers
Forum: Excel VBA September 4th, 2007, 11:50 AM
Replies: 2
Views: 1,671
Posted By zone
Just to separate each field of data, another word...

Just to separate each field of data, another word kind of delimiters.
Forum: Excel VBA August 21st, 2007, 09:03 AM
Replies: 4
Views: 1,041
Posted By zone
Thanks for your feedback. I curious what do you...

Thanks for your feedback. I curious what do you mean by “find out what the code for stuff like this is to find out how to do it manually” I was kinda looking some way of doing this using macro...
Forum: Excel VBA August 20th, 2007, 11:22 AM
Replies: 4
Views: 1,041
Posted By zone
Column color issue

When I color one particular column using fill color on the menu it does, but when I copy data from another column and paste it in previous column (which was blue) then color changed to a new one. Is...
Forum: Excel VBA August 17th, 2007, 12:30 PM
Replies: 2
Views: 1,671
Posted By zone
Copy data into cell by cell

It was little bit confusing when I explain earlier.
If anyone can give some solution using vba will be exciting for me.
Currently I am using formula which work great but when user delete or insert...
Forum: Excel VBA August 15th, 2007, 01:52 PM
Replies: 7
Views: 12,655
Posted By zone
Same as before no right click menu. Even if I...

Same as before no right click menu.
Even if I open another excel spreadsheet no right click capability unless I close the existing one.
I deleted the code still there is no right click menu.
I...
Forum: Excel VBA August 14th, 2007, 03:35 PM
Replies: 2
Views: 1,521
Posted By zone
Compute Balance

How could I compute the balance from my column P(Debit) and Column Q(Credit) into column R(Balance).
I want use vba to do that (=P1-q1). If no data then just empty space. I have 1000 rows in that...
Forum: Excel VBA August 13th, 2007, 05:18 PM
Replies: 2
Views: 1,336
Posted By zone
I dont see anything like that in vba code.

I dont see anything like that in vba code.
Forum: Excel VBA August 13th, 2007, 04:21 PM
Replies: 0
Views: 1,058
Posted By zone
Data Format Issue---need help please

Here is my problem. So any feedback from you will be a greatly appreciated.
My data is like example below.

Account Debit credit
1222 12.00
1556 345.52...
Forum: Excel VBA August 12th, 2007, 12:01 AM
Replies: 2
Views: 1,336
Posted By zone
Command button in excel sheet

I am using a command button in a worksheet.
When mouse go over that button it just move around in worksheet.
Is there way I can put command button in a one place where it doesn’t move around.
...
Forum: Excel VBA August 9th, 2007, 11:40 PM
Replies: 0
Views: 878
Posted By zone
Data rewriting/copy between worksheet

Hi
I have been doing this task for last few weeks.
If you can give me some solution to do this using VBA will be a great.

I have 2 worksheet one is JE_Input and other one Is called RawData....
Forum: Excel VBA August 9th, 2007, 12:36 PM
Replies: 7
Views: 12,655
Posted By zone
Thanks Shasur for your reply. It works great...

Thanks Shasur for your reply.
It works great for cut and copy.

I was looking for Insert and Delete.
Maybe I didn't explain enough earlier.
I use similar way, you did for delete and insert
but...
Forum: Excel VBA August 8th, 2007, 11:36 AM
Replies: 7
Views: 12,655
Posted By zone
Thanks for your feedback. I tried that ...

Thanks for your feedback.
I tried that

Application.CommandBars("CELL").Enabled = False

That disappear whole right click capability.
Is there way can I take off only Insert and Delete from...
Forum: Excel VBA August 7th, 2007, 02:53 PM
Replies: 2
Views: 1,559
Posted By zone
Tanks for your reply. Now it works only for...

Tanks for your reply.
Now it works only for date column, which is great.

If I skip a cell in a date column and point into another cell below then get error message.
1) I like to see error...
Forum: Excel VBA August 6th, 2007, 04:01 PM
Replies: 7
Views: 12,655
Posted By zone
Disable Delete and Insert capability in worksheet

In my excel worksheet I don’t want user to delete and insert row or columns (right click/delete/insert)
How could I take out that functionality from my work sheet?
Is there any way I can gray out...
Forum: Excel VBA August 4th, 2007, 10:46 PM
Replies: 2
Views: 1,559
Posted By zone
Data Validation and format

1) How could I force user to enter data (Date) in this column (Cell-) ACC-DATE) like exact same format.
2) If user keep blank in first column they will be prompt to put data in ACC-DATE cell...
Forum: Excel VBA August 2nd, 2007, 10:38 AM
Replies: 6
Views: 2,065
Posted By zone
woww that works great. Awesome. I have...

woww that works great. Awesome.

I have probably one last question to ask..
1) I want user to force enter data(Date) in this column (Cell-) ACC-DATE) like exact same format.
...
Forum: Excel VBA August 1st, 2007, 04:34 PM
Replies: 6
Views: 2,065
Posted By zone
Awesome FullSquat ;) That works great. I have...

Awesome FullSquat ;)
That works great.
I have one more question.

what do I have to do if I want to calculate another column in same worksheet. Can I use same function? How? Thanks

Batch Name...
Forum: Excel VBA July 31st, 2007, 05:07 PM
Replies: 0
Views: 1,736
Posted By zone
Ftp text file from excel worksheet

I am not sure is it possible or not.

I can save an excl work sheet as a .text or csv file using macro.
I want to ftp that text file to another location (server).
Is it possible to ftp same file...
Forum: Excel VBA July 31st, 2007, 01:26 PM
Replies: 6
Views: 2,065
Posted By zone
I appreciate your feedback. This work great but...

I appreciate your feedback.
This work great but in order to do that I need to copy/paste or type the formula in each cell I want.

Is there way I can do programmatically using vba or macro?

I...
Forum: Excel VBA July 30th, 2007, 04:57 PM
Replies: 6
Views: 2,065
Posted By zone
Cell computation using vba/Macro

Hi,
I am new in Excel. Thanks in advance for your valuable time.
I am trying to calculate Similar type of user data in a excel sheet.

Batch Name Amount Total
---------- ------ ----...
Forum: Excel VBA July 26th, 2007, 02:09 PM
Replies: 3
Views: 2,180
Posted By zone
Mike, that works fine when I use ...

Mike,
that works fine when I use
FileFormat:= xlMSDOS,

thanks
Forum: Excel VBA July 26th, 2007, 12:31 PM
Replies: 0
Views: 931
Posted By zone
EXCEL VBA ISSUE--

User will use worksheet similar to below:--- Users are allowed to enter data manually into all 6 columns(BATCH_NAME,CUR_CODE,DEPT,ACCOUNT,DEBIT,CREDIT)

BATCH_NAME| CUR_CODE| DEPT ACCOUNT|...
Forum: Excel VBA July 26th, 2007, 12:11 PM
Replies: 3
Views: 2,180
Posted By zone
Thanks Mike, That works great. But I am...

Thanks Mike,
That works great.
But I am looking just straight text (MS-dos) format.
I don't want automatically put comma (,) by system which actually
.CSV does.

Let me know if you have any...
Forum: Excel VBA July 26th, 2007, 09:40 AM
Replies: 3
Views: 2,180
Posted By zone
Converting Excel file into a text file

Hi,

How could I convert/save an excel file into a text file using macro.

Data in my Excel file has 40 to 50 rows and 15 to 20 columns.

Like below

`P` 2 02-MAY-07 02-MAY-07 ...
Showing results 1 to 25 of 26

 


All times are GMT -4. The time now is 07:15 AM.


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