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 file 2 has before save proc that is call when file 1 try to save file 2.
How can I overcome this???
Thanks
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
trapping windows Save as event -
hi all
i want to trap the windows save as event
i have my vb appln through which i allow users to save a word,ppt,notepad
excel file.
whenever a user saves a word,excel,ppt,notepad file i want to
show the customised save as dialog that i have developed from my appln
rather tha
Using VBA in Excel to force Save As instead of just Save -
I do not want my Excel VBA template to be overwritten as it is going to be used over and over again. How can I prohibit SAVE and force SaveAs so the user has to save a copy after they have finished calculating, pasting etc on my template?
This is partially what I need as it does not
save as dialog box in excel with chosen file name -
Hi,
Does anyone know how to script in Microsoft excel to:
(1) when the save as dialog box appears, it defaults in a selected directory. e.g.
opens C:/excelprojects/myproject. (folder) Also is this possible with a virtual path, e.g.,
//s1asdev/excelprojects/myproject (folder)
(2)
Excel : popup a save as box -
Hi.
On my excel project, I am trying to create a macro which allows a user to save a spreadsheet.
WHat happens, is that i do not want the user saving the actual excel program (because it is a template), so I have created a 'Save' Macro, which copys the relevant information that they
VB 2005 - Auto save when rendering to Excel -
I am exporting a gridview to excel and this works great, is there a way to have the code behind save the the sheet after it's rendered?
Right now it asks if you want to save it, open or cancel.
I already have a filename generated before it's exported to excel.
Thanks.
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
.xls to .xml -
Hi,
Doing some xml/excel related work at present.
When I try to save my .xls file as .xml (i.e. save as .xml data format), an error message tells me that Excel cannot save the workbook because it does not contain any XML mappings.
This does not occur on other machines.
Any thoughts
Using Save As to save VB Form as a file -
I'm writing an executable VB program whose output is summarized on a VB form. I want the user to be able to save the form to a file similar to the way you can save a Word or Excel Document. I can get a Save Dialog Box to appear, but don't know the code to use to save the form, and ca
Excel crashes with a GPF -
I've been saving my Excel template many times till now for the last two days into a file called Copiers1.xlt. Now, it has started giving me a GPF and starts crashing Excel when I save it under the same name. If I save it under a different name, it still does not save saying "Docum
checkbox events -
Hello there,
I am using a form in Excel to save data to an Access file.
I call the saving public routine with a click event but it causes problems.
I am trying to find which event, in a checkbox, will be triggered ONLY by user input and NOT by a change done by code.
I am using a se
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
Can you disable "SaveAs" in Excel menu -
I open Excel from a vb app and load a workbook.
The user can make changes to the workbook, but I don't want them to save it under any other name, so I thought leaving "Save" enabled and disabling "Save As" would be the way to go.
Then I thought maybe trapping
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
Excel save Pluse one -
Hi
How to save Excel file and if name exist then in next save it will be the same name pluse 1
If the file name JAMAL thn the next save will be JAMAL1 and so on for the rest names
Save webpage as .txt from Excel -
I need to open Internet Explorer from Excel & Save the web page to a file as text, then return to the operation in excel.... I know this has to be dirt simple, but I have done all my code thus far within Excel & dont know how to get events to work on other apps...any help would
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.
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
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
Excel using VB -
Hail,
Quick one here, how do you quit an excel object from vb without the message asking to save or not (I don't want to save because I'm using Excel to print a report only!)
Phailak
subscript out of range -excel worksheet save -
i am getting some data from database and i put all the data in excel sheet
and i am trying to save the excel
Application.Workbooks("Book1.xls").Save....this is the line i am using to save
but when this line comes, it is saying subscript out of range
what is saying li
Save an excel file -
Hi, I create an archive a.xls and I fill it with a datagrid but when I try to save it it's read only. How can I save it? Thank you
Save and Save As... [resolved] -
I've done a search of the forums and haven't been able to find my answer.
I'm using standard common dialog box code to do a save (simple textbox into a text file).
But how does Save and Save As work? ie Save As will always open the dialog box - but clicking Save should just save
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".
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
[02/03] Using the save file dialog with excel -
Hello,
For a visual basic project I am working on I need to be able to save data in a series of text boxes into cells in excel. So far I am able to open excel files using the open file dialog but I am unsure as how to save the textbox data into excel.
I have searched through some f
Save As in Excel using VBA -
How can I call the microsoft 'Save As' box from VBA in an excel macro? Using a userform I can get the user to specify a file name, but that's messy and the whole macro wouldbe a lot cleaner if I could get the Microsoft 'Save As' box to appear.
Any help greatly appreciated.
Resetting a timer -
So, I want to have a sort of automatic save on my form, so that after, say, 5 minutes, the system will save the current record.
That's all well and good, but if the user saves in the meantime, I want to reset the timer to zero, and start again, so that it always saves 5 minutes afte
Excel Worksheet Problems -
I have seen a lot of code on how to open up an Excel worksheet with a click event on a form, but how do I save the worksheet then close Excel by exiting the Excel application through Excel and not another click event on my form.
I have a form, with a command button, that when clicke
macro in .xml -
Hi,
There is an excel template which I sometimes make changes to and then save it as .xml
I have always been able to save the file as .xml without any issues.
Now a simple macro is added to the Workbook_Open() event.
I can still save the .xls as .xml but it seems that the macro doe
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
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
---------
------
Quitting Excel from code -
Hi,
I open Excel in non-visible mode from VB. If an error occurs I make sure Excel is closed in the correct manner, however, if data has been added to a sheet and the close instruction is run a message box appears asking if I wish to save the spreadsheet.
Anyone know how I can pre
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 SavePicture -
How to save my jpg pictures from worksheet to separate files on disk??? Like Excel do when save worksheets as html page.
Getting Excel workbook type -
IN VBA i want to know , the opened workbook 's format type i.e. whether its normal excel workbook , WK format , CSV format .. , DBF Format or any other format which Excel supports .. and i want to stop all other Save As format in Excel Save As Dialog box .. other than MS Excel format .
Is there a form close or try to close event -
what can I use to "show do you want to save the file" msgbox
is there a on form close event or something, I couldnt find anything
If the form's close buttone is closed it should ask if we want to save the file or not, if the user want to save the file the save function shou
'Save As' to DB -
VB6 / Access 2003 / ADO.
I have the Save and Save as items in my menu.
So, when I want to Save, or Save As, an item to the DB, would I have to loop through the entries in the DB to see if it already exists, or is there another quicker simpler way?
How do I add Excel to my VB Programm -
I am using Visual Basic 5 and Excel 95. In VB under References I have got Microsoft Excel 5.0 Object Library.
My problem is if I wanted to open a file in VB do some modification to it, save it and then open it in Excel to perform a 2 column sort on the file, and then save it, and o
Problem with Excel add-in -
Hi.
I create a little add-in to save Excel files with a password protection. With this add-in you save your files with read/open password (it save the passwords in a txt file). When you open the file with double click the add-in should open the file automatically (the add-in compare