Path not found, but the folders do exist
[code] Sub toPDF() ' This will copy a specified range('s) from ws1 & ws2 to ws3. ' Now you can...
I believe the problem is that you are not getting the sFileName from the original workbook. So I have added ActiveWorkbook.Save...
Hello Ready2go This may only answer some of your question. The macro below will create a PDF file of Sheet2....
Dear Hyside2, I really appreciate your cooperation and helpful answer. Thanks so much.
Try this instead =IFERROR(LEFT(B1,FIND(" ",B1)-1),B1) [img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/08/givenname.png[/img]
I am not sure if this is what you are looking for but test it out anyway. [img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/08/1-2.png[/img]...
Oh! Please try this. You will need to change "Book1" on the line that reads (oFilename="Book1") to the name of...
I frequently carry out analyses of Satisfaction Survey Data of very many people. I have a Survey Questionnaire with about 30 questions on my computer. I get each individual to complete the survey data by clicking/choosing I agree, strongly agree, disagree, etc. after which I save the document in the persons name in a folder named ‘Completed Questionnaire’.
I get another person to do the same thing after which I also save it in the person’s name.
When all my respondents have completed the questionnaire – say about 50 respondents, I then I print out each questionnaire and then enter/group the responses into a Summary Excel sheet, from which I use the COUNT function to do the analysis.
I have no problem doing the final survey analysis once the individual questionnaires have been manually entered onto the summary Excel sheet and grouped.
I need a VBA code that will be able to transfer responses from each completed questionnaire onto the Summary Excel sheet as follows, and save me the time and problem of entering the responses manually onto the Summary Excel sheet.
Once an individual completes a questionnaire and I click SAVE, the code should be able to pick the responses from that questionnaire and transfer them to the Summary Excel sheet and thereafter SAVE the completed questionnaire in a designated folder named e.g. ‘Summarized’.
I will then do the required Analysis from the Summary Excel sheet. I don’t have any problem with doing the final analysis using Excel functions.
Please share using the share button above.
If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.
Found the answer useful and wants to credit the user, then vote the answer (vote up).