Answer Questions

• Scott Page 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

• firewalker Colored Named Ranges

  Hi, Am trying to color a particular cell in an excel sheet based on the values of other cells. For eg i have the value 10 in cells a2 till a10.I want the macro to scroll through these values and compare each one of them with a cell in the same worksheet(say F2) which has a value of 10.If all the values in the range a2 till a10 are 10 then color F2 with green.If one or more cells in Range("a2:a10") are not equal to the value of Range("F2") ...Show All

• EnzoMa read only file opening

  Namrata Prashar wrote: Hi Josh, thanks for the mail. i guess i was not very clear with my description of what i want or alternatevely what i am trying to do with the application. well, let me try again, so that you can help me .... i have an excel application called PDD_NP which is supposed to ask for a directory where it wants the apllication to run. PDD_NP then reads the directories and sub-directories and finds all the ...Show All

• Kirangazz Problem With Code That Writes a Change To Itself

  I have written a sub that modifies the code in the if statement of a functon in a different module. Trouble is that during runtime, I haven't found a way to get the equivalent of a Compile VBAProject to occur so that the behavior of the function actually changes on the fly. Even though the code is changed by the technique, the behavior when called always stays v1 > v2. Isn't there a way via the VBIDE classes or something to get the recompile ...Show All

• M i k e Increase Speed of a Word Macro

  I have written a macro in MS-Word for formatting of documents. It finds the carriage Return character and replaces it with Null. For a 60 page document the macro takes approx 1 hour to complete. I have tried following options 1. Increase Virtual Memory 2. Increase RAM from 512 Mb to 1024 Mb. 3. Turned Off Spell Check and Grammar Check. but nothing has helped. Can anyone please tell me how to increase the speed and decrease the execution time ...Show All

• anakanak10 Can not connet to BSM server

  I just finished installing BSM Server, however I can not connect to the server. I keep getting an error: " Connecting to server http://localhost:46786/ has failed. Any ideas on how to troubleshoot this problem. Thanks in advance! Have you looked at the Applicaiton log I think there is somethign wrong with BSM to connect to WSS database. Please configure and try again. HTH, JP Hi, ...Show All

• Mohamed Barakat Source Object as a query

  Hi i have a form that contains 2 text box's and a subform what i really want to do is to run a query and not have an input box popup i would like the dates entered into the 2 text box's to be used in the query of the subform and display a table that shows all records that are between date 1 and date 2. SQL code: PARAMETERS [First] Text ( 255 ), [Second] Text ( 255 ); SELECT Equipment.* FROM Equipment WHERE (((Equipment.[Date Installed])>[Firs ...Show All

• Perky Swenson Worksheet_Change Error

  Try this. Paste the code below into an MS Excel Objects into a worksheet. Such as Sheet 1. After that in any cell you type "x" it will change the color. However I get a run time error if I try to select an error. Type mismatch '13' Basicly when I type an x in any cell I want it to change the color. If I delete the x I want ti to change back to normal. If you have any other ideas on how to do that it would be great. Or if y ...Show All

• etorres Program code fro sorting coloumns in a listbox VB Excel

  Hi I have in my UserForm a listbox, where I capture the A2:G10 in Spreadsheet1 And my problem is that I want to manage to click on the column header (in the listbox of the userform) to sort the coloumns. I hope that someone pls can help me sort this out! tullaolsen;) Hi Derek, Thank you for replying to my question. It was a good answear I got, because then I know that it isn't possible to get that functionality in t ...Show All

• JardaJ Save Each page of a Word merge as a seperated pdf file

  I have a word merge, and I need to save each page as a seperate pdf file. I would think i could do something like a for each page in document.pages and then use the Contact field in the doc to save the file, I have never worked with word vba so my excel experiance doesnt seem to translate as well as i thought it would Thanks All Per our support engineer: We must insert a page break in the word doc to identify the page ...Show All

• Ulrik Sorensen 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

• .net_Coder Is Partner program open for non-consulting/non-ISV companies?

  We're a company that is building a web based product to be offered as an online service. Our platform is all Microsoft based using the latest .Net technologies. My question is whether our company is suitable as a Microsoft Partner I'm having difficulty identifying the best Competency for us as a company. Any insights are most welcome. Regards, Neil Thanks for the responses, I put a call through to the Partner Program Service ...Show All

• McPhisto77 MS Zen sublime

  This is on the 'contact Us page for e-learning support" support "Technical support are unable to answer questions regarding technical information regarding software." This is just about on a par with the ultimate legend:- "keybord not present, press F1 to continue" We'll, um, share this with the e-learning team... Brenda (ISV Buddy Team) ...Show All

• Matthias123 Suppress Linked View Unique Record Popup

  Hi there im linking a view on an ms sql server to my access database using VBA using DoCmd.TransferDatabase acLink, etc.etc. How ever, I can NOT get the `Select Unique record Identifier` pop up to stop coming up when the link is being made. I dont care about needing a unique identifier, its a read only record source. The only way ive found is using sendkeys command to cancel the popup - however this can not be relied on, if it happens when the u ...Show All

• Noelle Problem with deleting records

  HI, I am using the following function to delete a record from sysDeptDef table which is not present in ups_new table. I have two rows for the same deptid but diff attid. when i use the delete command the two rows get deleted but when the loop executes it cannot find the deptid so it fails.can please anyone suggest me how to handle this situation. Dim CurrentLevel As Integer Dim CurrentDeptId As Variant Dim LevelUp1 As String Dim L ...Show All