Recent content by peace77

I added full path name under FileName and it resolved the problem. Thanks combo for the suggestion. Thanks, Peace

the reason I have Application.DisplayAlerts = False is to allow overwriting on the file with the same name. If I remove that it will display a dialog box asking users permission to overwrite the file. I cant specify the path name of current folder before saving as it will vary on users to users.

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 CK1999, Here are the answers to the questions 1. What version of excel? Its Excel 2003 2. Do you want a button actually on the sheet or a button on a toolbar ? Button on the sheet. Once the user enters the dates he ahs to click the button. And in the background I have to assign a...

the user will enter the dates. but we dont know what the dates will be? its going to be dynamic

Hi ck1999, We do not the value that will go in coloumn I. The user has to put that in and then that data is to be recorded in another sheet. In the above example the layout is not clear. Actually there are no values in coloumn I. Peace 77

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...

Thanks very much..I guess I am losing my sanity..

Please excuse me for my terminologies. I am trying to pick the programming lingo. I do not have a defined range and hence I can not use the Autofill method. The number of rows in coloumn G and H keeps changing and hence i was using the loop to make it dynamic. I am not sure about the INTERSECT...

Hi SkipVought , I did Data > Text to Coloumn for Sheet 1dates in YMD format and Sheet 2 dates in DMY formatand eventually results for both the sheets are generated in the same date format. Thanks for your help! I now need to figure how I can incorporate this in VBA code..Any ideas are highly...

Date Converted date in DMY Desired results 080219 2/8/19 19/02/08 080218 2/8/2018 18/02/08 080215 2/8/2015 15/02/08 080214 2/8/2014 14/02/08 080131 1/8/1931 31/01/08 080130 1/8/1930 30/01/08

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...

Hi Chance1234- I need it to be a macro because the process has to be automated and the user should not be running any of the formulas or functions to generate the final output. SkipVought- you are correct in saying that sheet 1 has strings. But I am unable to convert the phoney dates into a...

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...