Search results for query: *

Does anyone know how to include the User Name in the ODBC driver by using the following code?? Thanks, set WshShell = wscript.createObject( "WScript.Shell" ) const ODBC = "HKLM\SOFTWARE\ODBC\ODBC.INI\" sName = "Name" sServer = "Server" sDesc = "Description" sUser = "UserName" dim ODBCS...

I want to run p1.exe, then p2.exe and p3.exe The following code execute p1.exe, p2.exe, p3.exe Set objShell = CreateObject("WScript.Shell") objShell.Run "C:\p1.exe" objShell.Run "C:\p2.exe" objShell.Run "C:\p3.exe" Can anyone help, please? Thanks,

I have about 20 modules in folder C\modules I created a text file that contains only modules I want to import in C:\modules\list.txt list.txt module1.bas module6.bas module10.bas Does anyone know how to import the modules in list.txt into a Project's Modules using VBA? Many thanks, XT

I want to create a text file using VBA. If I select a folder, the VBA code will write all folders, filenames to a text file (text.txt) The codes below write the text.txt but for some reason, the first line shows OK and the rest are in special characters. Does anyone have any ideas? Thanks, XT...

I am working in a network folder (multiusers environment). Is there anyway I know who's opening the file? Thanks, XT

I get the following message when I try to edit my form. Does anyone have any idea? Please help. Thanks. The object is locked, so any changes you make will be discarded when the form is closed Click Save As/ Export on the File menu and save the object under a different name...

This is one part the code to make the series: .SeriesCollection(n).XValues = rngClock .SeriesCollection(n).Values = rngDiffTemp My chart will display Series1, Series2, Series3 ... If I add this line .SeriesCollection(n).Name = "Test" My chart will...

I have the following code: After copy a range from the original sheet to sheet "Data", how do I go back to the original sheet? Sub CopyPressure() Dim Fcell As String If ActiveSheet.Name = ("Data") Then MsgBox ("Go to the original sheet to select the first cell...

Does anyone know how to write the VBA code to make Series? I have this data: 6 3 2 1 Start 6 3 4 5 5 7 4 8 7 12 End 6 10 12 8 9 10 Start 6 4 7 6 4 7 3 8 End 6 5 2 9 How do I build a macro to make Series chart for each Start-End block? Here's my code but it does not work...

Skip, Since your code is difficult to understand, I have to stick with Zathras's code. I played with Zathras's code but could not figure out how to add Series chart (in column E and F for each block) Could you, Zathras or anyone can help me? Thanks a bunch. Here's the latest code...

This is my sample block. "HP" marks value > 11300. How do I find maximum value in HP range and mark the word "MAX" next to it. How do I loop through the whole worksheet? ColA ColB ColC ================================ 10966.327 11176.779 11267.391...

I have this sample excel spreadsheet: http://viet.ws/chart.xls The original columns are "Time", "Pressure" and "Diff. Pressure". I would like to build a macro to do the following things: - Mark "HP-Start" if the max Pressure is found (within HP range)...

I have the following VBA code in Excel: ===================================================== Sub del_headers() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim rng As Range, ix As Long Set rng = Intersect(Range("A:A")...