|
How do you access command line parameters in a visual basic program?
|
|
|
|
|
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
|
|
|
|
|
Is there anyway to have a menu in an ActiveX control, to be used in an asp?
Thanks
Aaron
|
|
|
|
|
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?
|
|
|
|
|
Use the VB function FormatDateTime(...)
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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????
|
|
|
|
|
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
|
|
|
|
|
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...
|
|
|
|
|
Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds As Long)
|
|
|
|
|
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?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Can someone tell me how i would embed an instance of ms access inside a VB ActiveX control?
Thank,
Aaron Gillmann
|
|
|
|
|
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
|
|
|
|
|
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q208699
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Does anyone know of a way to auto-generate line numbers for VBA code? Perhaps a VBA AddIn??
Thanks, Kieren
Kieren Taig
|
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|