VB, Visual Studio, Office 2003
I’ve inherited an array of software installations on my workstation (at work).
My OS is Windows 2000, and the installed apps include:
Office 2003 Standard Edition, which comes with VB 6.3 and the dialog constants (wdDialogTableWrapping, wdDialogToolsAutoCorrect, etc) (which are called namespaces, I think, in Visual Studio .net lingo).
VB 6.0 Working Model,
Microsoft Visual C++ Professional Edition,
MSDN Library for Visual Studio 6.0installed (VB 6.3 is reached only through Office 2003 apps).
The working model of VB has no built-in help, so using this is really frustrating, I cannot F1 anything. Even help for VB 6.3 has empty placholders for the graphics (links work, but graphic words at the top of each help page are blank squares).
My job is to customize Word 2003—to create a template, with limited number of styles (ProtectStyles), and any automation that will ensure corporate docs coming from different places retain some common layout. Definitely I’ll have lots of macros. And I assume they need to be written in VB 6.3 (what’s the difference from .net?)
Given the tools I have, rely a lot on online info, user groups (MS or not).
I’d like to use Visual Studio, but wonder which version I can/should use (and I need to figure out how to attach Visual Studio project to a Word docuemnt template). Also, how does one attache get the wdDialog library to Visual Studio. Does anyone have a descriptive compendium of the arguments for WdWordDialog constants?
I have books: Writing Word Macros by OReilly, VB 6 (Visual Studio series) by Deitel and Deitel. None addresses this. The online tutorials from MSFT for creating windows Applications with VB use unidentifiable versions of Windows, VisualStudio, .Net servers—is there a decipherable compendium available for using (backward compatible Office 2003 tools? Where else to go to find help to walk me through creating custom interface for Word 2003?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
VB 6 Vs Visual Studio 2003
I am very new to visual basic,
in the past i've worked on visual delphi 5 which is very similar to visual basic,
but now i've got the choise to choose between visual basic 6 on its own, and visual studio 2003....
actually i had a go on visual studio 2003, and i found bit hard to get on with it.
i would really appreciate, if people can give me their opinion about what to pick between the two.
thanks for you help in advance...
have a nice day,
msn : xy8978@hotmail.com
Visual Studio 2003?? Whats New??
Visual Studio 2003 comes out in Feb and it's in final beta right now. What's so new and great about it compared with 2002 VS.NET? Why should I upgrade? (besides the .NET 1.1 Framework)
-- Ethan --
Visual Studio .Net 2003 Enterprise Edition
Hi,
I'm lost right now...
I used 'Visual Studio 2005 Beta Home' to make a small application.
But since the computer i want to use it on has .Net 2003 installed I get a
version error.
This probably has to do with the framework version wich is 1.1 with 2003 en
2.something with 2005.
So I can use a computer wich has Visual Studio . Net 2003 Enterprise edition
on it.
but now if I try to build a application with even the most simple commands
it gives errors.
for instance:
I try to switch from one form to another.
In 2005 i used:
Form1.Hide()
Form2.Show()
But if I use this in 2003 Enterprise edition i get:
Form1.vb(59): Reference to a non-shared member requires an object reference.
Do I have to do something else because I have a more advanced .Net 2003
enterprise version instead of my .Net 2005 home version?
Any suggestions would be greatly appreciated...
EMbedded Tools 3.0 Or Visual Studio .NET 2003
Hi,
I'm about to start work on a GUI Interface for a PDA.
I'm not sure whether to use eMbedded Visual Tools 3.0,
with eMbedded Visual Basic, or Visual Studio .NET 2003
and Visual Basic .NET.
Aside from price, what are some major benefits and drawbacks for each?
Help Whith ADOCE And Visual Studio .NET EA 2003
I have
Dim objConnection 'Declare a variable for the connection
Dim objRecordset 'Declare a variable for the recordset
objConnection = CreateObject("ADOCE.Connection.3.1")
objRecordset = CreateObject("ADOCE.Recordset.3.1")
The CreateObject does not work to me,
says to me has not declared the 'CreateObject' name, that I can do?
I must install something in addition?
thX
Connection Error Visual Studio 2003
Hi
I’m trying to connect to a local MS sql server database using asp.net (vb)
But I get the following error.
-------------------------------------
[SqlException: Login failed for user 'SONICASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
WebApplication1.WebForm1.Button1_Click(Object sender, EventArgs e) in c:inetpubwwwrootWebApplication1WebForm1.aspx.vb:43
System.Web.UI.WebControls.Button.OnClick(EventArgs e)
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()
--------------------------------------------------------
The funnies thing is that when I move the same code to a windows application, the coding works just fine
Thabang
Edited by - thabang on 11/21/2006 6:24:17 AM
Office 2003 Visual Style For VB 6
This isn't so much about using XP stylings in VB as it is about getting VB apps to look and feel like office 2003 apps. For example, the attractive blue/gray (depending on your theme) shading in menus, tool bars, etc.
Thanks much.
Packaging A Finished Product In Visual Studio 2003
I have Visual Studio 2003.
I have finished the project and so I clicked on build.
After that, I found the application in the release folder.
Since I want to distribute this application, how do I change this generic application icon into something much better?
Is there anything else I need to do?
Thanks
Visual Studio .net 2003 And Auto Code Checking
Hi,
I am using visual studio .net 2003 and the auto code checking is causing me a problem, for some reason its underlining in red
<Form>
<Headerstyle>
<AlternatingItemStyle>
etc...
The code works as I want but why the red lines, someone said it may be that my project has been set to expect a lower version of IE so it's warning me of possible problems. Is this correct and is there a way of turning this off if need be.
Thanks for your help
Joolz
VB.net beginner
How To Run && Debug .vbs Files In Visual Studio (2002/2003)
Hi all,
Didn't know where to ask this question, so decided to put in VB General...
Is there a way to write, run and debug .vbs files in VS?
If I add some .vbs files to a project, I can't run the project since there isn't a "Sub Main"...
Anybody knows if it is possible and how to do it or has other suggestions how to debug a .vbs file?
TIA
Edited by - Zifter on 11/9/2004 12:36:09 AM
Installation Of Visual Studio .NET 2003 Generates Internal Error
Greetings,
When Installing Visual Studio .NET the following error occurs:
Internal Error 25300
I've tried setup in safemode and the same error occurs.
The disk is brand new and clean.
I've copied files over to the HDD
....all to no avail
If someone is able to give me insight to this error and maybe a
starting point for troubleshooting I'd really appreciate it.
Thank you,
RP
(RESOLVED)accessing Excel 2003 From Visual Studio 2005 Express
can someone assist i am trying to access excel 2003 from Visual Studio Express 2005 express i am using the code below which opens excel but then gives me an error of com exception was unhandled and highlights the code line " owb= oxl.workbooks.add", any ideas.
VB Code:
Public Class Form1 Public Sub New() ' This call is required by the Windows Form Designer. InitializeComponent() ' Add any initialization after the InitializeComponent() call. End Sub Private Sub Button1_Click(ByVal sender As System.Object, _ByVal e As System.EventArgs) Handles Button1.Click Dim oXL As Excel.Application Dim oWB As Excel.Workbook Dim oSheet As Excel.Worksheet Dim oRng As Excel.Range ' Start Excel and get Application object. oXL = CreateObject("Excel.Application") oXL.Visible = True ' Get a new workbook. oWB = oXL.Workbooks.Add oSheet = oWB.ActiveSheet ' Make sure Excel is visible and give the user control ' of Excel's lifetime. oXL.Visible = True oXL.UserControl = True ' Make sure that you release object references. oRng = Nothing oSheet = Nothing oWB = Nothing oXL.Quit() oXL = Nothing Exit SubErr_Handler: MsgBox(Err.Description, vbCritical, "Error: " & Err.Number) End Sub End Class
Edit: Added [vbcode][/vbcode] tags for clarity. - Hack
How Do I Find Control IDs In Visual Basic For Applications For Office 2003?
I'm working on deploying office 2003 and I need to restrict/hide several of the pull down menu options as well as tool bar buttons. I found I can do this in an office 2003 policy in gpedit however I need some control ID's according to:
Finding control IDs in Visual Basic for Applications
(snip)
"...To disable any other command in an Office 2003 application, you set the Custom | Disable command bar buttons and menu items policy and add the control ID for the command you want to disable...
Finding control IDs in Visual Basic for Applications
You can look up control IDs for any item on a menu or toolbar in Office 2003 applications by using Microsoft Visual Basic® for Applications (VBA). You can either look up a single control ID or use a macro to find a series of control IDs. Then you enter the control ID into the Group Policy snap-in to disable that menu command and toolbar button."
(/snip)
Sooo.. I went and tracked down a copy of VBA 6.4, got a copy sent to me by mail and I installed it hoping it would be fairly straight forward (as I am not a programmer and have no experience in visual basic). I was hoping VBA was a program I could run.. then from there open the office exe files on my pc in an effort to locate those control ID's.. Well it doesn't work that way so I tried something else. I then ran word2003, hit alt+f11 (which opens VB) and used the script from the above web page:
Sub EnumerateControls()
Dim icbc As Integer
Dim cbcs As CommandBarControls
Set cbcs = Application.CommandBars("Menu Bar").Controls("File").Controls
For icbc = 1 To cbcs.Count
MsgBox cbcs(icbc).Caption & " = " & cbcs(icbc).ID
Next icbc
End Sub
I pasted this into a new macro and clicked on run which didn't work..
I'm pretty much running out of ideas and wondering if I'm in over my head or if this is possible for me to do.. thus I'm here for advice.
Can anyone tell me what I would need to do with VBA so I can find office command ID's?
VB Project Runs With Office 2007 Installed And Not Office 2003
Hey all, this is part two of my inquiry now... To refresh, I have a visual basic 6.0 project group created with two projects:
The first project is just a form with a button and some text fields and the coding behind the button is this :
Private Sub Command1_Click()
Dim DDEPoker As clsDDEPoke
Set DDEPoker = New clsDDEPoke
DDEPoker.txtProperty = Text1.Text
DDEPoker.txtApplication = Text2.Text
DDEPoker.txtFormName = Text3.Text
DDEPoker.txtFieldName = Text4.Text
DDEPoker.sc
End Sub
And then a project in this same group with a class file (called "clsDDEPoke")with this coding:
Private m_text
Private m_application
Private m_formName
Private m_scfield
Public Property Let txtProperty(scText As String)
m_text = scText
End Property
Public Property Let txtApplication(application As String)
m_application = application
End Property
Public Property Let txtFormName(formName As String)
m_formName = formName
End Property
Public Property Let txtFieldName(scfield As String)
m_scfield = scfield
End Property
Public Sub sc()
Dim nChannel As Long
Dim strReturned As String
nChannel = DDEInitiate(m_application, m_formName)
DDEPoke nChannel, m_scfield, m_text
End Sub
Now, it is worthy to note a couple things : First, the "Public Sub sc()" call is a DDE call that is actually a call to VBA code in the Microsoft Office object Library. Basically what this function is doing, is pushing some text into a call tracking app called Peregrine ServiceCenter into a field on the active form up on the user's desktop.
The strange part about this whole thing is that I can get it to work with Microsoft Office 2007 products and NOT with Office 2003 products (and also, microsoft word has to be open and running on the desktop for this to work - I've tested successfully with word 2007).
The error I am getting inside word 2003 is this :
"The remote data (ActiveForm) is not accessible. Do you want to start the application ServiceCenter?"
I already have ServiceCenter running (it has to be in order for this to work) and with Word version 2007, the method just works and pastes the text into the call tracking system's field.
I realize that my references most likely have to be changed for the class file to work properly, but I have done this a bunch trying to find all of the different Office 2003 based references I can find without any luck. Also I have recompiled the dll each time when changing the reference as well...
So, my question is if any of you know what exact reference (or anything else I might need to do) do I need to use in the class file to get this thing to work with Office 2003 products and not just Office 2007 products???
VBA Unexpected Exit After Upgrading From Excel 10 To 11 (Office XP To Office 2003)
My work computer just went from a Office XP to an Office 2003 upgrade and some problems just started.
The following code is kept in my "personal.xls" workbook and is started by a custom macro button in Excel. It used to work fine until the Office upgrade.
It's pretty straight forward and easy to follow. Where I have the comment "stops here ?????" is where the code stops executing. There is no alarms or warnings. I have the macro security settings on low. Am I missing a DLL file in the references or something???
Code:Sub refresh
'closes and reopens active workbook
'version 7.012.w
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim cBook As String, cSheet As String
Dim cColumn As Integer, cRow As Integer
cBook = ActiveWorkbook.FullName
cSheet = ActiveSheet.Name
cColumn = ActiveCell.Column
cRow = ActiveCell.Row
ActiveWorkbook.Close
Workbooks.Open cBook
'stops here ??????
Application.ScreenUpdating = True
Worksheets(cSheet).Activate
Cells(cRow, cColumn).Select
Application.DisplayAlerts = True
End Sub
<Edit> Lankymart - Added code tags for readability. </Edit>
Edited by - kschauer on 2/12/2007 6:25:15 AM
Office 2000 To Office 2003 Problem
Hello Guys,
I have a VBA that I created using MS Excel 2000.
The application has been running smoothly for a year now.
I upgraded my Office from Office 2000 to Office 2003, which means that I am no longer using MS Excel 2000 but MS Excel 2003.
The problem is that, the VBA I created no longer works.
A Run-time Error '91'
Object variable or Object block variable not set
is returned everytime I run the procedure. Anybody knows what is wrong?
Office 2000 To Office 2003 (Outlook)
Hello all from a newbie.
I created an automated request document in Excel (Office 2000) that sends an e-mail via Outlook with a link to the document. When you select the link in the e-mail it opens the document from it's stored location and allows you to approve or reject the request.
Now, Office 2003 is being integrated and I tested the document to see if it would still function and ran into some problems. I was able to run the script, but when the opening the document from the link in the e-mail I found that the reference library was missing and referred to Outlook V11. And of course Outlook in Office 2000 is V9 and was left unselected in the reference list.
Does anyone have any suggests? Is there a way to select an .olb file in script? Or, do I need to create a 2000 and 2003 request and run them parallel?
MS OFFICE 2000 And MS OFFICE 2003
Hello!
Just a simple question here.
Can all Office Documents created in Office 2003 be open in Office 2000? and Vice Versa..
If not then can you give me a sampl feature that is not supported by each MS OFFICE.
THANKS!
IANIAN
VB6 With XP And Office 2003
VB6 with XP and Office 2003
I am using VB6 and XP with office XP at home and my code works fine.
At work I use VB6 with XP and Office 2003.
Code I wrote at home works fine even at work. The same code cut and pasted to a new project will not work at work.
The line that goes wrong is : Dim MyConn As ADODB.Connection
VB6 just does not "know ADODB" as when I type the dot(.) I do not get the drop down list.
In the "old" version I ceated at home and imported then all works and if I type ADODB. I get a dropdown list to complete the statement.
Can you help please. The error is "compile error user-defined type not defined".
Office 2003
Ok.. I know this does not belong here, but I have to ask..
Why the he** did MS get rid of the shortcut bar in office 2003!?!?!?!?!?!
Why!?!?!?!
IS there a way to bring it back?
AHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH
Office 2003
Hello Everybody,
while installing office 2003 in windows 2000 machine, its giving the error "resource path is currupted".help me.
Regards
************************************************** **************************************************
This message (including any attachments) is confidential and intended only for the addressee named above. If you are not the addressee you may not copy, forward, disclose or use any part of it. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Internet communications cannot be guaranteed to be timely, secure, error or virus-free. The sender does not accept liability for any errors or omissions.
************************************************** **************************************************
VBA And Office 2k To Office 2003
Hi all,
Please could someone advise me on the following, the college i am working for intends to move from 2k to 2003, does office 2003 support VBA the same as the 2k version. Are there any major changes that will effect the functionality of documents created in 2k migrating to 2003 or does 2003 just offer more functionality.
Please help one confused ShadyCat
Visual Studio 6 And Visual Studio .Net On The Same Drive?
Can you install VS.net and VB6 on the same Drive? I already have VB6 and might install VS.net. I'm wondering if there are any conflicts, do they install in different directories or do you even have a choice other than just upgrading what you already have? I would like to keep both if possible.
Office XP/2003 Interface
Hi,
I have a good knowledge of vbasic .NET but I have a question. How can I make my applications look like Office Xp or 2003 (toolbars mainly). I use .manifest files to achieve WinXp interface but things seem different with Office. Any ideas?
Thanks
Sorry for my late responses in advance but teachers just do not understand...
Office 2003 Error
Hi!
I am developing a program using Office Automation.
I deployed this project on a Windows 200 Pro Box with an Office 2003 Software.
But sometimes there are cases wherein there is this Error Dialog Box from Word and Excel that has a button "Send Error Report" and "Don't Send" and a check box "Restart Micorosft Office Excel"
What could be the possible cause of this error?
I already updated All Necessary Updates for the Office.
IANIAN
Need Help Office 2003 Marco!
Ok i made an macro in outlook 2007 visual basic editor and its working properly, but when i try the macro out in outlook 2003 its not working.
The program downloads an text file to your c drive, opens it, take all the text and paste it in to the body and make in plain tekst.
Code:
Option Explicit
Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long
Private Declare Function InternetOpen Lib "wininet" Alias "InternetOpenA" (ByVal sAgent As String, ByVal lAccessType As Long, ByVal sProxyName As String, ByVal sProxyBypass As String, ByVal lFlags As Long) As Long
Private Declare Function InternetCloseHandle Lib "wininet" (ByVal hInet As Long) As Integer
'Purpose : Retreview text from a web site
'Inputs : sURLFileName The URL and file name to download.
' sSaveToFile The filename to save the file to.
' [bOverwriteExisting] If True overwrites the file if it existings
'Outputs : Returns True on success.
Function InternetGetFile(sURLFileName As String, sSaveToFile As String, Optional bOverwriteExisting As Boolean = False) As Boolean
Dim lRet As Long
Const S_OK As Long = 0, E_OUTOFMEMORY = &H8007000E
Const INTERNET_OPEN_TYPE_PRECONFIG = 0, INTERNET_FLAG_EXISTING_CONNECT = &H20000000
Const INTERNET_OPEN_TYPE_DIRECT = 1, INTERNET_OPEN_TYPE_PROXY = 3
Const INTERNET_FLAG_RELOAD = &H80000000
On Error Resume Next
'Create an internet connection
lRet = InternetOpen("", INTERNET_OPEN_TYPE_DIRECT, vbNullString, vbNullString, 0)
If bOverwriteExisting Then
If Len(Dir$(sSaveToFile)) Then
VBA.Kill sSaveToFile
End If
End If
'Check file doesn't already exist
If Len(Dir$(sSaveToFile)) = 0 Then
'Download file
lRet = URLDownloadToFile(0&, sURLFileName, sSaveToFile, 0&, 0)
If Len(Dir$(sSaveToFile)) Then
'File successfully downloaded
InternetGetFile = True
Else
'Failed to download file
If lRet = E_OUTOFMEMORY Then
Debug.Print "The buffer length is invalid or there was insufficient memory to complete the operation."
Else
Debug.Assert False
Debug.Print "Error occurred " & lRet & " (this is probably a proxy server error)."
End If
InternetGetFile = False
End If
End If
On Error GoTo 0
End Function
'Demonstration routine, downloads an image from vbusers.com
'to the c: drive
Sub GetSignature()
If InternetGetFile("https://adssad/mailbody.txt", "C:Test.txt", True) Then
MsgBox "Successfully downloaded file!"
Else
MsgBox "Failed to download file!"
End If
'Const URLString As String = "https://asdasd/mailbody.txt"
'My.Computer.Network.DownloadFile("https://sdfasf/mailbody.txt","C:Test.txt")
Dim alltext$
Dim str As String
Open "c: est.txt" For Input As #1
While Not EOF(1)
Line Input #1, str
alltext$ = alltext$ & str & vbCrLf
Wend
Close #1
'MsgBox alltext$
Dim oMailitem As MailItem
If Application.Inspectors.Count > 0 Then
Set oMailitem = ActiveInspector.CurrentItem
oMailitem.BodyFormat = olFormatPlain
oMailitem.Body = alltext$ + oMailitem.Body
Set oMailitem = Nothing
Else
MsgBox "No mailitems currently displayed."
End If
End Sub
Where is goes wrong is here:
Code:
Dim oMailitem As MailItem
If Application.Inspectors.Count > 0 Then
Set oMailitem = ActiveInspector.CurrentItem
oMailitem.BodyFormat = olFormatPlain
oMailitem.Body = alltext$ + oMailitem.Body
Set oMailitem = Nothing
Else
MsgBox "No mailitems currently displayed."
End If
It seems like it doesn't recognize the MailItem.
I made this program in one day without any visual basic knowlage, i hope that someone can help me out with this. And test it.
You need to run the macro in an new email or an forward email.
Office 2003: Msgbox With Help How To?
I am struggling to get help function of msgbox working in code below:
Code:
MsgBox "Important msg to the user", vbMsgBoxHelpButton, "Title", _
"Network DriveDirectoryhelp.chm", 0
For some reason it does not work. I also wanted to display ? next to X not next to OK button – is this possible?
Thanks for your help!
Office 2003 Style
Hi,
I am looking for FREE controls that makes my application look similar to MS outlook (Office 2003). Controls that allowed you to move your menu and toolbar, also that allow to show a calendar.
So, if anybody out there know where or how, can you please help?
Thank you,
Office 2003 Toolbar
I am looking for a FREE office 2003 toolbar style to add it to my application, do you know where I can find 1?
Thank you,
Office 2003 Config
I have installed office 2003 on me xp machine . each time I start vb 6 , a configuration process starts to configure office 2003 and i have allowed it to complete many times , but keeps coming back .
Any suggestions ?
Thanks
Exchange 2003 Out Of Office
Hi All
Anyone know how to access the Out of Office info on an exchange 2003 server. Ideally I'd like a tool to switch this off/on and change the message such as the one to be found at http://www.symprex.com/products/oom/
Any ideas would be appreciated...
Thanks
Office 2003 Spellchecker
Is it possible to run the office 2003 spellchecker from an access 97 app running on Windows XP with Office 2003 and access 97 runtime?
Chr Function: Office 97 Vs 2003
Greetings!
I have encountered an odd issue with macros written in VB (MSO 97) when running them in VB 6 (MSO 2003)
During the programming phase of my project, I ran into a situation where I needed to discover the column letter corresponding to the column number.
Although I do not remember who it was, someone from this forum provided me with the following code:
Code:
Function ColumnLetter(iNum As Integer) As String
Dim Frag1, Frag2 As Integer
Frag1 = (iNum - 1) 26
Frag2 = (iNum - 1) Mod 26
If Frag1 > 0 Then
ColumnLetter = Chr(64 + Frag1) + Chr(65 + Frag2)
Else
ColumnLetter = Chr(65 + Frag2)
End If
End Function
Under VB (4 or 5? What version came with MSO 97?), this code ran perfect.
My employer is now moving the firm computers to XP and MSO 2003. When I try to run the above code in MSO 2003, the debugger highlights the first occurence of the function Chr and gives the following error message:
"Can't find project or library."
So I checked with VB Help to see if the function name changed. No change to the Chr function. They did add ChrB & ChrW. Just for kicks I tried them as well. None of the three functions worked. They all produced the same error as noted above.
I have checked the Tools > Reference menu to find that all the libraries that were present when the macro was run in 97 are present in 2003.
Any ideas?
I'm open if someone knows of an easier way to get a column letter from a column number in VB 6.
Thanks!
JT
Which VB Does MS Excel Office 2003 Use?
Hey there everyone,
Thanks for the comfort value of a "newbie" forum, it makes the follow question a little easier to ask. :-)
I am using VB as a front end to an MS Excel application (ie MS Excel Office 2003) so that I can link to an Oracle Database via a form. The thing is (and here's the "not so smart" part), which VB am I using?
Officially; am I using VB6, or Visual Basic, or VBA, or .NET, or VB.NET?? In the about section of the VB editor is shows as "Microsoft Visual Basic 6.5".
It's sounds like such a silly thing not to know, but there appears to be subtle differences (at least) between most of them. When I try examples from the internet, sometimes they work, but other times not.
Anyway, be gentle on the replies and if you can shed any light on it, I would really appreciate your time.
Thanks (and I will post another help question separately)
Michael
PS: Am I correct in assuming in is VBA?
Edited by - VB_Newbie300 on 2/13/2008 5:53:28 PM
VB6 && MS Office 2003. BIG Problem, Please Help...
i wrote an application for a client that outputs data to an excel spreadsheet. im using VB6 and have Excel 2003 running on win XP pro. everything works great. when i test it on a windows 98 machine with excel 97 it crashes all over the place. can anyone provide any help at all?
RPCRT4.DLL is where its crashing on the 98 machine
Edited by - jjd228 on 2/23/2004 11:40:30 AM
MSForms And Office 2003
Since I have install Office 2003 on my computer, my VB 6.0 applications that use MSForms objects give me these errors for all MSForms objects: "Cannot load control <objectName>".
I think that might be a security issue from Microsoft Office or something like that.
Is there something I can do to fix this problem without changing my MSForms objects to VB objects for all my applications? Because I don't want to rewrite all my applications
Any idea will be welcome.
Office Xp/2003 Style Menus
Quote:
Originally Posted by Flyguy
vbAccelerator CommandBar Control
This is exactly what I am after. I have tried in the past to configure the vbAccelerator commandBar to work, but have been unsuccessful. I thought I would try it again now that I have been using VB for a while and I am still unable to get it to work correctly. I get a message box saying "ActiveX component can't create object" then the usual end/debug/help options. Anyone any ideas? I have read in other posts of this forum that people have found it difficult to configure this, so am I not alone?
I am obviously not doing something correct? Is this outstandingly obvious to anyone?
These are previous issues in the forum:
http://www.xtremevbtalk.com/showthre...+vbaccelerator
http://www.xtremevbtalk.com/showthre...+vbaccelerator
http://www.xtremevbtalk.com/showthre...+vbaccelerator
Many many thanks,
Blueevo.
Error On Machines Having MS Office 2003
Hello there,
My application works fine in all machines but not in a machine having MS Office 2003.
It pops an error up saying “The path to Microsoft Office Project Professional 2003 cannot be found. Verify that you have access to this location and try again or try to find the installation package ‘PRJTROE.MSI’ in a folder from which you can install the product Microsoft Office Project Professional 2003”
The code contains just a database access and resizing a picture.
Please help me fix this error.
Problems Linking With Office 2003
Hi guys, here´s an up-to-date problem: I had an exquisite program running, and linked to excel XP (nothing great, just passing some data), but now that i´m trying to run it with excel 2003, it brings "error 285: DDE cannot performe action" or something like that. What is this? And more important, how can i fix it?
MS Office Web Components 9.0 Missing In 2003?
Hi, I wrote an application that was working fine in Excel 2002. Now I'm trying to run it in 2003 and am getting a number of errors. In Tools--> References, the Microsoft Office Web Components 9.0 was showing as MISSING. So based on this thread, I unchecked the reference, closed the spreadsheet, and reopened it to reinclude the library. But the Microsoft Office Web Components 9.0 library didn't show as an option, only the Microsoft Office Web Components Wizards library. How can I make the previous functionality work?
thanks,
Rina
Problems Using ADO For Excel In Office 2003
Hi,
I am trying to use ADO for Excel in Office 2003 VBA procedure like it is described in tutorial.ADO. At first it gave me "Couldn’t find installable ISAM" error even thou I am using Jet 4.0. Then, after some investigation, I found that
HKEY_LOCAL_MACHINESOFTWAREMicrosoftJet4.0EnginesExcelwin32
registry key is not what is recommended by Microsoft (msaexp30.dll instead of msexcl40.dll). I understood that this replacement was made by Microsoft, but decided to return it back. After I put msexcl40.dll as a value of the key, ADO started working as expected. However, next time I started MS Access it restored key value to msaexp30.dll again.
Does anybody know how to resolve this problem? It looks like everybody who uses ADO for Excel and Office 2003 should be affected.
Please help.
Thanks.
Option Buttons In Office 2003
I haven't used VBA Objects in 2003--I've just coded formulas. I'm now trying to put together a spreadsheet where you select a unit of time (min, hour, day, week, month, etc.) via an option button, but when I insert the option buttons they stay in edit mode. In other words, I can't click to select the button--instead, move and resize crosshairs are all that shows when I mouseover the object. In 2000, to edit it you had to right-click. Otherwise it acted just like an option button object. I'm sure there must be a simple solution, but my time is limited and I couldn't find anything on MS Online nor in the VB archives. If someone could point me in the right direction I'd appreciate it! :-)
|
TRACKER
