Hello,
Every month I pull a lot of financial documents off of our accounting program and then proceed to format them all in the same manner. I was trying to speed this process up by running a recorded macro. However, the issue is when I do this it becomes sheet specific. Any way of fixing this? Thanks, I am very new to macros and VBA.
This is the recorded macro below.
Please Login or Register to view this content.
Last edited by NeedhelpwithExcel2; 08-29-2017 at 03:45 PM. Reason: Added missing CODE /CODE tags, please read and follow the Forum Rules, a link to them in blue menu bar above. Thanks!
Check out this link:
https://support.office.com/en-us/art...1-ae005a9bc790
My issue I think lies in the Windows("store-is-pqy-16.csv").Activate line. Whenever I receive the next file that I have to format it would come in as store-is-pqy-17.csv therefore the macro would not pick up the new file. I can go in and manually change this everytime, but by the time I do that I could have just manually formatted it. Is there a way that that line of VBA can update everytime so that it will recognize the new workbook?
I'm not sure I quite understand. I know that csv = comma separated values file. So you are having to open a *.csv file and split into cells by the comma delimiter? Are you opening the *.csv in excel by right clicking in windows and then choosing open with ---> excel or are you copying from a text file and pasting into excel?
Opening from windows
Opening from windows
https://stackoverflow.com/questions/...ame-is-changed
This is my exact problem but not sure how to implement this into my Macro. Any help would be much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks