I have a command button with this code.
TST is a macro.
I need to add 2 other macro with this command button.
The names of the macro are:
Button2_Click
Save_Workbook
How do I do it?
When i add the macro name as TST the I get this error.
Please Login or Register to view this content.
I have attached the screenshot of it.
You did not post what the error message is, but the indication, based on the highlighted line of code, is that Excel has a problem with your File Name variable.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Thanks JLGWhiz,
I am attching the screen shot of the error message.
Please let me know if you require any more details.
It is telling you that there is a problem with:
1. File path
2. File name
3. File type, eg. .xlsm, .xlsx, .pdf, etc.
4. Or file is corrupt.
Check the data in cell Q42 to be sure it is accurate.
Hey JLGWhiz,
Thanks for your reply.
If I assign that macro to a seperate button then everthing is perfect.
But when i try to combine various macro with a command button then this error pops up.
I am attaching my sample file incase that adds value.
If I use the macro seperately then it works. Only if i combine then it does not work
Strange that it works separately but not when called from another macro in the same workbook. The error message idicates that if the exported file is open it would not save to the PDF. But your statement that it works separately would belie that theory. I can't come up with a good answer for you, maybe somebody more techie than me would know the answer.
does the folder "testing purpose" exist?
Maybe you changed that as part of your testing between it working and not working.
Last edited by scottiex; 02-04-2018 at 07:55 PM.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
Hey scottiex,
Where did you see "testing purpose" folder ?
The problem is that all the macro does not work when thet are combined with the command button.
or else they work prefectly
The value in C3 on the INVOICE sheet is tesing purpose\ which you use as part of the FullFileName variable. Nothing in your code creates a folder called "tesing purpose", which is why the code fails. If C3 is supposed to be part of the PDF file name, you need to remove that backslash at the end of the cell.
Don
Please remember to mark your thread 'Solved' when appropriate.
Hey xlnitwit,
THANK YOU SO MUCH.
works for me now.
THANK you once again
You're welcome. I was really just clarifying the point scottiex was making.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks