Different Object Libraries In Office 2002,2003
I have a problem due to the difference of object libraries in Microsoft Office 2002 and 2003. I use Office (Excel) 2003 and wrote some macros in an Excel file that references to the "Microsoft Word 11.0 object library". The file is shared by people in my office and I am still working on some other macros in that same file.The problem starts when my co-worker who uses office (Excel) 2002 uses that file .It gives error since office 2002 use "Microsoft Word 10.0 object library". He has to go to the VBA editor and re-reference to the "Microsoft Word 10.0 object library".So everytime I run the macros in my office 2003, he has to repeat referencing process again.Anyone has come across this problem and know how to fix this ?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
References To Office Object Libraries Missing
I wanted to have a play around with automating Office apps in VB, but when I went to add the necessary references, to my puzzlement I have discovered that there are no references to any of my office apps listed in my list of references.
I have Office XP installed, and, for example, if I want to automate Excel, I should just be able to add the reference to the Excel 10.0 Object Library. This reference is not listed, nor are there reference listings for Word or Access. The only Office references I have listed are Office Web Components 9.0 and Office XP Web Components.
I have trawled the Internet but can find no reference to anyone else having this problem.
Anyone know why these objects are not included in my reference list, and how to get them there?
Cannot Insert Images As OLE Object With Word/office 2003?
Hello there,
Until recently, we've worked with office 2000 and for some historical reasons, we included images (.jpgs etc) via ole-objects and not as insert -> graphics -> from file etc.
However, while validating our macros for office 2003, it appeared that now images are only included as icons in the documents and not as actual pictures anymore when using the OLE-way... is there any way to prevent that?
Best Regards & thanks,
-JB
Microsoft Office Object Library Excel 2003 And Excel 2000
Ciao Gurus,
I have developed an application with excel 2003 and, of course, it takes as reference the library of excel 2003, but most of the users have excel 2000 and the application goes in error when this reference is called. The library is Microsoft Outlook that in excel 2003 is 11.0 version while in excel 2000 is 9.0.
How can I fix the problem?
Best Regards
KAIALA
Edited by - kaiala on 7/2/2007 3:21:56 AM
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
VB6 And Office Libraries
I need to create Word and excel docs within my VB application using the Microsoft office libraries. I can't find any resources or tutorials on this. Does anyone know of any online resources for this?
Using Office Libraries
Am I correct in assuming that, when using a Microsoft Office object in my program, that the end user will not need to have Office installed to use the object? Shouldn't the installation, upon adding the necessary libraries, take care of this?
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?
Reference Multiple Versions Of Office Libraries
I have a product developed in VB 6.0 and uses MS Words library to open up Word documents and fill in bookmark objects with data and shoots them to the printer. The program also references the Excel library to print reports out to it. My problem is the compile machine is on Office 2000 and if I upgrade it to 2003 let's say then any of the users still using office 2000 the functions stop working. Is it possible to reference multiple word/excel objects in the same project? Or do I have to do some sort of late binding? Has anyone had experience with this before? Thanks for your time and responses.
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
< Not VB Office 2002 >
I installed 2002 tonight and am having a slight problem. In my application I have a browser that I use to view and work this site.
However, since I installed 2002 I can't open a thread withing a thread...ie..if I have a thread open usually it would open a second window with the thread inside a thread...now it just sits and times out....
Anyone have anything similar happen and know what could possibly cause it....is it possible that 2002 overwrote my SP5?
Pocket PC 2003 And Vb.net 2002
Hello everybody,
Is there a way to use Pocket PC 2003 within Vb.net 2002 (or VS.net 2002)?
It seems to be you have to upgrade to VB.net 2003 in order to work with PPC 2003, is it correct? I downloaded and installed PPC 2003 but nothing appear when creating a new VB project. Am I missing some setup steps?
Thanks in advance,
rock
Problem With Office 2002
HI,
I have a big problem.
i designed a big code with backend - msaccess and windows office 2003
now i copied total vb code to other systerm ( which contains windows 2002) but i am unable to access the MSAccess database only i can read view only.
is there any way is there to copy from windows office 2003 to 2002.
pls let me know it is very very urgent
Stored Procedure Changes 2003 To 2002
The data and data type in the SQL2000 DB is a smalldatetime (1/15/2003 6:23:00 am AND 1/8/2003) but when I use the below code it changes the year to 2002! Why?
Thanks
Code:
SELECT TOP 100 PERCENT CAST(LEFT(dbo.SitesVisited.DateVisited, 8) AS SMALLDATETIME) AS DateVisited, COUNT(dbo.SitesVisited.URL)
AS NumberSitesVisited, dbo.Members.FirstName
FROM dbo.Members INNER JOIN
dbo.SitesVisited ON dbo.Members.MemberID = dbo.SitesVisited.MemberID LEFT OUTER JOIN
dbo.Partners ON dbo.Members.MemberID = dbo.Partners.MemberID
WHERE (dbo.Partners.PartnerPassword = 'D7DC0F69-C3AB-43A2-952F-1BAF872D4055')
GROUP BY CAST(LEFT(dbo.SitesVisited.DateVisited, 8) AS SMALLDATETIME) , dbo.Members.FirstName
ORDER BY CAST(LEFT(dbo.SitesVisited.DateVisited, 8) AS SMALLDATETIME) DESC
Word 2002 VBA - MS Office XP Developer/DLL - HELP!
Hello there, I have been coding in VBA Office apps for a little while (self-taught), and would like to know how to create a DLL from scratch, there are plenty of really cool articles and code partial snippets, but no stepbystep procedure on how to actually do this, esp. switching from a VBA perspective.
Eventually, I will need to be able to secure the code and the project passwords simply won't do it. If i could get a grip on some basics, I feel that it may help me to get over the initial scarey first steps! For example, I have a document template, which when a user creates a new document based on it (in VBA, using the "Document_New" event), displays a userform with text boxes, option buttons, checkboxes and the like, and when the user fills out the info, then clicks on the OK button, and the info is then transferred into the appropriate parts of the newly created word document. I also use the "UserForm_Initialize" event to setup a few defaults before the userform is displayed, here's a cut down version in VBA, any clue/s as to how this code would be written in MS Office Developer XP please? (I also have VB6).
I have read so many articles, but they assume a level of knowledge (i'm not that confident either), and most of them are doing quite different things to what i am trying to do (interact with other apps, etc.).
Any help would be greatly appreciated!
Vba Error Caused By Office 2002?
I created a workbook in office 2000 which contains vba. I then took a copy of it home from work and worked on it within office 2002 not changing any code just adding a new userform. when I saved it and took it back to work to use in office 2000 my vba that worked before no longer worked and started asking for variables to be declared etc.
Anyone know what office 2002 has done to my vba and how I can fix the problem?
Thanks
Adrian
Moving Vba Between Office 2000 && 2002
I created a workbook in office 2000 which contains vba. I then took a copy of it home from work and worked on it within office 2002 not changing any code just adding a new userform. when I saved it and took it back to work to use in office 2000 my vba that worked before no longer worked and started asking for variables to be declared etc.
Anyone know what office 2002 has done to my excel workbook and how I can fix the problem?
Thanks
Adrian
Problem With Microsoft Word XP 2002 / XP 2003
Hi all,
Alert about Micorsoft Word Issue/Bug:
We are facing some issues when working with Find and Replace option with Microsoft Word XP.
Please see the attachment, If you guys have any solution to that, pls let me know.
Pls update with your valuable comments.
Thanks,
CS.
Outlook '97, 2000, 2002, 2003 Compatibility
hello all,
this is the code i've written to input into an Access DB the contacts of Outlook 2002 (i've left the recordset code out). it uses no references, so that the program will start even on computers without outlook installed.
my question is: is this completely compatible with all other versions of outlook?
thank you in advance,
wc.
here is the code:
VB Code:
Dim objOutlook As ObjectDim objNameSpace As ObjectDim objContactsFolder As ObjectDim objContacts As Object On Error Resume NextSet objOutlook = GetObject(, "Outlook.Application")If Err.Number Then Err.Clear 'no open outlook, open one Set objOutlook = CreateObject("Outlook.Application") If Err Then MsgBox "Could not open outlook." If Not objOutlook Is Nothing Then Set objOutlook = Nothing Exit Sub End IfEnd IfOn Error GoTo 0 'ok now outlook is working Set objNameSpace = objOutlook.GetNamespace("MAPI")'10 is the olFolderContacts constant which you can't use since there's no direct referenceSet objContactsFolder = objNameSpace.GetDefaultFolder(10)Set objContacts = objContactsFolder.Items 'loopFor Each objContact In objContacts Rs("First Name") = objContact.FirstName Rs("Last Name") = objContact.LastName Rs("Company") = objContact.CompanyName Rs("Email") = objContact.Email1Address Rs("BusinessTelephoneNumber") = "" & objContact.BusinessTelephoneNumber Rs("HomeTelephoneNumber") = "" & objContact.HomeTelephoneNumber Rs("MobileTelephoneNumber") = "" & objContact.MobileTelephoneNumber Rs("BusinessFaxNumber") = "" & objContact.BusinessFaxNumber Rs("HomeFaxNumber") = "" & objContact.HomeFaxNumber Rs("Address") = objContact.BusinessAddressStreet Rs("Post Code") = "" & objContact.BusinessAddressPostalCode Rs("Town") = "" & objContact.BusinessAddressCity Rs("State") = objContact.BusinessAddressState Rs("Country") = objContact.BusinessAddressCountry Rs("HomeAddress") = "" & objContact.HomeAddressStreet Rs("Home Post Code") = "" & objContact.HomeAddressPostalCode Rs("HomeTown") = "" & objContact.HomeAddressCity Rs("HomeState") = objContact.HomeAddressState Rs("HomeCountry") = objContact.HomeAddressCountry Rs.UpdateNext Set objNameSpace = NothingSet objContactsFolder = NothingSet objContacts = NothingSet objOutlook = Nothing
Need An Access 2002 (Office XP) Database Converting To 97 Please
Help me pleeeeeeease!
I urgently need an Access 2002 (Office XP) database convertging to Access 97 format please. I created the database at home by importing a 35mb text file because none of the crappy pc's at work were capable of opeing the text file without falling over. Unfortunately, I did it in a rush this morning as I was running late for work and saved it as 2002 format without thinking and we only have Access 97 available.
If anyone has Access 2002 and can convert the database for me please reply and I'll email you a url for the database and an email address to send it back to.
Cheers
Remember to use [code=vb][/code] tags around code.
| Posting rules | How to get your questions answered | Wonko's Blog | Twerps Peerage |
vbCity Recent Topics RSS feed
Edited by - wonkotsane on 2/4/2004 3:42:18 AM
Merits Of User Security In A MSAccess 2002 Or 2003 DB
I remember trying to sort out the user security for objects in a MSAccess v2 db and ended up locking myself out of my own database on more thatn a few occasions.
Since then, I haven't had the need to secure objects in a db for quite a while.
With developing for in house apps, just having a username and password in a users table to check against has sufficed.
However, I've developed an app I'd like to offer the internet and am debating on whether to secure the db or not. I've already got encrypted userids and passwords for the vb app.
As a test, I've just placed a database password on the database.
And have my app opening the db using the password.
I've recently helped a number of clients who don't secure their db since they believe anyone can download a password crack from the internet anyway.
Their apps don't really require secured data either.
I haven't seen or heard of a password crack for MSAccess 2002 or 2003.
And am not asking for one either.
But, I am wondering, if there are merits for adding User Security to my MSAccess DB.
I'm thinking at the moment only my app needs to have access to the db.
Any thoughts?
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
MS Word Normal.dot Interferes With Outlook - Why? (Office XP/2002)
Hi,
I have created a Normal.dot file for MS Word 2002 which creates a custom toolbar for Word.
The problem is when the user starts MS Outlook, the custom toolbar appears as part of the Outlook window.
I am using Windows XP and the Normal.dot file slots into the following directory:
C:Documents and SettingsMyNameApplication DataMicrosoftTemplates
Is there any way to stop it from interfering with MS Outlook?
This is urgent and any feedback/advice would be much appreciated
Many thanks,
Chris
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
Why Doesnt This Code Work In Outlook 2002, But Works In 2003?
VB Code:
Set oApp = ApplicationSet oCBs = oApp.ActiveExplorer.CommandBars AddTheLog "Commandbar list"For Each oCBar In oApp.ActiveExplorer.CommandBars AddTheLog oCBar.NameNext
AddTheLog is just a simple function to append to form1.text1.text
anyway, this code works fine in outlook 2003, but not in 2002.
any idea why?
the file i had to add a dependancy was the 2003 dll (i have 2003 on my computer), is that why?
whats interesting is that some things work in 2002, but some dont.
any idea why?
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 AddIn Office Object Model
I am developping addin for office Application to integerate the system we are using in company. I use IDTExtensibility2
model for addin in order to enable this add-in for all application comes with office.
when I try to open in word doc from addin going like this,
Dim wordDoc as new word.application
word.Documents.open pathtodocument
it creates another word instance and open it there whether or not I have document open in the current word. same thing with excel and powerpoint.
for going like this
Dim excelWksht as excel.application
excelWkSht.Workbooks.Open PathToworkbook
will open a workbook in a different excel instance.
how to use this office application model in order for opening
a document in the current application.
Thanks in Avanced
Shin
Same Object Name For Different Libraries
Hi...
I declare a column object in order to use it in a datagrid... It was working just fine until I make a reference to Microsoft Word 10.0 object Library. Now I have two "column" object and the properties that it takes are the word object one, so I can't use datafield property.
How can I declare the datagrid column object and take its properties
thanks anyone for help
|
TRACKER
