thanks for replying guys! i added it in my code
(wrdApp.Documents.Open "C:\Program Files\DAS\Report.dot", False) but it is still the same when i clicked on the file>save as. =(
does anyone knows my problem? i'm almost done with my project. the only problem i have now is to make the SAVE AS TYPE as Word Document(*.doc) instead of Document Template(*.dot) and the default file name should be Document1.doc instead of Document1.dot. please help me. thanks. =)
yes, user can also click on the save as under file menu but when the user click it, the save as type should be Word Document (*.doc) instead of Document Template (*.dot) and the default file name is Document1.doc. thanks! =)
hi tryp,
it's working now. thanks for replying. =)
i just inserted the saveas command in the function below: i'm just wondering when i click on the file-->save as, the value of the save as type is Document Template (*.dot) and the default file name is Document.dot. i tried using the command...
Hi guys! Thanks for replying. I already solved my problem in passing value from VB to Macro. My another problem now is to rename the document as Document1 when I open the .dot file. Here's my code below in VB and Macro:
---VB 6.0---
I've placed this code in one of the modules in VB:
Function...
Hi guys! Thanks for replying. I already solved my problem. My another problem now is to rename the document as Document1 when I open the .dot file. Here's my code below in VB and Macro:
---VB 6.0---
I've placed this code in one of the modules in VB:
Function OpenReport()
Dim wrdApp
Set...
Thanks for replying. I actually have no idea in creating macro. Could you give me steps in creating Macro? This project when assigned to me already exists and I'm just modifying it. I just did some search in order for me to open the existing macro which is the .dot file. All I need to do now is...
Hi Everyone! I'm just new in Macro using MS Word 2002. I already have an existing macro. I called the macro from VB 6.0. The document I was calling is to open a .dot file. When it opened, I just want to rename it as Document1 instead of the .dot file I was opened. Please help me if this is...
Hi Everyone,
I'm just new in macro using Microsoft Word 2002. I just want to know if it's possible to pass a value coming from VB6.0 to macro using Microsoft Word 2002? Please help me. Thanks.
O-oh!! I have a little problem out here again! I can't pass a parameter in which I saved my text file from my local. How can I pass a parameter to Macro?
I should pass the value from Visual Basic to Macro to open what I created in my desktop. Is it possible? I should display the records from...
Thanks for replying Cathy and ClulessChris!
My Macro was in Word. I just want to open it automatically without clicking the run command in Microsoft Word 2002 when called in VB 6.0. =)
How can I set my macro to run on open, set it as document and open the file from template? Is it from the code?
Here's my code in vb below: This will just open the document but needs to run the macro instead of automatically opening it.
Private Sub Command3_Click()
Set wrd = New...
Thanks for replying. I'm new to macro and I'm having a problem opening it. Here's my code below and the error I'm getting is "Main() Error -2147352573 - Unable to run the specified macro". Tell me if it's right. Thanks.
Application.Run MacroName:="Fumiguide Report.AutoNew.Main"
I inserted...
Hi Everyone,
Does anyone knows how to call/run macro using visual basic 6.0?
I have an existing document with macro on it. I've tried to make a new project in visual basic 6.0. I've created new button in the form. If I click that button, it should automatically call the document and should...
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.