Dear Sir
i would like to create macro with form key that when i press on it
it create new file from current open excel sheet (in my example Label Sheet From Column A-Column F )
in folder in the same directory with folder name is B2+C2 and new workbook name with H2
in my example folder name will be A B#16 and workbook name Shi # 1 DFR
please note that the file needed with extension XLSX
regards
Do you need to create new workbook for each row .. and to keep that row only and clear other data in the sheet exported ..?
I think you need to give us more details ..
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Dear alpha frog
Thanks for your reply
Do you can reply me with how can I make this with excel
There are several step-by-step videos and guides to show you how. Just do a search for something like Excel paste a macro or Excel add a form button
Dear Alphafrog
i would like to know if we can save this data in column mention before as value because all this data in column coming from another sheet with function
need export as value without formula
regards
Dear Alphafrog
i would like to know if we can save this data in column mention before as value because all this data in column coming from another sheet with function
need export as value without formula
regards
Please Login or Register to view this content.
Dear AlphaFrog
I have question about if i need to apply this code for another sheet in the same workbook , it's not work for me
Please can advice me with Base code that can i use it for any sheet or folder do the same function (create new workbook with specific name in new folder with specific name also
regards
Change this...
Sheets("Label").Copy
To this...
ActiveSheet.Copy
It will copy the currently active sheet to a new workbook. The rest of the code is the same assuming B2, C2, and H2 have the folder and workbook names as before.
can please write the code that can i used for any future example
especially every sheet will have another range is different from another
i will be thankful if you can make code with highlight for this variable can change according to my demands
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks