Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: 3576
  • Content: Threads
  • Order by date
  1. 3576

    Exporting to Excel by column

    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?
  2. 3576

    Setting password in Excel programatically from VB app

    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
  3. 3576

    Setting password in Excel programatically from VB app

    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
  4. 3576

    Adding Common Dialog control to MS Excel

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

    SaveAs and Common Dialog

    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
  6. 3576

    Common Dialog & Ms Access

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

    Lock project for viewing and setting password

    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...
  8. 3576

    Cable length

    Is there a method which will give me the length of the cable (using vb code)? TW
  9. 3576

    Accessing AutoCad Blocks from Excel

    I am trying to access autocad block from Excel by using the following code: Set acadBlockRef = acadDoc.HandleToObject(strHandle) I am getting an error message: "Type mismatch" even though this statememt works in AutoCAD and MS Access. Please let me know of a way to make this work...
  10. 3576

    Embedding Excel into an Access form

    I need to embed an Excel into an MS Access form and link the excel form to a query or a table. Any suggestions are appreciated. Thanks, TW
  11. 3576

    Embedding Excel into an Access form

    I need to embed an Excel into an MS Access form and link the excel form to a query or a table. Any suggestions are appreciated. Thanks, TW
  12. 3576

    Executing 'Find & Replace' function in MText using code

    I need to use 'Find and Replace' and 'Align Column' function in MText block (AutoCAD) using a code. If anyone knows how to implement it please let me know. Thanks, TW
  13. 3576

    Running AutoCAD from MS Excel

    I am trying to run an AutoCAD application from an Excel spreadsheet which is generated by a VB application and I need to add an AutoCAD refences dynamically in MS Excel. How can I do it? Thanks, TW

Part and Inventory Search

Back
Top