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?
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
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
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...
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...
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.