Now that I am at work, this doesn't even work at all know. I saved my emailed attachments to a disk on the a: drive and figured I could get it to work. But I am getting an error 5 message at: .TextFilePlatform = 437
and at .TextFileTrailingMinusNumbers = True
If I get rid of...
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...
That did it. Thanks for helping out.
I just have one more question to post and I think I have this program completed! Everyone has been great on this site.
I tried that and it does not work. I think it has to do with the name being a variable? I just can't put my finger on it. Thanks for the reply, I really appreciate it.
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...
