|
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
|
|
|
|
|
|
Depends
With VB you will finish your job somewhat faster, but if you want to deploy your applications to many customers, it can be hell. You can NEVER be sure that a VB application will install successfully. However, if you have a limited number of customers, it will not be a big problem.
I vote pro drink
|
|
|
|
|
I have made many installbles in VB using the Deployment Wizard and i guess that the VB installable always works fine...I mean why will it not work when it is having all the dependent Dlls...?
|
|
|
|
|
VB is the best choice if you do not intend to distribute your any of the component to client's machine.
Apart from that VB application has Lots of dependency file which when installed may or may not creat a conflict problem . that totally depends how compatible(I mean version of the dependent files which you ignored while installing your VB application)) is your development machine and the staging machine.
Generally the size of a VB app will be approx more than twice the size of VC++ app.
|
|
|
|
|
I'm looking for a way to check application existance in two capacities:
1.) How do I check if an application is running? One program relies on another to process, etc...
2.) How do I check if the application being launched is already running? Or, is this handled the same way?
t
|
|
|
|
|
Hi all
We have some third party VBX controls ( without source code ofcourse !!! ) which we would like to use with OCX and Dlls.
Is this still possible ?
Currently we have two setups running in parallel for 16 and 32 bit and we want to avoid this.
Can we write a wrapper or a bridge to make calls atleast ?
Any pointers will be appreciated
Thanks
Anand
|
|
|
|
|
I need to know sourcecode about getting "serial number" of harddisk. Please help me.
Note:
1. "serial number" NOT "Volumn Serial Number".
2. each harddisk has id called serial number.
3. Volumn Serial Number is generated by "format" command.
|
|
|
|
|
hi,
for getting the serial number use api GETVOLUMEINFORMATION
u'll get the file system name(FAT,FAT32,NTFS,CDFS etc..) and the Disk Serial Number
regards
|
|
|
|