hello all,

I am tring to write a saved image (*.jpg) on my local c:\temp to a database. I am not able to find the commands to in macro scheduler.

I am able to connect to the database and get information out but unable to write to it.

Thanks
Mirdurern

Thank you all for the great help.

Mirdurern

Hello all, I did a search on the forum and was unable to find an old topic on this. I would like to go to the HaidProduction director with greater then 3000 main folders. In each main folder there are 4 sub folders. One of the sub-folder are called Modelling. I want to go into that folder and pull o...

Hello, First, I would like to thank everyone for all of the great help I am getting in this forum. Today I wanted to repeat my macro so that people did not have to hit F5 each time. I placed a loop if the serial number did not show up in the data base that it ends, but i got an error "A componet nam...

Hello, The WaitWindowOpen>Open appears to work but also the network is not being used anymore. I will test it tomorrow morning. Is the Word Document on a local drive or on the network? The document is located on the network drive. What is the default path in Word? \\jupiter\vol2\SLA\3dImages Clip ar...

Here is some of the code that I use. VBSTART GetSSN = right(InputBox("Enter Serial Number : "),10) Dim SQLString Dim SSN set MyDB = CreateObject("ADODB.Connection") MyDB.Open "shellman" SQLString = "select initcap(fnameupper) fname, initcap(lnameupper) lname from ear e, journal j, person p where e.j...

Hello all, I saw a post a while back about network lag and a way past it. I have done a search but was unable to find it. Here is the situation, at 6:30am the macro runs fine going out to the network and bring data back. Around 8:30am till about 3:30pm it starts to hang up. I have placed Wait> and W...

Here is what I came up with. Thank you all for the help ! VBSTART Function GetName GetName = InputBox("Enter Serial Number : ") End Function VBEND VBEval>GetName,name Label>Start Let>Filename=C:\%name%.txt MessageModal>%Filename% IfFileExists>Filename,end MessageModal>Your File Doesnt Exist %Filenam...

Hello, Thank you for all of your help. Maybe it would just be easier for me to tell you what I want to do and see how some of you write the code to do this process. Being that I feel for some reason I do not understand how to get these arguments to work. Here is what I would like to do. Go out to a ...

I now rewrote the macro and it appears to get the right file name but my ifFileExis still doesnt work. What happens is that it still give me both boxes. Maybe the problem is that I dont understand how Label> and Goto> works. Again thanks for all of the help. Mike VBSTART Function GetName GetName = I...

Hello all, I am new to making macros and ran into a problem on iffileexists command. Any help on how to fix this problem would be great. What I want to do is scan (wand in) serial numbers then confirms if that file exists in a specific path. Here is what I came up with. In addition, any books that y...