Im just learning and have made some userforms with text box's and comand butttons and i am trying to make them create a new excel workbook and save it. I have try'd all sorts of different code that i have found on the net but carn't get any to work.

Learn/use Office-Interop API.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.