Save active (current) Userform to Desktop as .png

[Jimmypop]

Good day

I have searched for code but not quite fond it yet...if it has been posted maybe point me in direction...

I need to when I click a command button that the active or current userform is saved as a png to desktop....

 

[Dan_W]

Oh I think I know what has gone wrong:

UserFormSnapshot Me, "FilePath(" & Format(Now, "yymmdd-hhmmss") & ".png", True, 2

Your revision to the filepath is in quotation marks, so it isn't capturing the filepath variable at all...

 

[Dan_W]

How did this go, btw?

 

[Mr_Ragweed2]

Fellas, Ive tried interpreting this and it is way over my head. My apologies for that. I have been trying to save a userform as a pdf but am not having great luck. It is getting close, but close doesn't matter with VBA is what i have learned. I don't need my userform as a pdf i just want to save it as something - bmp/png/jpeg i don't care. I have a thread on this and i hope i am not violating any rules by commenting here. I can link my thread here if that is allowed. Again - not trying to cross post but many of my issues are in your thread (i'm on OneDrive and trying to eventually save it to a sharepoint teams folder. My question for that is - Will i need to save the image/pdf to a C: location and then upload it to sharepoint?
Again, disregard if this violates any forum rules.

 

[Dan_W]

Fellas, Ive tried interpreting this and it is way over my head. My apologies for that. I have been trying to save a userform as a pdf but am not having great luck. It is getting close, but close doesn't matter with VBA is what i have learned. I don't need my userform as a pdf i just want to save it as something - bmp/png/jpeg i don't care. I have a thread on this and i hope i am not violating any rules by commenting here. I can link my thread here if that is allowed. Again - not trying to cross post but many of my issues are in your thread (i'm on OneDrive and trying to eventually save it to a sharepoint teams folder. My question for that is - Will i need to save the image/pdf to a C: location and then upload it to sharepoint?
Again, disregard if this violates any forum rules.

Forums usually require people to start new threads (and then you should absolutely link to this one if it's relevant/connected) because that will save everyone a whole lot of time!

Personally, I think it's actually in the person's best interest to start a new thread anyway, forum rules aside, because it's unlikely that anyone will see your question other than the two people involved in this thread. Even though I did see it, Im walking out the door in a minute. If you start a new thread, then everyone will see it and people may be able to help.

The quick answer to your question is that cab save it anywhere that you like, but if uploading it online, that's a different challenge (and I have no experience with sharepoint).

Best to start a new thread, and link to this if you want, but perhaps focus on the SharePoint angle if that's the outstanding issue.