importing problem in macro

S

shw

I have made a macro in word but I can not install it in
other computer there is one .bas and 2 forms from which
one form is giving error while I import it. How can I make
an install version so that all three file get installed on
different computers or I can import the file as this is
also not done.
On my computer it is working fine loaded in Normal
document but after exporting It and importing it in other
computer one frm give error
I can send you files if its needed
 
S

shw

Hi

I an studing the link you have send but FYI, the error log
file created this error

Line 2: Property OleObjectBlob in frmmedi could not be set.


and this is first few lines of form frmmedi


Private Sub cmbtype_Click()
BlockTextBoxs
End Sub

Private Sub cmdMasterQuery_Click()

Dim fso As FileSystemObject
Dim TempFile As TextStream
Dim TempFile1 As TextStream

Set fso = New FileSystemObject
Set TempFile = fso_OpenTextFile
("C:\Medi\system\Path.txt", ForReading)

If fso.FileExists("c:\medi\system\Path1.txt") = True Then
Call fso.DeleteFile
("c:\medi\system\Path1.txt")
End If

Call fso.CreateTextFile
("C:\Medi\system\Path1.txt")

Set TempFile1 = fso_OpenTextFile
("C:\Medi\system\Path1.txt", ForWriting)

For I = 1 To 5
TempFile1.WriteLine TempFile.ReadLine
Next

CommonDialog1.FileName = txtMasterQuery
CommonDialog1.ShowOpen
txtMasterQuery = CommonDialog1.FileName
If txtMasterQuery = "" Then
TempFile1.WriteLine "C:\Medi\system"
Else
TempFile1.WriteLine txtMasterQuery
End If

TempFile1.Close
TempFile.Close

Call fso.DeleteFile("C:\medi\system\path.txt")
Call fso.MoveFile
("C:\medi\system\path1.txt", "C:\medi\system\path.txt")

End Sub
 
J

Jonathan West

shw said:
Hi

I an studing the link you have send but FYI, the error log
file created this error

Line 2: Property OleObjectBlob in frmmedi could not be set.

What is OleObjectBlob? Where in your code do you set it? What do you set it
to?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top