Visual Basic

FirstPrevNext

Command Line Parameters Steve Thresher27-Sep-01 3:35 Steve Thresher 27-Sep-01 3:35  How do you access command line parameters in a visual basic program? Re: Command Line Parameters Steve Thresher28-Sep-01 4:30 Steve Thresher 28-Sep-01 4:30  Just in case anyone else is interested there is an article on CodeGuru that documents the extraction of multiple command line parameters. http://www.codeguru.com/vb/articles/1755.shtml Menus in an ActiveX Control AaronGman26-Sep-01 8:48 AaronGman 26-Sep-01 8:48  Is there anyway to have a menu in an ActiveX control, to be used in an asp? Thanks Aaron dates as interger 22-Sep-01 21:58 22-Sep-01 21:58  Anyone know how to convert the vba function Now - which returns the date and time as follows - 23/09/01 08:27 into a straight foward number without all the / and : bits? Re: dates as interger 25-Sep-01 12:25 25-Sep-01 12:25  Use the VB function FormatDateTime(...) Error trapping 21-Sep-01 21:31 21-Sep-01 21:31  I wonder if anyone can help me? I have a small piece of vba in excel that works fine except for one thing. It saves a spreadsheet in as particular directory with a specified name but if it encounters a file of the same name already there and you click no to the save it then dies with error 1004. Can anyone assist? Here is the code: Private Sub CommandButton3_Click() siv = ActiveSheet.Cells(6, 2).Value 'ActiveWorkbook.SaveAs Filename:="C:\My Documents\" & siv & ".xls", FileFormat:=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False On Error Resume Next ActiveWorkbook.Close End Sub Re: Error trapping NormDroid22-Sep-01 0:45 NormDroid 22-Sep-01 0:45  What on earth is error 1004 is a window error code? 1004 = Invalid flags. as an internal Windows error code try using the default params? Re: Error trapping 22-Sep-01 21:56 22-Sep-01 21:56  The on error resume should avoid but doesnt. The error is that it is finsindg an existing file of the same name and then falls over when you click no or cancel as oppsed to yes because the function is saveas hence the saveas has failed. SO how to get around the failure of the function???? cular directory with a specified name but if it encounters a file of the same name already there and you clkick no to the save it then dies with error 1004. Can anyone assist?Error trapping 21-Sep-01 21:29 21-Sep-01 21:29  I wonder if anyone can help me? I have a small piece of vba in excel that works fine except for one thing. It saves a spreadsheet in as parti background processing Irfan Ahmed21-Sep-01 8:53 Irfan Ahmed 21-Sep-01 8:53  I am working in excel VBA i am using DDE to get info from the server, when I run the code to get the info it takes a little time to fill the cells in the excel, and if the cells are empty the next instructions generates error, i want something (api) that can stop the execution of program but let that DDE server to complete its work.. Nees immediate help... Re: background processing jonnyl21-Sep-01 9:23 jonnyl 21-Sep-01 9:23  Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds As Long) Batch updates to a database v_krishnan21-Sep-01 3:58 v_krishnan 21-Sep-01 3:58  Hi, I am using the MS RDO control to show values from a database into a grid. Now when the user can edit the data in grid I do NOT want the changes to be applied immediately. I want them to be applied into the database only when the user asks. The problem I have is that the ODBC driver that I am using does not support batch updates. Can anyone please tell me some other method through which I can achieve this? save as a particular name 20-Sep-01 23:18 20-Sep-01 23:18  Does anyone know how I might use a button on a form to save spreadsheets into a named directory and to pick from the spreadsheet the save as name? Ie each time it is opened it will be given a unique id no by the user into a particular cell on the sheet. I would like to be able to click on a button to close the spreadsheet and save it as the id no in a name directory - say c:/mydocuments. So my directory will fill up with lots of uniquely named spreadsheets. The unique id no would be held in cell B6 many thanks in advance Re: save as a particular name 21-Sep-01 3:06 21-Sep-01 3:06  You can record a macro bu trouble is when recording a macro you cant use the cut and paste functions properly. I know that I want to do: siv = ActiveSheet.Cells(6, 2).Value ActiveWorkbook.SaveAs Filename:="C:\My Documents\"&siv".xls", FileFormat:= xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, CreateBackup:=False but of course it doesnt like me stuffing the siv variable in like that so I am snookered. There is the save method NewBook.SaveAs Filename:=fName so I can swap fname for siv, but this doesnt let me state where it has to be saved Access in Activex Control AaronGman20-Sep-01 9:59 AaronGman 20-Sep-01 9:59  Can someone tell me how i would embed an instance of ms access inside a VB ActiveX control? Thank, Aaron Gillmann Need Help In VB Packaging Indiana19-Sep-01 22:45 Indiana 19-Sep-01 22:45  Hi, I have done a project using VB and SQl. I also created a setup (packaging) file. When installing I got this error. I am using Win 2000. The error is The File C:\Docume~1\Admini~1\Locals~1\Temp\msftqws.pdw\$(DLLDelfRegisterEx)' could not be registered because it was not found. Please Help Me Solve This Thanks Indiana Re: Need Help In VB Packaging jonnyl21-Sep-01 10:50 jonnyl 21-Sep-01 10:50  http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q208699 Re: Need Help In VB Packaging k21-Sep-01 14:53 k 21-Sep-01 14:53  I had a similar problem with this Temp directory in Win 2000 -- it's a hidden directory. I had to go into the folder options in Windows Explorer and choose to view all folders -- hope this solves your problem. A Solar System Program 17-Sep-01 8:05 17-Sep-01 8:05  If anyone has made or has seen a good solar system program made with visual basic, please send me an e-mail with deatils. My e-mail is mpiotrowski@wi.rr.com I need this for a start on a huge project I am doing conserning the entire universe, and planets are maybe 1/15 of what I am doing. If anyone can help it will be greatfully appreciated. SQL Server Experts ! ManaInfy14-Sep-01 1:53 ManaInfy 14-Sep-01 1:53  I am trying to do the following ! ( SQL Server 2000 ) Open one session of Query Analyser Window Begin Trans Update Table1 Set ... But I don't commit ! Open another session of Query Analyser Window Select from Table1 Select gets Blocked unless Update is committed ! CAN'T I DO A SELECT WHEN UPDATES/INSERTS Occur ? I Can do with NOLOCK but we don't want uncommitted data to appear ! I have tried with all transaction isolation levels. Anyone can help ? Thanks Anand Re: SQL Server Experts ! jkgh14-Sep-01 13:35 jkgh 14-Sep-01 13:35  Just think about what a transaction is designed to do. eternal student Give a man a fish and you feed him for a day; teach him to use the 'net and he won't bother you for weeks. VBA - Generating Line numbers 12-Sep-01 10:06 12-Sep-01 10:06  Does anyone know of a way to auto-generate line numbers for VBA code? Perhaps a VBA AddIn?? Thanks, Kieren Kieren Taig Re: VBA - Generating Line numbers J Patel12-Sep-01 11:13 J Patel 12-Sep-01 11:13  Try the add-in found here: http://www.gridlinx.com/ HTH Jignesh Re: VBA - Generating Line numbers jkgh14-Sep-01 13:30 jkgh 14-Sep-01 13:30  10 It's a little cheaper to buy a 20 proper basic interpreterr 25 eg. BBC micro. 30 END eternal student Give a man a fish and you feed him for a day; teach him to use the 'net and he won't bother you for weeks. VB vs VC++ in User Interfaces Alberto Bar-Noy11-Sep-01 1:23 Alberto Bar-Noy 11-Sep-01 1:23  Hi all, I am designing a project which can be separated into two layers. 1. The user interface 2. the business logic. The business logic has to be developed as COM components (since it will need to be reused in other environments) The question is in which language (environment) to write the users interface. Should I do it in Visual Basic or Visual C++ (or other)? Thanks in advance Alberto Gattegno Software Engineer http://www.itgil.com

Last Visit: 31-Dec-99 18:00     Last Update: 8-Jun-24 3:20 Refresh ᐊ Prev1...4796479747984799480048014802480348044805 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.