Visual Basic

PLEASE HELP...Visual Basic - code question

Hi there,
I have created a macro in Excel 2007 using Visual Basic..
When I run it, it will take an excel sheet, turn it into a .pdf, ask you where you want to save it and then save it there as a pdf with the sheet name, and then it will open up an email (Outlook) automatically with the .pdf attached.
My question is, I want to automatically save the .pdf to c:/temp without being prompted where to save all that I will see is the email with the attached .pdf pop-up and not a prompt of where to save the file.

How to save excel file in unique format

Hi! is it possible to make a macro in excel which saves the excel spreadsheet as a unique extension like .TS2 so that the file cannot be opened by excel directly, there would be another macro through which it can only be retreived.


Spreadsheet-Based Control System Analysis and Design


I'm working on a project and I'm trying to find out how to program these advanced diagrams in VB.
Found this ad and I would be thrilled to know how:

Any ideas or thoughts will be much appreciated!

Thanks in advance /Mike

Excel Help - Macro to save file to a default location

Hello there,

I need your kind help. I have created an excel spreadsheet that will be used by multiple users. Upon clicking the submit button, I want excel macro to save the file to a default location (without using the save as dialog box), thus users do not have to save the file themselves.

Thanks in advance for assistance