LinkBack URL
About LinkBacks
I wanted loop in my code that open new workbook every time and done formating and then save as new file.
I am new to vba please give me better suggestion.
I wanted loop in my code that open new workbook every time and done formating and then save as new file.
I am new to vba please give me better suggestion.
Last edited by ankitparate; 07-12-2013 at 06:25 AM.
So the macro should open the file given in B3, do the formatting and save as the file in cell B5?
What formatting to be done?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi arlu201,
I completed my code by own.
By the way thank you for responding.
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
I changed my code like this
see the attachment
code snippet.JPG
OK thanks. Any reason why you removed the attachment from the 1st post?
See I again added the attachment with correct code.
Last edited by ankitparate; 07-12-2013 at 06:29 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks