Search results for query: *

I like it. Trick the system into believing that the user has pressed the F7 key. I will give it a go. Thanks Anthony

Hi everybody, I have a macro that takes care of saving and sending emails in Outlook 2003. Before I send them I would like to invoke the spell checker on the email. Does anybody know how to do this. I have been looking for the item.spellcheck command or something along those lines for ages...

Hi, does anyone know how i can save a project in microsoft project from microsoft access using vba? so far i have been able to open MS Project, create a new project and fill it with data from an Access query. Now i want to be able to save the project under a specific name in a specific...

Thanks for that tony, thought you had to open the application before you could use it as an object.

does anyone know how i could open MS Project without opening a new blank project from a command line or from shell function in vba. i think i could use a command-line switch or soemthing but i cant find any for MS Project

Hi, when i try to run the following code i get a runtime error 1004 "Unable to set active printer property of the application class" at the line "ExcelObject.ActivePrinter = "\\WS149.Logitech.local\DYMO LabelManager PC" ". The code is meant to open an excel sheet, add a template and put some...

Just Incase anyone was wondering about the rest of the code, here is the whole lot. Private Sub PrintGoodsLabels_Click() Dim NoOfLabels As Long Dim I As Integer Dim ExcelObject As Object Dim XLSheet As Object Dim boolAddAddress As Boolean Dim Response As String Dim YesNo As Integer Const...

when i try to run the following code i get a runtime error 1004 "Unable to set active printer property of the application class" at the line "ExcelObject.ActivePrinter = "\\WS149.Logitech.local\DYMO LabelManager PC" ". The code is meant to open an excel sheet, add a template and put some...

Thanks for your reply. The services were already set to restart. I am not sure why they stop every now and then. Hopefully it wont happen again.

Hi all, We operate a Win2003 server and Citrix server. One of the problems is that sometimes the Printer Spooler service stops and thus anybody that logs on to the citrix server doesen't have any printers. What I would like to do is when a user logs on to Citrix have a script or a batch...

Thanks Peter for your reply. I am currently using a program called Power Controls to read the edb file and extract the emails and move them back into the public folder. I have tried it on a couple of emails and it seems to work fine. I did try to steps 1 to 3 in you post however it...

Hi, One of our users accidently deleted a public folder from our exchange 2003 server. Veritas has three jobs to backup 1.System State, 2.ExchangeIS and 3.Data. Unfortunally all jobs were set to overwrite media meaning that only job 3 is available for restore and has been for sometime now...

Hi all, Not to sure if this post is 100% relevant here but I didnt know where else to put it. All of the office computers (XP and win200) log onto our domain (win2003 server). When they do this a batch file runs mapping the server drives to the client. Each client has a toolbar that...

Its all good I fixed it. I was trying to open a module using the macro but I changed it to a run code and ran the function. It works a treat now Thanks Anyway for you help on other matters Fozzie

Hi everybody, I have created some macro's to set some fields and then perform a process. There are 5 macros in total and depending on which shortcut is executed will call a different macro using the command line parameters /x macro They all run fine in an mdb file but when I convert it to an...

Thanks That sounds like a good idea. I will look into it

Hi everybody, Ok here is the scenerio. I have an updater database that when executed checks the version of another database on the users computer with the copy on the server. If they are different the it copies the server database to the users computer and opens it. Simple. What I would...

Thanks golom and strongm. I currently use the WritePrivateProfile... and GetPrivateProfile... so I will modify my existing code and try this. However looking at your advice I cant see it not working perfectly. Thanks again.

Hi everyone, Its a special text file as it is a cross between a ini file and csv file. I have generated this txt file from a vibration analyser that I made and the format is as follows: [Parameters] SampleFreq=5 NoSamples=256 [Inputs] Ip1=1 Ip2=0 [Data] 1.23,2.11,4.56,5.4,3.1, etc Ok. I...

Thankyou