Hi... I'm just a beginner in Excel and i have problem concerning building macros... would anyone be willing to give me few tips on how to create and a simple example of a syntax in a macro. Any help will be appreciated... :D
what do you want to know about creating macros. and are you talking VBA im guessing you are. if you need some help jst ask a specific question. im not good at giving tips but i can help for problems :)
well i will tell you how to to get to the vba stuff when i get to work today as i dont have windows or ms office on my home computers so when i get to work i will help guide you to get to the macro stuff. :)
sorry about that i got busy at work. and now i dont work till thrusday. and i wont get anytime for awhile to explain everything to you so here is a good tutorial to get you started. if you have any other questions let me know and i will try to help :) http://spreadsheets.about.com/cs/exceladvanced/a/vba1index.htm
I've got an accounting program I wrote (basically a General Ledger). I
have an option to send the postings to a spreadsheet.
I use a comma delimited file. This works fine.
The user can include up to 6 fields, the last being the amount field.
I want to be able to include a macro or something to total this last column
at the bottom of the spreadsheet, when it is imported.
Date, Journal, Reference, Description, Account, Amount
I don't send (currently) any formatting information, just a comma delimited
file with the headings as the first "record"
Got the answer (to my question above) on the PowerBasic forum
add a line
In my case whether I use F or another letter depends on how many
fields are selected by the user (amount if selected will always be last).
the 1 and 4 are replaced with beginning record number and ending record
(I actually use Val(EndRec$)-Val(BegRec$)+3
Then I simply change the width on the description and amount fields (in excel after importing) and viola.
BegRec$ is the beginning record selected by the user from the data file,
Hey, so I wanna ask how I need to create a method who will remove word if in that word is 2 same chars. Example: "Potato" in this word there is a 2 "o" chars so this word will need to be removed. "Forum" in this word there is no ...
Help! I want to create a java program that finds the highest even integer among the values entered by the user. Stop asking values when a value less than 1 have been entered. If no even integer is entered, display "No Even Integer"
I am writing a java program that needs to execute shell commands, so I wrote a function that would take the command to execute as a string (ie: "mkdir ~/Folder1") and execute that command with the shell. Here is the function:
Runtime run = Runtime.getRuntime();
Process pr = ...