some users do their jobs in excel files and send me every day (putting them to previously defined folder). I wrote VBA code, which takes data from all of them and combin into one data file. I need the procees go without me, so I need solve this problem:
every excel file asks me for password, which I write manually. I need that the program enter the password itself.
how can I make transmission of information to newly opened excel files form? (to its text boxes).
every excel file asks me for password, which I write manually. I need that the program enter the password itself.
how can I make transmission of information to newly opened excel files form? (to its text boxes).
