i used an excel files to view reports(DASHBOARD) data to system users. 11 excel files are generating by this report. currently i have to save each report separately in everyday. i just want to automate the report and send these reports to relevant user. so i want to save those files in...
I am trying to copy an excel sheet in a workbook and then rename it. I recorded the excel macro which is what I usually do and can usually slug my way until I can get it to work. But what is happening is that a new 'book1' is also being created with the copy command. So I was wondering it anyone...
Good afternoon all. I am trying to figure out how to read the sheet tab name in a workbook where the number of sheets may vary. What I want to do is to 'trim' the names so in a case if I am looking for "JULY16", and the sheet name it "JULY16 " (notice the space,) it wont crash the program. Yes...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.