Hi Excel Gurus,
I have 2 file types = .tss and .ptr,
The files are open at the same time in excel for several formatting applications to take place.
I really need a macro that will be able to undergo several formatting obsticals in the .ptr book then copy them over into the .tss workbook.
can you help me with create a macro that can distinguish the .ptr from the .tss?
I know this is a very big ask but I am at your mercy and am alwaysvery appreciative of any advice!
Last edited by TulipandRoses; 06-07-2013 at 07:20 AM.
Activeworkbook.FullName and Instr
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
wow.... really!! ah i was so close! Thank you for the help! I really appreciate it! have a lush weekend!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks