o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

How to automaticaly logoff when save and closing the Excel file -

Hi Guys,

I have a tracker that the users can login and logoff. my problem is when I save and close the file while the user is still logged in he will not be logoff automatically and when i open the file the user is still logged in. Can anyone help me on this.

 

How to automaticaly logoff when save and closing the Excel file -
Hi Guys, I have a tracker that the users can login and logoff. my problem is when I save and close the file while the user is still logged in he will not be logoff automatically and when i open the file the user is still logged in. Can anyone help me on this.

Saving in Excel -
Hello I am loading data into Excel worksheet then I need to save it as a excel file. Every time when I save this worksheet I need to name it as Part1.xls next time as a Part2.xls next time as a Part3.xls etc. Do you have any idea how can I make a macro (vb code) to save this workshee

auto saving an excel data base -
Can anyone help! 1)I want to automaticaly save a live excel workbook, 2)using the date and time as the save address 3)The iput to save the file will come from a plc input into the excel file i.e. i will put a 1 in cell A1 4)when their is a 1 in A1 i want vba to Auto save the fi

closing excel file -
hi all, i am opening an excel file for some updation, but after my completion of updation. i am prompting for Save changes in that file while i am closing that excel application. eg: xl.Workbooks.Open(fp) 'fp-filename -------- -------- doing updation here --------- ------

EXCEL VBA, Save AS VS Before Save Event -
Hi guys, I'm having a little problem here. I have a master excel file(file 1) that open another file(file 2). File 2 have an before save procedure. File 1 modify file 2 and try to save it. But File 1 cannot save file 2. I' getting an error, file in use witch is true because

Suppress excel dialog box -
Hello, When i run a program from command line, I open excel file and save as csv file. before closing it ask "Do you want to save the changes you made to 'file' ?" Is there any way to supress these message and always default to "NO" close without prompting

How to close and save an excel file using VBA -
Hi Guys, can anyone help in saving and closing the excel File using a VBA code? and also is it posible to disable the minimize restore and close buttons of the excel workbook?

Closing Excel -
Hi guys! Is there a nice way of closing a open excel 97 application down. I want to have a button within a spreadsheet that allows the users to close and quit the excel applications, without the need to go to file ...exit. ta Gerard

opening and closing an excel file -
Hi, for studying with excel file I use the following code. dim PROG Set PROG = Workbooks.Open(FileName:=app.path & "/abc.xls") Set OY = PROG.Worksheets(1).Cells oy(2,2)="test" ' for ex. PROG.Close savechanges:=True In my laptop, when I used thi

Excel sheet will not open after running my vb6 code -
Hello, I am running VB6 code where I handle some Excel files. After closing my VB6 program, my Excel file won't open - I have to go to the Task Manager to close EXCEl EXE. Obviously, I am not closing my Excel session correctly. What is the correct way to release Excel ? Thank you

Access VB to save Excel file -
I have an Access function that navigates to a website and downloads an excel file. The excel file is called. "DownloadNCPartListServlet.xls" I would like to save this file to c:\owner\documents\ I would like to name the file ("Update_" + todays date) One po

RESOLVED...X type Logoff Screen... -
Hi, In my application, i would like to give a WIN XP Pro type of Logoff fininsh... when we click on start--> Logoff / ShutDown... A popup box comes up with the buttons for Logoff / Shutdown etc.. At the same time, the background colour turns to black / white progressively.

Display message box on logoff -
I have gotten into the habit of accidently leaving my flash drive in the USB ports of computers at work. I want to design a program which I will autorun off my flash drive invisibly which, when Windows logs off delay the logoff for a few seconds and ask me to remove my flash drive. Is

[2005] Detecting Shutdown/Logoff and delay until program close -
Okay, I need to be able to detect when a user does a shutdown/logoff and I need to delay the shutdown/logoff until they have chosen an option on a form or two. When they click Ok on the last form or close the program any other way it should close the program and resume the shutdown/log

Delay Log-off until user confirms. -
I have a program while launches when someone goes to logoff. It only displays a short reminder but sometimes windows brings up the 'end task' diologue before a user can read it. Is there any way i can 'delay' the logoff until they hit "ok"? I was wondering if i abort the logo

Help in properly closing Excel file. -
Hello all, i wrote a program that opens an excel file and does some calculations and then close it. The problem i seem to be having is closing the excel file after I'm done doing my calculations. After i issue the close/quit command the excel file closes(disappears) but when i look

How to save data from webform to Excel -
I need to save data from a webform to a new excel file. I know how to save information to an existing excel file, but how do I initiatiate a new excel file, and specify the file name and afterwards save data to this? Would it be better to do this with XML? The problem is, that the use

"Append" to excel thourgh vb6 -
Hi. I've read so many articles and tutorials about vb6 and excel but cannot find answers. What i need is: When updating a dataset of an mdb database i want the new "row" of data to be appended to a predifined excel which of course has the same 'fields' as the mdb file. The po

Killing an open excel file -
Hello All, I am stuck with a problem while performing following operation. In my project the need is to save the data shown in the grid in Excel file. I am able to save it in excel and even if file exists then it overwrites the file. But the problem is if the file in which I am

Saving without prompt -
I have a form which updates an excel file. I dont want the user to see the " Do you wish to save " message after closing the form. I just want the code to automatically save the file.

save excel file -
Hi, In my VB6 project, I read the RS and save to field to the excel sheet and everything OK except everytime when save to the excel, it prompt up to ask overwrite the file or not. I want that message not showing. Anyway to get around that? The command I'm using in the code. xl

opening Excel -
Is it possible to open Microsoft Excel from VB and automaticaly open a file in it? I hope you know what I mean ------------------ Visual Basic Programmer (at least I want to be one) ------------------ PolComSoft You will hear a lot about it.

Removing Session variable while closing browser -
I have a web based application. It uses session objects. We have a logOff buttion in the application. When the user clicks the logoff buttion the session objects are destroyed and logged off message is displayed. Any thoughts on how to destroy session objects if the user closes the b

closing an excel file opened in VB -
I open an excel file, stuff in some data, close it and kill it. everything works fine but the close process brings up a system messge asking if I"d like to save the changes. I'm sure that I've seen a way to make the close process tell the system to save without asking, but now

Prevent excel from closing -
is there a way to prevent MS Excel embedded on a C# application from closing when the user manually closes excel inside the app or even if they go to file > exit? i only want the application itself (my C# app) to close it and not by the user thanks

How to add data to an Excel file and save -
How do I open an exsisting Excel file and add information and save the file? Below is the VBcode I am trying to use. The code below is part of a cmdOut "Click" Dim xla As Excel.Application Dim xlb As Excel.Workbook Dim xls As Excel.Worksheet Set myBook = Workboo

Dissable Save -
I have a Application.Quit button knocking about and i have got it to ActiveWorkbook.Save but i dont want excel to ask if i want to save again after that before closing. Can you dissable it?

xl97, xl2002 -
I have an excel 97 file that was mistakenly opened and saved in xl2002. No changes were done to the file, it just ran the save command. Now when I open it in 97, on each save I get a box saying it was saved in another version of excel and asking if I want to lose my changes, etcs..

load and save excel -
hi i know very little of programming but can't figure out some codeing for a program of mine. i need a small app which can save a excel file, as well as load it within visual basic. i tried playing around with visual basic today and came across something which said OLE or somet

Excel using Vb .net -
Dim fname As String Dim i As Object Dim wsheet As New Excel.Worksheet Dim count As Integer = 1 OpenFileDialog1.ShowDialog() fname = OpenFileDialog1.FileName EXL.Workbooks.Open(fname) wsheet = EXL.Workbooks.Item(1).Wo

Excel app closing but locks the last saved worksheet. HELP!! -
I'm releasing all the COM objects and the Excel app I'm using closes (from the list of active processes i mean). However the file that I saved using that Excel object remains locked until I close my application all together. I've seen a zillion issues regarding Excel not being closed

Gurus...let me see if anyone know..Save as different file -
Hi, I have excel spread sheet in .slk format (which is type of excel format). I would like to open this file in VB and save it as .xls format. Since I have hundreds of .slk format files, I need to convert them all to .xls format. If I do it mannually, I will be doing the following.

Closing Excel Files -
I have many Excel files that are used by many users. The problem I have is that after these files are opened by the users, they always tend to forget closing them. When my VB program needs to update these files, I am unable to do it since I can only have read-only access. And the ag

[2003] Excel+VBA: Save old doc to new location/delete previous doc -
Here's my current issue, hopefully someone has some advice on this solution: Basically, I have an excel doc saved somewhere on a networked drive. What I want, is if someone goes to that excel doc, clicks a button, it would save that excel doc to another location (i can do this alr

Saving .xls file as .txt (VBA Excel 03') -
I have a macro that does a few things to an Excel workbook (not the one with the macro) and then saves, and closes to an Excel workbook. I now want to save, close the Excel workbook as a text (tab delimited .txt) file. Currently I am closing/saving the file near the end of my Sub wi

Closing a Excel workbook -
One excel workbook has to open another workbook refresh the data and close the workbook. The application workbook has to open and close many excel files. while colsing am getting the error. the img is attached. am using the following code lobjwb.save lobjwb.close where lobjwb i

Export to Excel File Type -
Can anyone help us out please....... We want to save a file as an Excel File Format. The problem we have here is we don't have MS Excel installed. Without having Excel we would like to create a File that is of Excel File Type. So that we can open this file directly using some

opening and closing Excel -
I have a button that opens Excel and goes right to a specific spreadsheet based on the users station number. It works fine, but when you close Excel and later on click the same button Excel opens with parts of the form in it and doesn't open the spreadsheet that it is supposed to. Som

Recordset to Existing Excel Workbook -
I'm connecting to Excel and grabbing data from a specific field. I then bring it into SQL and create a new recordset based on data from SQL and the records in my excel file. I now need to export the new recordset into new tabs on the original Excel file. When I go to do the export b

Save Excel file using Common Dialog Box -
Hi all I am trying to save the Excel file that I created with data using Common Dialog box. After I created the file the messagex box pops up with two options "Save As" and "View". So I would like be able to save the file when the user clicks "Save As".