Thank you very much, Nik for another great video! I'm aware you can pretty much use VBA for almost anything in Excel but this type of quick-fire tutorials are extremely useful for many of us who perhaps aren't yet "Masters" of the platform.
Dear Mr. Skoulikaris, you have no idea how motivating your comments are to me! Thank you very much and this will not be the last video you'll be getting. Cheers!
I am quite certain that it does not work if the workbook is closed. If you want to alter a closed workbook try and have a look at "Stackoverflow.com". It would take me a bit of time to make a video around this and I am currently in my exam season. However, I will keep this in mind - thank you for your input!
Thank you, I want to know how to add some value in excel every month without typing in. I want the computer to do it by itself every month. Could you show me how?
can you make a video in which one column data continuous change by time , that record we can and also time column changes according to that 2 column we can make automatically 5 min frame data in different row as open high low close that we can use in stock market
Hi Can you help on below request i have excel in one location which should be automatically update every day. after update that need to convert to csv and copy to another location. and from this location it should be copy to server location. and every day csv file needs to delete so, please advise....
Thank you Nik. Please if you could share the steps if you wanted to update 2 excel sheets which are data linked in the offline mode without opening the excel sheet and clicking the update data tab that pops up. This will help me in my work as lot of excel sheets are linked to a master sheet and opening each sheets is time consuming. Thnx once again !! cheers !
Dear Yaspal, thats surprisingly easy. You just go to the data ribbin on the top part of excel and select the button refresh data. If your CSV file has the same name as the previous on then all the data within your Excel sheet will be updated!
After saving and running the script, it runs once and then when it goes to run the second time after ten seconds has gone by, I get the following error: "Cannot run the macro ''/Users/USERNAME/Desktop/FILENAME.xlsx'!Refresh_My_Data'. The macro may not be available in this workbook or all macros may be disabled." Any ideas on how to fix this?
I searched a lot for this information and tried all the methods, but I did not find the correct solution except here.. so thank you
Oh god finally!!! A solution thats simple, straightforward and WORKS SEAMLESSLY!
Thank you thank you thank you 🙏
Thank you very much, Nik for another great video! I'm aware you can pretty much use VBA for almost anything in Excel but this type of quick-fire tutorials are extremely useful for many of us who perhaps aren't yet "Masters" of the platform.
Dear Mr. Skoulikaris, you have no idea how motivating your comments are to me! Thank you very much and this will not be the last video you'll be getting. Cheers!
Thank you Nik for this simply superb tutorial!
Thank you so much!! Havent had the time to apply this to my model but will comment if any further questions. Appreciate the help greatly.
Its a pleasure Jack! Feel free if you ever have any suggestions
Hello can you please make a video when the file is closed how to refresh automatically
that is cool, simple but useful, powerful...
Very useful, thanks
I also make video on similar subject
Thank you it worked
Great video
Well done brother
Keep it up 👍👍
Love It
Perfect the “messing link”
Hi, this is helpful. Does this script work even if Excel workbook is closed? If now, what additional line of code should I consider? Thx.
I am quite certain that it does not work if the workbook is closed. If you want to alter a closed workbook try and have a look at "Stackoverflow.com". It would take me a bit of time to make a video around this and I am currently in my exam season. However, I will keep this in mind - thank you for your input!
Hello do you know how to do it when workbook is closed can you help me
Hi
I'm trying to automate the publish and refreshing action buttons in team ribbon, can you suggest the macro for this..?
Thank you, I want to know how to add some value in excel every month without typing in. I want the computer to do it by itself every month. Could you show me how?
good.
Sir, Please Guide me how to refresh for interval of 10 Seconds.
good evening, how do I update external links in excel with vba, through a button?
can you make a video in which one column data continuous change by time , that record we can and also time column changes according to that 2 column we can make automatically 5 min frame data in different row as open high low close that we can use in stock market
Hi Can you help on below request
i have excel in one location which should be automatically update every day.
after update that need to convert to csv and copy to another location. and from this location it should be copy to server location. and every day csv file needs to delete so, please advise....
does this update when we want to delete previous data from the chart? and to get update automatically?
It works when cells are updated. Thus, if a data range for a chart changes, the cells should also change, thus triggering the updating function in vba
@@FinanceNik so thats possible on function vba only right
@@Explorer_00-p5n yes, exactly
Thank you Nik. Please if you could share the steps if you wanted to update 2 excel sheets which are data linked in the offline mode without opening the excel sheet and clicking the update data tab that pops up. This will help me in my work as lot of excel sheets are linked to a master sheet and opening each sheets is time consuming. Thnx once again !! cheers !
Hey Yusuf, I will try to get back to you about this!
We need to keep update data from the CSV file into excel sheet. how we can do that can you explain.
Dear Yaspal, thats surprisingly easy. You just go to the data ribbin on the top part of excel and select the button refresh data. If your CSV file has the same name as the previous on then all the data within your Excel sheet will be updated!
After saving and running the script, it runs once and then when it goes to run the second time after ten seconds has gone by, I get the following error: "Cannot run the macro ''/Users/USERNAME/Desktop/FILENAME.xlsx'!Refresh_My_Data'. The macro may not be available in this workbook or all macros may be disabled." Any ideas on how to fix this?
Even I'm facing the same difficulty. The macro runs only once and after that I get similar message when the second sub kicks in
Hey Alex, I have not encountered this Error before, but I will take a look at it and report back!
@@FinanceNik Jus move the code to new module. Error gone :)