Search results for query: *

Hello Friends, I have another question on Excel VBA. Our company saves file with certain information everyday in a standard format which contains the previous working date. For example today (ie 11th March) a file is saved with name in this format- Capital_2008_03_10.txt I have to develop a...

Hello Friends, I get the following error when my macro is trying to save the file in Excel 2003. It does not always give this error- at times it runs fine and at times it does not…And if the error comes and I close the excel application entirely and reopen it than the the macro runs without...

Hello, I am designing a project where I have to make a macro in excel. I have done most of it but now I am stuck at one piece and have no clue how to go about it. There are two worksheets in the file: “Prefund” and “Settled Wire” I have a macro that creates these two sheets and dumbs the data...

I need Excel vba code to divide Column G by Column H and store the values in Column I. The data looks like this Column g Column h Column i 10,000.00 23 24,750.00 25 10,200.00 26 -3,127.04 28 I am not thorough with VBA and have made an attempt to write this code after gathering pieces...

I have two different worksheets and each sheet has dates in different format. Sheet1 dates are pulled from the system and shows up as '080215 (in general format and starts with single quote because it is pulled from the system)whereas Sheet2 has date in format 7/02/2008. Here are the contents...

Hello, I am required to convert a dat file into access and structure the information as per the desired output. Initially I had thought that the file to be converted into access is in txt format and hence I wrote the complete code accordingly. I just learnt that the file will be available in...

Hello friends, I am looking for a code to pick up the date from the data set and store it in the field named as “asatdate”. This required date always appears on the third record of the data set. Would anyone be able to suggest the code to pick up the date for this absolute position of third...

The Data set I am working on has only one field ("All Data"). I want to insert a new record that reads "Balance" just above an existing record that reads "Opening Balance" I have the code for adding the record but when i run that it adds the record randomly rather than the the position that I...

Hello Friends, I am totally new to the VBA world and I am not very thorough at Access as well. I am required to create a macro in Access that can enable user to parse the data that has more than 65000 records....The data is in in raw form in txt format. The macro has to start right from...