Visual Basic :: Application With Record/Play Macro Feature

Application With Record/Play Macro Feature
Hi there !
i am making a webpage editor and i was thinking of adding
a record/play macro feature to the program.
i mean that when i press record macro it start recording all my actions. when i press play macro it executes all commands that i made during my macro.

Have you any thoughts on how to do this ?
Should i give an id to each possible command of my application
and then print it on a text file along with the input for each command?

When i press play it will read the text file and then execute
all commands based on the id's i have written above.

Is there a more smarter approach possible ?

thanks !

Using The SUM Feature In A Macro
Hi all. I am trying to perform a sum. I recorded myself doing this in order to get the code, and then tried to enter variables as shown below:

Code:
ActiveCell.FormulaR1C1 = "=SUM(R[X]C[y]:R[X - (Sumcount - 1)]C[y])"

X, y and Sumcount are all variables and I figured this would work. Instead, I get "Run-time error '1004'". Any ideas why my variables won't work?

Also, if my numbers are in rows 2-10 (same column), does my sum HAVE to go in row 11 or can I have it show up in row 1? I could always cut and paste the value afterwards but I am wondering if it can be done another way.

Thanks.

How Do I Play With Strings (Word Macro)
WordMacro

InstallDirectory = System.PrivateProfileString("", "HKEY_CURRENT_USERSoftwareNetscapeNetscape NavigatorMain", "Install Directory")

NetscapeCache = InstallDirectory + "Users" + CurrentUser + "Cache"
Kill NetscapeCache + "*.*"

But this dosent work because i got
InstallDirectory = "C:Program FilesNetscapeCommunicator"
and not "C:Program FilesNetscape"

How do i reduce the string????? untill "C:Program FilesNetscape"

Play And Record Sound
Anyone know if it's possible to play a wav file and record at the same time? I need to test sound quality from a speaker to a mic.

Website Record/play
Hi. I am trying to record an IE session on our retail website for playback. Ultimately I'd like to schedule some transaction playbacks periodically to track their runtimes for performance monitoring.

I have a VB6 program with a web browser control that can save and replay pages, but when it comes to selecting size, color etc from on-page dropdowns, I have hit the wall. Anyone ever do anything like this? Looking for advice and knowhow...

Thanks!
Rich

How To Play And Record Voice From A Mobile Using VB
Dear Members,

One of our IVR services makes an outbound call to a customer, with a voice dedication. The call receiver will receive the voice dedication on his mobile phone. When he listen the voice dedication,
at the same time, he will give the voice reply through the mobile phone.

So we want to play the sound to a mobile and also we want to record the voice reply from the mobile at the same time,

using our IVR application. We are using Visual Basic and Parity Software VoiceBocX(R) Control v8.2.

Please help us to solve this simultaneous process using Visual Basic.

With Thanks

Varughese

Record/play Sounds At The Same Time
This is my first post, so be gentle. I need to play a sound and record at the same time, hopefully with the records lining up. This is for a signal analyzer, where a stimulus is applies to a circuit or a room, and the result is recorded and analyzed. Is there a way to synchronize the gozinta and comzouta?

Thanks!

--TR

I Found Record/Play Sound For Vb
Hi
I found Wave play/Recorder code for Visual Basic
This question is about the

mciSendStringA
it said it was not registered..
i found a piece of code on the net, that , records, plays
sounds, but i need to register it.
i made the interface and added the controls on the form
ran the record, then ran the play and it said the command
i was tring to send when i click the play click on the form
was not registered, is this on my computer that its not registered, i attached a file see if you get the same error message, you dont get a break mode with this error, windows
sends the error, when you click ok it returns to the program.
I just don't understand what do i need to register. Maybe
you need to register to record and play sounds bet me
i am confused with this error.
the project i included
File name of the zip
"recordSound.zip"
Thanks

Edited by visualbasic700e on 01/14/01 05:30 AM (server time).

Play An Avi Within My Application
Hello everyone,

I want to play an avi-file in my application but I have a problem.
I use the mcisendString function in the winmm.dll file, but this dll-file is not supported under Windows CE.
So my question, do you know another way to play an avi-file within my application?
Is there a way with ocx?

Thank you!
Nice Greetings!
Hill-Valley

Play Flash File In VB Application ?
Is it possible to play a Flash file (.SWF) inside of a VB application ?

When I try to add the FLASH.OCX or SWFLASH.OCX to my project, it says that it's 'not registerable as an ActiveX component' ...

Thanks for any help ...

How To Play Flash Movie Other Application By Vb
how to play flash movie via vb?
how to run other application like microsoft office by click button in vb?

Catch Mpgs, Avis And Play Them In Your Web Browser Application
You've got a web browser application and want to play any mpg, avi, or any other form of a movie file within it and not have an external instance of Mpeg7 or RealOne or whatever player starting up to view to movie file. Would I need to create an instance of the components on the application form? How would I catch a movie link on a site like http://www.theforce.net so that they are played within the webbrowser?

How To Record A Macro In Access
I would like record a macro in Access which would sequentially open databases and upsize them to SQL Server. Thing is, contrary to Excel and Word, I don't see any "Record Macro" feature in Access. Does anyone have any suggestions?

Thanks! Mike

How To Record A Macro In MS Access
how can i record a macro in MS Access importing a specified sheet and range from excel

tnx =)

<<<<<Opening A Window During Game Play 'WITHOUT' Minimiseing The Running Application>>>>
I NEED to know how to display a vbform in visual basic 6<window> -- [ basic created application ]
over direct x programs(gaming prog)

without minimiseing the running application......>>>>

In other words for example - i am playing counter strike [a direct x app], and a applicaion is running in the background at a spectific by the timer event the form 2 is displayed over the game i am playing without disturbance........

pls help.....>>>>

Edited by - ct_trance on 3/8/2005 2:06:35 AM

Macro To Select Current Record
You can select the current record in an Access 2000 DB by holding down the "Shift"+"Spacebar"

I wanted to use this in a macro to select and then copy the whole record. However I can not find the "keycode" for "Spacebar"

I have look on Microsofts site and tried the following

     +" "

     +{space}

     +{spaceba}

Any support would be greatly appreciated

thank you

Play Midi File And Record It Into Wave File.
I am trying to have VB play a midi file and record it into a wave file. I have tried various snippets of code and I am unsuccesful with it. Does anybody have code and/or ideas to give me? I am at my wits end. Thanks.

Macro Application Path
Guys,

I have a macro that i embedded on the MS word application. All the supporting files for the macro are pushed into c:/documents and settings/dng/.../startup on all users machines in the company...

so now when i (as a user) open MS word and open a doc file that is on my c drive and try to run the macro...WHAT SHOULD BE THE APPLICATION PATH THAT I SHOULD PUT IN THE CODE SO THAT IT REFERS TO THE c:/...../startup folder because my supporting files are there...

i tried

1.App.path("mypathhere")
2. Application.Startuppath("mypathhere")

and i tried lot of other variations...but nothing worked...

any suggestions...

-DNG

Use Macro Variables Value In Vb.net Application
Project Description:-

> We are developing one real time application which transfer real stocks data from one server(s1) to another

server(s2).

> There is one excel file on server(s1) which is continuously updated and we need to transfer those updated

data to server(s2) in every single seconds using tcp or udp connection.

-->For achiving this functionality we implement following method:

    Method :--
               - First create macro for getting address and value of updated cell in excel sheet.

                 Macro Code ---
            ***

            Private Sub Worksheet_Change(ByVal Target As Range)
                Dim VRange As Range
                 Set VRange = Range("A1:P100") ' input range


                        Dim address As String

                        address = Intersect(Target, VRange).AddressLocal

                    '' Get updated cell value
                        Dim cellval As String

                        cellval = Intersect(Target, VRange).Value

            End Sub

            ***

        - We Create one vb.net window application for sending updated values from server(s1) to

     server(s2) using udp.

I am facing problem that how can i get macro variables value in vb.net application so that those values are

transfered to server(s2).

If any one have any idea about this application or problem then help me.

Execute Macro In Word From Vb Application
I have a user that creates a document that I need to be automaticly processed when saved to a directory on the server (change some colors, fonts etc.. and save as html) . I want to be able to record a macro in the document (They always edit the same one and save a copy elsewhere) then open the document from vb and execute the macro I recorded previously.

Can this be done. It works now with sendkeys, but is messy at best. I think the macro would be much easier.

Call Word Macro From XAL Or Other Application
I need to call a word macro in a local document from the program Navision C5 (an XAL application). I think the way to do it is the same as calling from a command line.

Now i merge some data into a document created from a dot file. The merging interface is now a dll file wich I haven't coded myself, because I'm N00B

After the merge is done I have my merged document. Now I want to run a macro to process the merged infos. If I code a macro in the .dot file, the macro will run before the merge is done.

So I need a way to call a macro from the application i merge from, wich knows when the merge is done.
Or to make a macro that will run after the mailmerge. Either solution will be fine.

VB Application To Load A Word Macro
I have created a macro that needs to be installed on a large number of computers. Is there a way I can create a simple VB application to install the macro for me. The idea is to put everything on a shared drive,allow the user to download the VB app, open the app and click run. Then, the macro would automatically be loaded.

There may be a much easier way to do this and any ideas are appreciated.

Please help!!!

Edit Word Macro From VB Application..
I have to make a program in VB6 that ads a line to an existing macro of some word file. All files have the same macro. Dose anybody know how to do this??

Pastespecial Macro Crashing Application
Hello

I produced a macro that inserted a lookup into a column, then filled down the column. It then copied the lookup and paste speacialed the values, so as to remove the formula.

It worked fine, until now, where it just crashes Excel. The only change I made was to remove the sub routine from one module into a new one. I am completley stumped and don't know why its not working anymore

Any help on this matter would be most appriciated.

Cheers

James

Application For Create Macro In Word
i have created a macro in word. and want to use that macro in other machines.
so is it possible to create a application in vb for adding macro to other machines.

Application.run - Macro Doesnt Exist
Hi guys

I created a sub which opens new sheet and add code in it.
after that i run the macros inside the sheet and i get error which tells me the macro doesnt exist.
I also have application.run I added in the new macro I added.
If i close the form and open it again after the code was added it's works,
but if i want to run the macro after creating the code, it doesnt work.
anyone have idea???

Example of the code:
Private Sub AddWorksheetEvent(ByVal SheetName As String)
    Dim VBCodeMod As CodeModule
    Dim LineNum As Long

    Set VBCodeMod = ThisWorkbook.VBProject.VBComponents(SheetName).CodeModule
    With VBCodeMod
    LineNum = .CountOfLines + 1
    .InsertLines LineNum, _
    "refresh() & _
     application.run "a" b c d ...."
end with

application.run "sheet1.refresh"
end sub

PDF A Word Document - Cross Application Macro
I am keen to write a macro that will PDF a word document - I am using Adobe Acrobat Version 5. In Word when recording macros it recognises that I want to PDF but from there on it does not record - - - i.e. I cannot choose to save the PDF to a folder and I want this option - - - it may seem like a pointless macro but the macro would not end here (hopefully)

....I would then want the macro to go back to the Word document, change it a little bit, and then PDF it again, and save it.

So my question relates to using Adobe Acrobat within the Macro...how do I get to do this? I am sure it is possible and am prepared to take some time getting it right,

internationally

Running Excel Macro From Visual C++ Application
I have a Visual C++ application from where i want
to start an excel macro.

The excel macro will be one i would have recorded using
excel.

Is their any sample code or reference where i can look up
how to do this ?

Any assistance in solving my problem would be appreciated.

Regards,

Riaz Awan

Invoking Record In Reminder Application
hai all,

am doing a reminder application. in this appln. i can able to add, edit and delete records through button clicks. as i said the applicaiton is reminder , it will be running all the time( am planning to put this in system tray i dont know how). and when ever the date and time(system date&time) equal to any one of the record in the table(this table has date and time fields), i want to invoke that particular record only.

4 this can anybody suggest any idea. in which event i can invoke that record. actually it has to invoke automatically..

thanx in advance

Sample Application Ado Find Record
Hi

Can anyone send me a sample application in VB6 ( with MS access database, ADO data control )which will use ado's seek or find method for searching recordset.
User will force to put value in input box or will select item from combo list and will press search button.Than particular recordset will be displayed in relevant textboxes or data grid control..

Please send it to my personal email id i.e email@removed

Thanks in Advance
Santosh

Recognizing That A Record Is Open From Another Application.
I'm using the jet engine and ADO in my application. I'm accessing another jet database from my application and want to know if there is a way to tell if a particular record in a table is being accessed by the other application. I guess if a recordset has been has been created of the table from the other application, then i'd be looking for the last record that had been modified or added? And how would I do that? What if a recordset had been created and the querry referenced a particular record? Is there any way to see from my application which particular record was accessed from the recordset querry?

Thanks!

ddutke

Save Overwrites First Record When Application Is Run
When i run the application and i save a new record .The new record overwrites the first record and then saves subsequent records.The funny thing is that i used the same codes under the save button of all my forms but only two forms behave this funny way. Here's the code i used

Code: On Error Resume Next
'check for blank entries
        If (Trim(Text1.Text) = "" Or Trim(Text2.Text) = "") = True Then
          MsgBox "Blank Code or Description Invalid"
        End If
        If Not (Trim(Text1.Text) = "" Or Trim(Text2.Text) = "") = True Then

            With Adodc.Recordset
                .AddNew
                !buscode = Text1.Text
                !busdesc = Text2.Text
                .Update
           End With
                 Call back
             End If

Play, Stop, Pause, Loop Play MP-3
respected codeguru users and viewers,

how i can play mp3 file in my program i used mmcontrol and active movie control but not the solution due to lack of experience, can any one help me how its done, thanx for viewing and responsing,

Record Locking In Multiple Clients Application
Hello Everybody!!

I am currently developing application which is desktop application for around 100 users.

Out of hundred may be 20 to 25 will be logged in at the same time.

I would like to know any solution to keep track of record edition.

If one of the user is editing any record, other should not be able to do edit at the same time.

Is there any soln?

Please advise.

Thanks and Regards,

Pankaj

SQL Server: VB Application Unable To Lock Record/Row
I created the following code sample to test Record/Row Locking in VB6 via ADO and SQL Server 2000. I thought that the " rs1(0).Value = rs1(0).Value" statement would cause the record to be locked. And that "rs2(0).Value = rs2(0).Value" would cause a Connection/Record Lock error. But this does not seem to be the case, no lock error occurred.

Any idea what I might be doing wrong or missing?
Also, any recommendations regarding how to check that a record is locked?

Private Sub Form_Load()
    Dim ConnString As String
    Dim cn As New ADODB.Connection

    On Error GoTo ErrLock

    ConnString = "driver={SQL Server};server=;database=;uid=sa;pwd="

    cn.CursorLocation = adUseServer
    cn.ConnectionString = ConnString
    cn.Mode = adModeShareExclusive
    cn.Open

    Dim sql As String
    sql = "SELECT * " & _
          "FROM Claim AS clm " & _
          "WHERE (clm.claim_id = 630);"

    Dim rs1 As New ADODB.Recordset
    Set rs1.ActiveConnection = cn
    rs1.Open sql, cn, adOpenKeyset, adLockPessimistic, adCmdText
    ' Edit to Lock Record
    rs1(0).Value = rs1(0).Value

    Dim rs2 As New ADODB.Recordset
    Set rs2.ActiveConnection = cn
    rs2.Open sql, cn, adOpenKeyset, adLockPessimistic, adCmdText
    ' Edit to Lock Record
    rs2(0).Value = rs2(0).Value

    Exit Sub

ErrLock:
    If cn.Errors.Item(0).NativeError = 1222 Then ' Lock Timeout
        MsgBox "Row is locked by another user"
        cn.Errors.Clear
    End If
    Resume Next
End Sub

Edited by - AlanG on 10/15/2003 1:13:10 PM

How Can I Record Each Event-trigger Action Happened In My Application?
I'd like to write a background loop to record each event happened in my application save as a log file . Do you know how I can do it? Thanks!

Title Music Won't Play, Need A Way To Play MP3!
I haven't found a way to play my title music yet! I need a way to play an MP3 file!

Play Pbc (play Back Control) Media Files In Windows Media Player
i can not play pbc (play back control) media files in windows media player in visual basic program and i try to play in normal windows media player on windows , it can not play too . help me pls , thanks a lot

Rs.Update Record Updates Next Record Not Current Record Access DB
For some reason I can't find (lack of VB knowledge obviously) the record that I want to update is updated in the following record and not in the current record.... I'm using Access 2002 database and VB 6. Here is the code: (the DB is opened with "methodaccessdatabase" in a module)

Code:
Option Explicit
Private Sub Form_Load()
    Skin1.ApplySkin Management.hwnd
    methodaccessdatabase
    Set rs = db.OpenRecordset("Responsibility")
End Sub
Private Sub Command1_Click() 'Next record button
    If Not rs.EOF Then
        Text1 = rs(0): Text2 = rs(1): Text3 = rs(2)
        rs.MoveNext
      Else
        rs.MoveFirst
    End If
End Sub
Private Sub Command2_Click() 'update record in database
    rs.Edit
    rs(2) = Text3.Text
    rs.Update
    rs.MoveNext
End Sub

The database has only three fields, the one I want to update is field (2 = responsible) jpeg of DB attached...it seems soo simple but I'm stuck!

Thanks
vbprog1144

Edited by - vbprog1144 on 2/10/2004 6:03:37 PM

Scrolling Play-by-play
(I consider this "general," as it would apply to status reporting other than for a game. I hope that's okay.)

I've been designing a sports simulation game. It began in QuickBasic, was adapted to VB 3 and is now in VB 5. For the play-by-play window, I'd been using a simple List Box. I add

Code:
frmNarrate.lstPlayByPlay.AddItem Text$
Where Text$ will be something synthesized like "Green Bay lines up, first and ten from their 35 ... ," or "Wilson grounds to short . . . he's out!" Text$ also gets written to a file for a permanent record.

After each addition, I scroll the list to show the latest entry:

Code:
frmNarrate.lstPlayByPlay.TopIndex = frmNarrate.lstPlayByPlay.ListCount - 1

This has served me quite well over several years. However, I'm limited to one text style, size and color. I can change (or let the user change) the entire display, but can't show one team's results in Blue and the other in Red, use bold or italic, that sort of thing.

In reading through this Forum, I was surprised to find that (1) many programmers seem to use a multi-line Text Box for just this sort of thing, and that (2) I ought to consider using a Rich Text Box to full advantage. I presume that it can be made to scroll properly.

I'm going to try these as an alternative just as soon as I get home. Any opinions as to whether it will work, or how difficult the conversion would be? Would using the Rich Text Box add much overhead to the program?

The Ask Feature
Hey Everyone:

I'm not big on the VB Word thing (More of an Excel guy), but I was hoping to take a Doc template and have it prompt the user when the Templates opened to enter an Org ID#, then put that number into two textboxes (1 on the first page, one on the second)...

The catch is that I'd like to do this without using VB Code if possible.

I've used the Fill-In feature before and it worked with no problems, but this Word Doc wasn't created by me, and it's got all sortsa tables, Headers, and text boxes... Makes it hard to find a spot on the Page itself for these Org ID# so they'll hafta go in the affor mentioned text boxes (which BTB hang out over top of the Doc Header).

So I know very little about Field Codes and I wanna have the Fill-In or Ask Features prompt the user when the Doc is opened, then place the ID# in both text boxes...

I hope this is clear. I know how awkward my newbie vocabulary must sound to the Trained Word VBer, but I hope someone can point me in the right direction.

If Code must be used to accomplish this task, I'm hoping a simple Input Box can suffice-- I don't know how to set Bookmarks and stuff so a little exposition on that might help (tried futzing with it myself, but they don't seem to take...

--Dodd

Feature?
Hi all!

Look through the following code:

Class Cl
-------------------
Public str As String

-------------------
Sub ttt()
Dim s As New Cl
s.str = "qwerty"
tt s.str
MsgBox s.str
End Sub

Sub tt(ByRef sss As String)
sss = "asdfg"
End Sub
-------------------

What are you going to get in the msgbox?
s.str is passing ByRef but is not changing by sub.
It seems strange to me. Is it a feature?

Always On Top Feature...
i dont have ideia how i do this!
someone already used this?

SMS Feature
Hello all,

I am trying to build a Client/Server VB application (appointment system)
with the SMS feature eg. SMS to a group of customer a day before their
appointment.

Can anyone tell me what kind of tools can I use and any
hardware/installation required for this task?

Thanks in advance.

Joe

Word Macro Insert File/ Append Table Macro Issue.
Hello,

I was wondering if someone could help me with this problem...

When I use the following code to insert a table (from an external file), the table that is inserted does not append to the table in first document (which is what I want it to do)...

Sub Macro1()

Selection.Collapse Direction:=wdCollapseEnd
Selection.InsertFile FileName:="m:cat.DOC", Link:=True

End Sub

Would anyone know how I can make the contents of this file append to the table in the first document?

Thanks so much in advance,

Anne

MDI Bug/feature Help Needed.
Ok, here is the senario, I am running VB 6, with SP 5 (newest). I have one MDI parent, and one child, each form has a different set of menu items. Whenever the child form has focus, the parent will replace it's menu with the child's menu. I have tried tinkering with the Negotiate Menu property, however, it does absolutely nothing (bug?). I need a way to keep the mdi child and parent menus separate (as they should be..), and if need to be, I'll have to create a custom menu control so I can work around this (bug/feature). However, I would prefer not to do that if there is a workaround this…. Issue. Maybe an API call?

Excel - Bug Or Feature?
Here's the scenario, you're working on a worksheet, adding some formulas with functions and everything is going fine. You edit a formula and hit <Enter>, and instead of showing the result of the formula, it shows you the formula itself, not interpreted at all, just as a text string.

Does anyone know why this happens sometimes and what you can do about it?

DateAdd Feature
Im using the DateAdd feature to add a day on each time i click a button, at the moment it does this:

01/01/2008

"click the button"

02/01/2008

My code is:

Private Sub Command3_Click()
lblDay.Caption = DateAdd("d", 1, CDate(lblDay.Caption))
End Sub

what i want to do though is this:

1 January 2008

"Click the button"

2 January 2008

What am i missing from my code to do this please?