|
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
|
|
|
|
|
|
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 ![Beer | [beer]](https://codeproject.freetls.fastly.net/script/Forums/Images/beer.gif)
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
