I am trying to use API call via Visual Basic 6.0 to access Excel 2000 file properties. I have a program that opens an excel template we have built and up until now it has not been a problem. Now our customer(s) are requesting custom templates so I need a method of identifying a template before...
Greetings,
I am interested in "honing" my skills as a VB programmer and have had a hard time coming up with new ideas of programs to write until now. This may not be possible, but can anybody point me in the right direction (either web site, source code etc.), other ideas on how to...
I am using VB6 connecting to Oracle 8.0.5 database via DAO trying to select data that will be inserted into local database (oracle lite), but keep getting an error 3146: ODBC Call--Failed when trying to select the data. I have changed the original program to include dialog box that gives the...
I am using Access97 and Excel 2000. I have a report in Access with a field of Dates when a project is completed. When I run the report everything looks fine, but when I do export/Saveas to excel some of the dates randomly show as "Date Time" (ie. 3/28/2000 12:00PM). I have the...
I'm using Access 97 and have created a query which all works fine. The problem is when I try to Export/Saveas to an excel spreadsheet (Excel2000). One of the columns in the report is a date field. When the report is exported to Excel, some of the records dates are formated as 3/8/2002 12:00PM...
I'm using excel 2000 on Windows 2000 computer
Can anybody tell me if there is a way to unprotect the vb editor in Excel using Code? I have written a program for our engineers that strips all code from our specification workbooks so they can e-mail it to their customers. Our workbooks have menus...
Deb,
I had the same problem. When you open excel a blank workbook is opened. You must also close this workbook then run the wizard.
Hope this helps.
nimrod44
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.