In Progress

VBA macro to run in Background


I need a Visual Basic Macro that runs in the background.

There are 2 folders: Source and Destination. Whenever a word document is pasted in the Source folder,

Part 1) A VBA macro { say, Source_Macro() , given below } should run on that document in the background (IMPORTANT- In the background), which means the word document should NOT open up, when the macro runs on it.


Sub Source_Macro()

[url removed, login to view]

[url removed, login to view]

With [url removed, login to view]

.Text = "ABC"

.[url removed, login to view] = "XYZ"

.Forward = True

.Wrap = wdFindContinue

.Format = False

.MatchCase = False

.MatchWholeWord = False

.MatchWildcards = False

.MatchSoundsLike = False

.MatchAllWordForms = False

End With

With Selection

If .[url removed, login to view] = True Then

.Collapse Direction:=wdCollapseStart


.Collapse Direction:=wdCollapseEnd

End If

.[url removed, login to view] Replace:=wdReplaceOne

End With

End Sub


Part 2) After the macro has run, the file should move to the second folder, Destination.

I have created the Part 2 below, for your help. You may utilize this code.

Sub BoocMDM_move3()

Dim FSO As Object

Dim FromPath As String

Dim ToPath As String

Dim FileExt As String

Dim FNames As String

FromPath = "D:Source"

ToPath = "D:Destination"

FileExt = "*.doc*"

If Right(FromPath, 1) <> "" Then

FromPath = FromPath & ""

End If

FNames = Dir(FromPath & FileExt)

Set FSO = CreateObject("[url removed, login to view]")

[url removed, login to view] Source:=FromPath & FileExt, Destination:=ToPath

End Sub

> All this should work in the background, something like backgroundWorker, windows service application, etc etc.

I need the source code for the project.

Thank you.

Kemahiran: Pengaturcaraan C#

Lihat lagi: visual basic programming service, visual basic in programming, sub all, string find c, programming in visual basic, programming in vba, need help with visual basic programming, find string in file c programming, find a string in a file c programming, c sharp object, abc programming, run vlookup vba macro, powerpoint vba run macro change slide, vba add ins run macro, run macro name solidworks vba, outlook macro vba phone number, macro vba institute bangalore, run macro opening word document, project 2007 html export macro vba, run excel vba select update filed based criteria

Tentang Majikan:
( 0 ulasan ) hyderabad, India

ID Projek: #10102976

1 pekerja bebas membida secara purata ₹1300 untuk pekerjaan ini


A proposal has not yet been provided

₹5555 INR dalam sehari
(0 Ulasan)
₹1300 INR dalam sehari
(0 Ulasan)