Search results

Correction is to create a text file dir.txt

Hi SirJB7, Thanks for your answer. It is the solution I was looking for. In fact, it should be. By running your macro, it stops on the instruction "Open A For Input As #I" and the message "file not found" appears on the screen. As I undertand the code, the goal of the instruction "A =...

Hi the forum, I want to know the total number of files (including files in subfolders) for a given drive. The properties dialog window for a folder gives the information. Is there an Excel (64 bits) VBA solution to retrieve this information? Thanks in advance Regards Harry

Hi SirJB7, Thank you for these links. But as you pointed out, they do not relate to VBA and I do not know these other languages​​. Have a good day Harry

Hi the forum, I recently heard about violin plots. As my friend Google provides no information about it (except Wikipedia), I would knock on the door of this forum. Should a reader have an EXCEL file that would allow me to understand this technique? In advance thank you Harry

Great! Thanks for the solution. The chart is working fine when changing the start date. The suggested solution was thus to create a named range for each series. Best regards Harry Is there a procedure to declare the post as solved?

sorry for the waiting time of the response but I did not used to this kind of manipulation I created a Dropbox account and here is the link https://dl.dropbox.com/u/94100164/Sample%20file%20dynamic%20chart.xlsx Regards Harry

Hi shailyog, Thanks for the answer. Yes, I did and the chart remains unchanged. But if I re-write manually the content in the "chart data range", the chart is well updated. That 's what I call a manually dynamic chart. Regards Harry

Hi All, In an Excel chart, I want to display the data two months before and one month after an selected day. To do so, I defined some named ranges as Select_years: 'OFFSET(Sheet1!Start;0;MATCH(Sheet1!start_date;Sheet1!years;0)-1;1;MATCH(Sheet1!start_date;Sheet1!years;0)+1)' Data_product...