Answer Questions
GaryMcC I need to copy a linked table - as structure and data, not as linked
Using VBA, do you know the code to copy a linked table, paste as structure and data locally. What's the source of the table data Please provide more information about exactly what you're trying to do. ...Show All
R1ZWAN excel formula
hi, In the formula section, how do you check if the value of a cell is a date Thanks Hi I am not aware of an Excel function that does this directly. Excel stores dates as numbers 1 is 01/01/1900 etc, with the time stored as decimals after the integer. This does allow you to test if the cell contains a number which is equivalent to the date range you are looking for eg the below checks if the value in A3 can be interpreted *** a date between 01/01/06 and 16/09/06. =IF(AND(INT(A3)>=38718,INT(A3)<=38976),"Is my date range","Not my date range") Try this (say A1 is the cell to be checked): =IF(OR(CELL("format",A1)="D1&quo ...Show All
Jason D. Camp Macro stops running after a certain time, excel limitation???
Hey guys i have this problem: I have to run a macro for Excel that calculates some values for the entire 2006 year. To do that it has to open 365 daily files check for some circuits and calculate a sum. It opens a file does some checking, writes some values then closes it, opens the next one and so on. For a smaller number of circuits it worked fine and took about 10 minutes. Second time it opened several files and then stopped with after a file is opened. I used a breakpoint for End Sub but it doesn't reach that. Do you know of any limitations in vba or maybe in Excel PS: I turned off autorecovery Thanks You're right. I think it was my fault. When running in the background i was reading some newspapers ...Show All
BAK62 Address Book Issues
Hi All, Recently we have installed another two more Front End servers and activated with 2nd LCSpool. Now we have two pools pool1 and pool2. Users are in the pool1 and are configured for pool1 and we have planned to move the users to pool2 and remove the pool1. We have set addressbook for pool2 and I want to know: When users are moved to the pool2 is the office communicator client automatcially download the addressbook from the configured links on the pools 2 or it will be still using the same addressbook. As soon as the server name or IP is changed to pool2 will the new full address book is downloaded or the delta file is downloaded. If full abs is downloaded then there will be chances of Bandwidth choke since the ...Show All
ccutrer Compatibility Issue Excel 2000 and Excel 2003
I wrote a macros for a customer in Excel 2003. He didn't tell me he used Excel 2000 until after the project and like an idiot I forgot to ask. The macros will not run on his version of Excel 2000. A compile error shows up. So he got a version of Excel 2003 and the macros will still not work for him. I have tested this macros on other machines using 2003 and they all work correctly for me. I live in the US and the customer lives in the UK. When he runs the macros it immediately goes into the debugging window and highlights a bit of code that simply references the path of the existing folder to a variable. The exact code is: DestFolder = ThisWorkbook.Path & "\" There is a compile error with a message that the data fold ...Show All
Daikoku How to loop a macro every 20 minutes
Hello, I need assistance with some code that will run this macro every 20 minutes in an Excel workbook that is constantly open. I think it needs to loop somehow but it is beyond my programming skills. If anyone can point me to the right Method I would greatly appreciate it!! Michael Hello Michael, Play around with the following and you should be able to get the result you need. ChasAA [Code starts] Sub start() ' Put this in your workbook open event Application.OnTime Now + TimeValue("00:00:15"), "runUpdate" ' I have set it for 15 seconds in this example change to "00:20:00" for 20 minutes End Sub Sub runupdate() ' this is where your code for the updating will go ' the followi ...Show All
Shinmen User form issue
I am trying to launch a user form from a word document using a command button, but I am getting the following error "Sub or Function not defined." The code for the user form is listed below: Private Sub frmSegment_Initialize() With ListBox1 .AddItem "RNA" .AddItem "ISMC" .AddItem "MHS" End With End Sub Now like I stated earlier I want to be able to launch this userform when a user selects the "launch" command button. And to do that I entered this code for the command button: Private Sub cmdLaunch_Click() frmSegment_Initialize frmSegment.Show End Sub However I am getting that error message. This code happens to be in the "ThisDocument" section while the userfr ...Show All
ChiaraE Blocking IM
Hi, Is it possible to block IM for all users in LCS 2005, i just wanto to use Audio Video conferencing feature. Pls help. Ekta We checked with the Microsoft support engineers, and here is what they told us: "IM (read SIP communication) is the basis for communication in LCS. Audio and video conferencing are added functions when you have an IM session open with another user. Hence disabling IM and enabling only audio and/or video conferencing is not possible." We hope this helps. Thanks Lisa (MS ISV Buddy Team) ...Show All
Bill Poole Output property to save as
Hi people, I've been trying to generate a result from a MSXML used with Excel. When I apply the output property sampled below, it shows me a HTML into the message. Now I'm trying to display it right to a sheet or save it in a format xls, no results. Would anyone show me a way Else Set xslProc = xslt.createProcessor() xslProc.input = xmlDoc xslProc.transform MsgBox xslProc.output end if Marcos Hercules Hi Brenda, Sorry for be slow in this reply. I think that some progress was did, but I don't know if this is the right way. I put the adodb in use to save my datas as an xls file but in the end my datas turned in some stranger charcters, something like . After this I added this lin ...Show All
&#246;znur Problems upgrading from Office 97 to Office 2003
Hi all Finally we have upgraded from Office 97 to Office 2003. When I have upgraded my Access databases I have had an error because MSCOMCT2.OCX was missing. I have Microsoft DTPicker controls on most of my forms. I have copied MSCOMCT2.OCX and MSCOMCT2.TWD into C:\windows\system32 directory, but I still cannot see the time and date picker controls in the tool box. My original controls come up with an error that there is no object in the control. Have I missed something Brain in gear now! I have remebered to register the Control! ...Show All
NeedSomeAnswers Live Communications Server tab does not show up
I have just installed Live Communications Server 2005 Standard in my test enviroment. I have a seperate server as a Domain Controller (all servers are Virtual Servers on one physical machine). When I followed all the steps during installation, no errors show up. Also, the HTML log files only display green 'success' items. However, when I open the User Properties window on my DC, there is no Live Communications Server tab. It should show up there, but it isn't. Also, when I open the Live Communications Server Management Console, I only see an empty screen and no 'tree-view' of possibilities. When I manually add the snap in after running mmc, it works and I can see the Forest, Domain, etc. Nothing, except the Management Console, di ...Show All
Scott ODonnell How do I write this!!
I have data in a list listed like this: a 12345 name address ect. b 12345 name address ect. c 12345 name address ect. d 12345 name address ect. e 12345 name address ect. I need to move the data parallel. B at the and of a, c at the end of b ect. Only if the account numbers are the same! But b always has to start in q and c always has to start in U ect. Because not every account will have all a through e. Some will only have a,b,c,e ect. But c always has to start in a certain cell. And when the cells are moved the letter and account number has to be removed except for the very first letter which would be A. Any help would be greatly appreciated. I am not very literate when it comes to vba. Thanks Neal. ...Show All
lushdog Take out the ability to input values on combo box?
How do I take out the ability to input values on a combo box For instaance, if I want the user to select the month I had the listbox down right but i had it before i listed all my items. What do you mean Hi You can set the property "style" to fmStyleDropDownList Great, thank you very much for your help. I had the listbox down right but i had it before i listed all my items. You can set the ListIndex property to 0 in VBA code Combox1.ListIndex = 0 Thanks, that helped a great deal. Now, how do i make it default to the first item in other words, before i put anything in it, i was referencing something that wasn't there yet. ...Show All
steveareno Excel/Word VBA IDE - Additional Controls Dialog Box refuses to display
I have a problem trying to add additional controls to the Controls toolbox The two methods I've tried 1. Right click on the controls toolbox , click Additional controls 2. Menu, Tools, Additional controls Neither of the above produce a dialog box containing the list of additional controls to choose from. Things I have tried so far.... Office Update, Reinstalling Office 2000, uninstalling Office 2000 and installing Office XP (2002) Please help any ideas ...Show All
fflores Automation error : Logon failu unknown user name or bad password
Good Day to all you VB guys ! I am currently dealing with VB Macros meant to perform automated functions on MS Excel file/report. MEANING - the code/appcn i am dealing with is V B A appcn not VB6 appcn - its the VB meant for Macros !! I am getting this error from time to time in various excel reports' execution. Sort of confused ab out how to resolve this problem right at its root ! Error Msg written into the Error Log :- "006-09-08 10:38:53#,"","Batches Completed by FIMP" ,"Automation error Logon failure: unknown user name or bad password. "" I am sure there are many of you here who would have dealt with Macros earlier !!! Can any1 help me Thanks in Advance ...Show All