Search results for query: *

Thank you very much for your reply. What I really need to do is to transfer certain columns from the table into an excel spreadsheet. The column name in the spreadsheet are not in the same order so I need to check for matching column name and then transfer the data. I was hoping that it is...

I was wondering if it is possible to export from an access database to an excel spreadsheet column by column (skipping some in the middle) using Visual basic commands?

I posted my message in the wrong forum but I want to set a password from a VB application as I am creating and formatting an excel workbook and attaching a module everytime a special list is generated using VB app. I would like to protect the code so that users won't modifying it. I know that I...

Does anyone know if it is possible to to set a password for modules and lock project for viewing in Excel programmatically from VB app. Thanks in advance. TW

Does anyone know if it is possible to to set a password for modules and lock project for viewing in Excel programmatically from VB app. Thanks in advance. TW

I didn't realize that it was that simple. Thanks... TW

Thank you both for your help. I actually can use both methods in my code. TW

Could you provide me with a code sample please... TW

I was wondering if anyone knows whether it is possible to add CommonDialog control to excel spreadsheet programatically? Thanks, TW

What I meant by saying "I used the pCommonDialog.ShowSave" to save a file, is that when that pCommonDialog open I entered a new name and clicked on the "Save" button in the pCommonDialog control but the file wasn't saved. Shouldn't the file be saved? Thanks, TW

I should add that when I used the pCommonDialog.ShowSave, the file was not saved somehow. TW

Is there a function such as SaveAs in Common Dialog control? I need to provide the user with the ability to select a file and rename it right away preferably using Common Dialog control. Any help is appreciated. Thanks, TW

That worked! Thank you! TW

Thank you for this reply. What I need is the name of the filter for the MS Access *.mdb CommonDialog1.Filter = "All Files|*.*| ? *.mdb" Thanks, TW

I need to open MS database using commong dialog. What is the filter name for MS database? Thanks, TW

The very first link gave me what I needed. Thanks a lot. Teresa

I checked the properties for AcadLWPolyline and it does not have the length property. However, if I enter a "list" at the command prompt and select a cable it does show me the length. I assume that there is a method of getting that information, I just don't know one. Thanks for checking into...

What I ment by cable is a AcadLWPolyline. Thanks, Teresa

Thanks for your reply. I can do it manually but I need to do it using the code. TW

I need to set a "password" and "lock project for viewing" using excel vb code. I know that the following code prevents a user from making any changes to the spreadsheets: xlBook.Protect Password:="Password" but I need to prevent a user from viewing and making changes to the code. Thanks for any...