LinkBack URL
About LinkBacks
Hi Arlu,
i am getting same error code 9 but unble to resolve the issue can you please confirm where i nedd to change in above code.
and how can i save data directly in different drive.
Hi Arlu,
i am getting same error code 9 but unble to resolve the issue can you please confirm where i nedd to change in above code.
and how can i save data directly in different drive.
In this code - change the bold sections to match your system -
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Arlu,
Thanks for your quick reply.
I tried to use your code but i didn't get what i want or unble to use it.
i want to say i am not too much proficient in VB so it my humble request to you to go through attached file.
in this file i want to consolidate individual scores(score& score 1) in total score excell sheet lets assume score file is saved in c drive and total score is saved in d drive.
How can i do this.
Your help will be too much appreciated.
Thanks
pram
If there is any data in the final score sheet, do you want it to be cleared before fresh data is input?
Hi Arlu,
Thanks for your reply.
i don't want to clear previous data, i want to save fresh data every time with every workbook in different cells.
Try this code - save it in the Final score file as per the instructions given below the code - change the highlighted sections to match your system -
Copy the Excel VBA codePlease Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button
Note: Your profile says you are using excel 2003 but the files you uploaded are of excel 2007 and above. Please change your profile info to reflect that.
Hi Arlu,
Thanks for your quick responce but
I am geting compilation error msg 9 at bold section can u please check and reply me as i am seeing u r online this time.
Please Login or Register to view this content.
Last edited by arlu1201; 03-11-2013 at 03:54 PM.
Firstly,
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
Have you changed this line CurrentFileName = Dir(myPath & "\*.xlsx") in your code?
Hi Arlu,
Sorry for my mistake, i am new on this forum.
Yes i have already changed it but still i am getting error if you will change the coding in my attached excel sheet it will be very beneficial for me.
You do not need to change this line CurrentFileName = Dir(myPath & "\*.xlsx").
The only line you need to change is myPath = "B:\Test"
Hi Arlu,
i am getting same error msg when i am running this macro its open only score excel file.
after that i get error msg 9
Error msg 9 on which line?
Set sourceBook = Workbooks(CurrentFileName)
Replace this linewithPlease Login or Register to view this content.Please Login or Register to view this content.
Hi Arlu,
Now i am getting other error msg.
Please see attached image file.
That error shows that you do not have any .xlsx files in your folder.
If your files are 2003 version files, then change the .xlsx to .xls in that code line.
Hi Arlu,
I am using office 10 if you want any help please see my previous attached excelsheet.
Change your profile details to reflect excel 2010.
There is no problem with your file. Have you cross checked that the path in the macro matches your system where the files exist?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks