Answer Questions

• Bob McCaffrey Controlbutton settings

  Hi, I have a little big problem. (I am a beginner) So : I made in access a form wich contains several control buttons, which are linked to a table. each button has the name (original) Command + number there are 4 main buttons, which charge a specific table when you click on them. so far so good. these tables are a listing of types. each type has a name and a code I search a value with Dmax Now I need : 1) a series of invisible ...Show All

• nbaker MS Office document and image writer print driver

  Besides removing this feature from Office during setup, is there a process to remove this virtual printer from 300 users with roaming profiles on an active directory network We are having an issue with this printer assuming the "default printer" selection for our users. As a work around we have changed their default printer, but after they reboot or log off / on it has defaulted back to the MS Ofc doc and image writer printer. ...Show All

• Mark Allen 50 cannot save file as

  I can't save any files on any of my other drives. The message comes up as save file not responding. Also szAppname:WINWORDEXE, szAppver:11.06568.0, szModname:hungapp. Why can't you ever get help from microsoft without a fee After all this is their product. Everytime I click on your link for the hpfix, I get taken to hotmail Okay, I found the answer! Download the fix from Kelly's site and save it to ...Show All

• William Christenson Custom file description keywords: read/write in VBA via API

  In Windows Explorer, I can select a file, go to properties, and under 'summary', I can input keywords into the description, for use later when searching for the file. I would like to be able to read/write these file keywords via VBA. I assume I need to access the Windows API, but more than that, not sure what library etc. I would need to use. Can anyone advise me how do to this            & ...Show All

• SJS19859 unloading a function

  I have a question i am writing a program in Outlook. I have a button on a userform that when I click it I want to unload a function in a module from memory. I thought I could just put this in the click event: Unload Project1.Module_Name.Function_Name However, that just runs the function again. Also, I would like to know, is there any way in vba to say "unload all functions and subroutines" Anyone got any ideas thanks, Dudeman ...Show All

• yusufiye VBA for Powerpoint

  Hi, I have been asked to modify a powerpoint presentation so that from a series of jpg files, one appears on the screen and then after a specific time period disappears and is replaced by another; this being a continuous loop on one slide only - like a photo tour. I have the following code, but need to get it up and running. Any suggestions: Sub ImportABunch() Dim strTemp As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As S ...Show All

• AkhilaL MSFT How can I determine if a character is number?

  Hello all, I am new to VBA. I am writing some macros which manupulate strings. Do you know any built-in function of VBA (Excel) which checks if a string or a character is number or character Do you know any web url which contains useful VBA functions like the onw that I am asking Thank you in advance, Kostas Use the Val(string) Function. Try MyNumber = Val(string) ' the string being your c ...Show All

• Dima671 saving exel data

  i like to make a program  in visual basic where  at first i will open a exel file.then in a WORKsheet i will include some data and then it will save as a ms access(as a mdb file)all will happen in my program..then i will can do some quaries in access and open it in my program as a .mdb file. kindly help me. per the support engineer: Please clarify the requirements: Please let us know the version of Vi ...Show All

• Anoop PS Dialog Box, Searching for keywords in an Excel Workbook

  Good morning, afternoon, evening... I need to create a little macro in an Excel workbook, that woud allow the user to type a keyword or a phrase, and check if this phrase or keyword exists within the same workbook or another (I guess I would just need to change the path of the work book). The rule is the following: - If the text entered is in one of the cells of Column A of each worksheet, the returned result will be the content of each ...Show All

• ToryPatnoe Programming with MULTIPAGE

  Hi. I added controls in the multipage like text box, combo box and calendar button. The problem is there's no event for each control inside a multipage. I can put values in the combo box, I want to place values into another combo box based from his choices of the previous combo box. I hope you could help me on this. Thanks! Hi, The events of the controls held in the mutipage are still usable. If you double ...Show All

• Wassup a big thank you!

  Hi All, I just wanted to express my thanks to Derek and all of you who have stepped in to help your fellow coders! It takes some time on my end to escalate these questions and I'm so glad that many of you are getting answers to your questions more quickly with the help of other community members. - brenda (ISV Buddy Team) I love to code, so i'm glad i can be of service to anyone who needs help. (^_^ )-b Every once and a while, b ...Show All

• Nelson Alembedayo What is the difference between SET and Assigning a value to a variable?

  Hi, Can anybody advise what the difference between SET and assigning a value to a variable Example: Sub NewWorksheet() Dim ws As Worksheet Set ws = Worksheets.Add ws.Name = "New sheet" End Sub =================== Set ws=Worksheets.Add vs. ws.Name="New Sheet" Why not just write ---> ws=Worksheets.Add ----- for the former Regards, Patrick Just to expand o ...Show All

• Jim Hollcraft Novice VBA User needs help with using data from input box for Cell Find

  Hey all, what I'm trying to do is take data that is entered by the user in a InputBox and using it in a cell find. However, my code doesn't work. Any thoughts/ideas Thanks! Dim Message, Title, MyValue Message = "Which channel name do you wish to choose "    Title = "ChooseOriginalChannelName"    MyValue = InputBox(Message, Title)        Cells.Find(What:="MyValue", After:=ActiveCel ...Show All

• Suhas Deshmukh Calling VBA code from ASP

  Hi, I just wrote several pages of VBA Code to automate some Powerpoint processes. Now I need to call these processes from a ASP file. Is that possible Or ist there an other / propably better way to automate the Application when being called via a ASP application. Or do I need to use COM cheers mat Hi Mat, Here's the response from our support engineer: I understand that you want to use Office automation at server side. We do not r ...Show All

• SunilKannan A question on the ISV/Software Solutions competency customer reference requirements

  Could you please clarify the ISV/Software Solutions competency requirements for customer references The “Competency requirements” web page ( https://partner.microsoft.com/40012621 ) reads: “Submit at least three customer references for tested packaged software solutions. The solution must be a business application, deployed for a minimum of five users.” I have the following questions related to the quote above: Do the references have to be ...Show All