Hello All,
Is it possible to do the following using Excel VBA:-
a)Open a csv file automatically (with Excel not running) at a certain time of the day (every day) and run a macro
b)The contents of Cell A1 in the file will have a Date,can the file be saved with name referenced to the Date mentioned in Cell A1 just before midnight each night
Thanks in advance
You can query it, but how do you want it to work, you'll need something to run some code in????
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Hello nathansav,
What I meant to say is this:-
If Excel wasn't open, is it possible to start Excel at a certain time of the day and open a csv file
Once the csv file was open,Run a Macro and save the file with the filename referenced to the Date mentioned in Cell A1.
Sorry for the misunderstanding.
Yes, but it will need to be done with windows scheduler, or some sort of non-excel code sitting on a machine all day every day.
I have never used the windows scheduler neither have I written any "non-excel" code. How would I go about accomplishing this?
I think it will be your administrators who will need to set that up. Non excel code, would be VB or C# through something like Visual Studio.
Would the "Non Excel" code be hard to do? I have never used Visual Studio.
If you havent used it, then i'd say it will be too hard. The code itself wont be that simple, but you dont fully understand so it will be hard to do.
Speak to your admin guys and see what you have available to use.
I will ask them to see if they can help.
Thank you very much for your feedback.
Have a great day!
No problems. They should be able to set up a scheduled opening. One thing to remember is to give ample time for the macro to process if you are also closing the book via scheduler, or you could put the closing code at the end of the macro.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks