Chester, I can't tell you how long I've been looking for this solution. And how you don't already have a million subs I just don't know but iam sure you ll get there soon with videos like these. Thank you so much for the great explanation and video...keep it up.
Great one Chester! I created a macro similar to this to save a copy / paste values version of my .xlsm as .xlsx to send to clients, so they don't have control of my live workbook. Very handy and useful. Thanks for sharing. Thumbs up!!
I have used your instructions. It works well. I save it as a .xltm file, because I need it use it again and again for new costing. But only problem is when I open that .xltm file it's open with saved name. Only invoice number changed. I don’t know I made a mistake. Please advise me how to save .xltm sheet in a specific location with a name and invoice number as a .xlsm file. But original .xltm file have to open as fresh file to reenter new data and save. Thank you.
Am able to make a copy but get Run-Time Error 1004 "The file could not be accessed" . Debug highlights the following: .SaveAs Filename:=path & fname, FileFormat:=51 Trying to save in documents folder for testing.
Hi Chester. I need one help this please. First of all this is a great tutorial. This helped me in my project. However, i have a question. I need the macro to select two specific sheets from the original workbook and copy it over to the new one. This video only tells us about copying one sheet. Can you please tell me how to copy over two sheets?
Well done Chester, great vid. How would i go about inserting a date that has been formulated =IF(C5="","",(B5)) and the cell formatted to show "01/02/24" to replace an invoice number? i have attempted as per your instructions but instead of the date i am getting 45323. Thank you.
HI Chester. I have some trouble including in my path the date of my invoice. In other words I wnat to save the Invoice number followed by the date, but i do not seem to get the correct syntax when I tell PDF writer to get the date from my cell. I know that i can use the 'Format' function for the date and it will work. But I do not want this. I rather will have the date saved in a variable and then use the value stored in the date variable to include in my path. i want to do this since I want to use the date variable for other sub-routines that i want to run. Any suggestion on the correct syntax that the PDF writer will allow.? Tahnks martin (South africa)
Hi Chester. This is a really a great tutorial. I have a query. Rather than copy one sheet to the newly created workbook. If I have two worksheets from the original workbook to be copied over to the new one, I am wondering how to revise the VBA code to do that. Thank you.
Another great video with detailed explanation 👌. One question i.e. what if i want to save the newly created invoice in same folder where master invoice file is placed. Please guide. Thanks
Sir, I have a question. When I saveAs file as macro enable using vba. Why the button doesn't work in new workbook? Why the module not transfered there? Thank you.
hi chester, what about the vba code for saving Word.doc and docx (some people use the older version) or even a .jpg in a specific folder. And save it as the ID # of that specific student. thanks for your help and of course pull it up from a command button-VBA and and changes on that Word doc should also be saved on the same folder with the same ID #. I am using a Userform.
I have followed your steps and got the automated invoice I wanted, thank you so much, however I have 1 probem with it - When I save the files the code is deleting the buttons as I wanted but it is also deleting the Logo, I have tried it as a Jpg, Ico, Gif. Png and pspimage yet every time I run the code it deletes the Logo What am I doing wrong, I have been trying to nut out the problem for 2 days wth no success. The odd part is I had icons remaing when I locked the icon to the shape. Any suggestions will be appreciated Thanks I like your version of Excel for dummies like me.
If you are having trouble with your logo being deleted use this code in place of the loop I demonstrate in the video: For Each shp In ActiveSheet.Shapes If shp.Type msoPicture Then shp.Delete Next shp
Wow amazing video, anyone any idea of how I add other sheets, this works perfectly but now I made a few new sheets in the original document but they are not being copied
How can I run the macro to simply open the 'save as' option where I can rename and specify the file type? Same with the PDF function. I am totally illiterate when it comes to excel and getting so frustrated trying to figure out codes. can anyone help
I wish your channel was available back when... Your step bby step explanations are brilliant! Thank You
Chester, I can't tell you how long I've been looking for this solution. And how you don't already have a million subs I just don't know but iam sure you ll get there soon with videos like these. Thank you so much for the great explanation and video...keep it up.
Great content, easy step-by-step instructions.
Great one Chester! I created a macro similar to this to save a copy / paste values version of my .xlsm as .xlsx to send to clients, so they don't have control of my live workbook. Very handy and useful. Thanks for sharing. Thumbs up!!
Very easy to follow and comprehend your explanation. Thank you very much.
thank you Chester for the steps by steps guide. :)
It's easy to follow and your explanation is very clear. Subscribed~
Very Helpful Exercise... Thanks..
Wowww. Great video Chester. Thank you for the detailed explanation!
Chester, you are the best👍👍🌹🌹
Excellent Video ....😊
Thank you. You helped me to do my first macro. And is working :)
I have used your instructions. It works well. I save it as a .xltm file, because I need it use it again and again for new costing. But only problem is when I open that .xltm file it's open with saved name. Only invoice number changed. I don’t know I made a mistake. Please advise me how to save .xltm sheet in a specific location with a name and invoice number as a .xlsm file. But original .xltm file have to open as fresh file to reenter new data and save. Thank you.
Excellent video, thanks a lot!
Great Explanation !
also, can we retrieve data from add record sheet to main invoice sheet ?
Am able to make a copy but get Run-Time Error 1004 "The file could not be accessed" . Debug highlights the following:
.SaveAs Filename:=path & fname, FileFormat:=51
Trying to save in documents folder for testing.
Hi Chester.
I need one help this please.
First of all this is a great tutorial. This helped me in my project. However, i have a question.
I need the macro to select two specific sheets from the original workbook and copy it over to the new one.
This video only tells us about copying one sheet.
Can you please tell me how to copy over two sheets?
hi SB. I am wondering if you have found the solution? If you have, please share. Thanks
Hi Chester. This is a brilliant video. Is there away to do one button to save as .xlsx and pdf at the same time.
Well done Chester, great vid. How would i go about inserting a date that has been formulated =IF(C5="","",(B5)) and the cell formatted to show "01/02/24" to replace an invoice number? i have attempted as per your instructions but instead of the date i am getting 45323. Thank you.
Thanks , it was an educational video. 🙏
Glad it was helpful!
This was so helpful! Thank you!
Glad it was helpful!
This is a brilliant video @Chester Tugwell thank you for making this available for us. Can we save files to google drive folder destinations?
Awesome! Thank you!
HI Chester. I have some trouble including in my path the date of my invoice.
In other words I wnat to save the Invoice number followed by the date, but i do not seem to get the correct syntax when I tell PDF writer to get the date from my cell.
I know that i can use the 'Format' function for the date and it will work. But I do not want this. I rather will have the date saved in a variable and then use the value stored in the date variable to include in my path.
i want to do this since I want to use the date variable for other sub-routines that i want to run.
Any suggestion on the correct syntax that the PDF writer will allow.?
Tahnks
martin (South africa)
Hi Chester. This is a really a great tutorial. I have a query. Rather than copy one sheet to the newly created workbook. If I have two worksheets from the original workbook to be copied over to the new one, I am wondering how to revise the VBA code to do that. Thank you.
Sheets(Array("Sheet1", "Sheet2", "Sheet3", "Sheet4")).Copy
Just fill in the "Sheet1", "Sheet2", etc with your Sheet Name
Another great video with detailed explanation 👌.
One question i.e. what if i want to save the newly created invoice in same folder where master invoice file is placed. Please guide.
Thanks
thanks. everything works but it doesn't add the file extension. Records come as files only. Why?
Sir,
I have a question.
When I saveAs file as macro enable using vba. Why the button doesn't work in new workbook?
Why the module not transfered there?
Thank you.
hi chester, what about the vba code for saving Word.doc and docx (some people use the older version) or even a .jpg in a specific folder. And save it as the ID # of that specific student. thanks for your help and of course pull it up from a command button-VBA and and changes on that Word doc should also be saved on the same folder with the same ID #. I am using a Userform.
I want to save both in .xlsm and .pdf... Will you please explain how to do?? Please
Hi Chester. How if i want add code sheet1 copy and pastevalue after auto save as a new workbook ?
if i run it from the code it works a treat, but cannot get the button to work ........... any ideas please
I have followed your steps and got the automated invoice I wanted, thank you so much, however I have 1 probem with it - When I save the files the code is deleting the buttons as I wanted but it is also deleting the Logo, I have tried it as a Jpg, Ico, Gif. Png and pspimage yet every time I run the code it deletes the Logo What am I doing wrong, I have been trying to nut out the problem for 2 days wth no success. The odd part is I had icons remaing when I locked the icon to the shape.
Any suggestions will be appreciated
Thanks
I like your version of Excel for dummies like me.
If you are having trouble with your logo being deleted use this code in place of the loop I demonstrate in the video:
For Each shp In ActiveSheet.Shapes
If shp.Type msoPicture Then shp.Delete
Next shp
@@ChesterTugwell OMG thank you Chester,your bloods worth bottling, that worked thank you so much
Great !!! Thank you !!!
Wow amazing video, anyone any idea of how I add other sheets, this works perfectly but now I made a few new sheets in the original document but they are not being copied
Great sir
possible to do this in Mac excel?
How can I run the macro to simply open the 'save as' option where I can rename and specify the file type? Same with the PDF function. I am totally illiterate when it comes to excel and getting so frustrated trying to figure out codes. can anyone help
Waw
❤👍