o.k. here I go again.
I am importing text files into my vba macro with the data to be processed. I have everything on a disk (A:\). When I go to a different computer to run the macro, the program doesn't know where to find my text files.
If I show the path by: opening the spreadsheet -> file...
I created a new worksheet with the current date in a macro. With the recorder I cut and pasted data into the new sheets. But the next day when the date changes, the macro doesn't work because it identifies with the worksheet name on the date recorded
The code for the date is:
Dim a As Worksheet...
I am writing a program in VBA where I want the macro to run a daily result to create a new worksheet titled: "today's date" Orders
I know how to use the functions today() and now() within Excel, but I can't figure out the code to make it title the worksheet with the current date.
Can...
