Opening Files At "Persnl Sht" Every Time File Is O
Jul 29, 2007
Have not been at VBA long so am prety much "junior" I suppose
What I have so far is folder for each Client! - maximum of 4 files in each folder and could all be open at same time
Have "central" VBA well set out control page with Client Files option and command buttons but files open at "last page saved"
Added worksheet select which opens perfect - after the "macro" yes/no open box opens with "last page saved"
Working with "office 2000 SB" and have tried various ways
workbook open / beforeclose / beforesave - matbe not 2000 objects
Just want client to see file opening with his name nicely shown on worksheet
Would really appreciate suggestions to get file open at client worksheet page from start
View 9 Replies
ADVERTISEMENT
Apr 18, 2006
I can't open a file anymore. On opening an exclamation mark message appears telling me the file contains "Too many different cell formats". After clicking "Ok" Excel doesn't continue the opening proces. However I need the info in the file. how to retreive the info in the file?
View 2 Replies
View Related
Apr 2, 2007
I have about 20 files that all have separate passwords. When I enter the password for six of the files, I receive the "Unable to Read File" error message.
View 5 Replies
View Related
Jan 12, 2010
I'm using Excel 2007. I didn't change a single option but for some reason this problem came up. When I open an already saved Excel file it opens up in a newly created file. For example, if I open a file saved as "Monthly Sales" it will open it up and rename it as "Monthly Sales1." When I go to save it again, which would normally just save it where it currently sits, it basically acts as if I hit Save As and pops up the box asking me where I want to save it. This is extremely annoying as most of the places where these files are saved are several folders deep which makes it time consuming every time I open and alter a file. I can't find any options that looks something like this and it only happens in Excel.
View 9 Replies
View Related
Mar 1, 2010
Ive got about 300 different excel files all with the exact same format the only thing that is different is the values in the columns but they are all raw reports dumped into excel.
because I had to run them all seperate for certain reasons is there a way to combine all these files into one file without copy pasteing them all into one sheet.
View 9 Replies
View Related
Nov 7, 2007
I am trying to open excel files in a file path which includes folders which also have excel folders i wish to open there are quite a few.
At the moment i am working with this code but it fails to open excel files which are within the folders in the specified file path. Its fine for excel workbooks in the folder specified by file path.
This is the code
Sub RunCodeOnAllXLSFiles()
Dim lCount As Long
Dim wbResults As Workbook
[Code].....
View 9 Replies
View Related
Jan 16, 2013
I have a file that I want to clear certain cells and all option buttons when first opened. I then want the user to be able to save and close the file with the data they have entered. When they go to reopen the file I want the data they entered to still be there. I want the user to get the blank file off the company's server and then save it to there machine when it has been completed and when they go back to this file the information is still entered. I have attached the file.
Request Form 2012 Draft4.xlsm
View 1 Replies
View Related
Jun 11, 2014
When opening the attached file, for some reason, I have to again select the cells from column A in tab "Transactions" and go to Data Validation and select again LIST - only then the data validation from list resumes working. When I close the file after saving and open it again, the data validation does not work - I have to again go to Data Validation and again reselect LIST (making sure, of course, that I do not mess up Source) to have Data Validation list run again.
what is wrong with list validation when opening the file.xlsx
View 4 Replies
View Related
Jul 25, 2006
i downloaded the beta version of the office 2007 for testing. can i install this version alongside my existing office 2003 version. i want to have the 2 versions installed on my computer so that i can choose between the versions when opening a file.
View 3 Replies
View Related
Jun 26, 2008
Is there a code that will search a pre-determined folder for all .xls files containing the word "Temp", and deleting those files?
Example:
In the root of drive M, I have several Excel files. Anytime one of the original tracking logs is opened, a temp file of that log is automatically created. I would like to automatically search the drive and delete all files containin the word "Temp".
I've attached a picture of the directory tree, in case that will help. The file will always be named "PO Response Tracking - Temp#######.xls", with ###### representing a series of either 5 or 6 numbers.
View 14 Replies
View Related
Jul 6, 2006
I would like to write a function that enhances conditional formatting capabilities in this way: suppose that cell(4,5) contains a number that can be 0 to 5
in the adiacent cell(4,6) i want to put a function that:
1) write "NO DATA", "HIGH", "GOOD", "MODERATE", "POOR", "BAD" depending on that value
2)Choose color font depending on value
3)Choose color background depending on value
I wrote this piece of
Public Function StatusResponse(AdiacentCell As Range) As String
Dim thisStatus As String
Dim ThisFontColor As Integer
Dim ThisbkColor As Integer
Select Case AdiacentCell.Cells(1, 1)
Case Is = 0
ThisbkColor = 2
ThisFontColor = 1
StatusResponse = "NO DATA"............
View 2 Replies
View Related
Nov 20, 2009
I have attached an example workbook to this message, with the sensitive data removed. I am trying to vlookup the "cube" for the product number, into the PO worksheet, IF the vendor numbers match.
Example:
On row 2 of the "PO" worksheet, part number AC1000110, should have a cube of 2.5 for vendor # 11170. I'm trying to match the "Vendor" on the "PO" worksheet with the "Vendor" on the "Cube File" worksheet, and then return the corresponding "Cube", (in column F of the "Cube File"), in cell U2 of the "PO" sheet. So, what formula needs to be entered in cell U2?
View 2 Replies
View Related
May 20, 2006
Suddenly when I open a ExcelWorkbook Microsoft Visual Basic shows a messagebox stating: "Runtime faillure 9 Subscript out of reach" only the closebtn is enabled. After closing the box the workbook opens normally.
View 2 Replies
View Related
Aug 12, 2007
i type into any cell in row 1 i need the time at that moment to be captured and shown in cell "B". When i type into row 2, the time which i entered the data must be captured into row 2 cell "B".
View 5 Replies
View Related
Jun 23, 2007
Maybe its just my 42 year-old eyes, but I find using Auto Filter to be a bit of a pain. Sorting is no problem: click on the arrow in the auto filtered row, choose what I want, do my work, easy as pie. HOWEVER: I'm done my work, and I want to re-open to "all".
Problem: remembering what @#$%$# column I've auto-filtered on. Excel helpfully highlights the arrow's column in a wonderful shade of DARK BLUE, which (see 42 year old eyes above) looks not much different than the BLACK arrows on the other 47 columns. Eventually I'll remember, click back on it, then on to workflow item #2. Repeat as needed.
So, I'm just wondering: is there any way to highlight the selected column better? Even zooming to 200% doesn't help my eyestrain. I suppose I could highlight the column somehow BEFORE I sort, but that seems to be quite a bit of work, even with a macro. What would be nice would be a way to somehow make the auto-filter selection arrow bigger, or at least make the "clicked" column arrow yellow or white. Anything but a dark colour on a grey background.
View 2 Replies
View Related
Nov 17, 2009
if you could have a look at the attachment, what i am trying to do is in Cell E2, I would like it if B2 was between 22:00:00 and 06:00:00 for it to display a "N" for nights, if cell B2 was between 06:00:00 and 14:00:00 to display a "D" for days and between 14:00:00 and 22:00:00 to display an "A" for afternoons.
View 2 Replies
View Related
Apr 2, 2014
I have 50 files each with 1000 numbers in column A.
I need to compare every list with every other list and calculate the Pearson function.
I am ok with the vb code to compare every file with everyother.
I can do this by opening each file then closing but it takes too long.
Each of the 50 csv file names is in my destination workbook
I would like to define an array using the file name, then extract 2 lists without opening the files then perform the pearson function and place the value in the destination workbook. (The pearson function just measures the strength of correlation between 2 sets of numbers)
View 4 Replies
View Related
Jan 3, 2008
Could anyone tell me if it is possible to get a file to save as follows:
filepathfolder called "YYYY"folder called "MMM"File.xls
where YYYY is the year and MMM is the month?
The folders YYYY and MMM may or may not exist. Is it possible to get excel to create them if they do not already exist?
View 10 Replies
View Related
Dec 17, 2008
I m Trying to add some features to it and run into an issue. Here are the fields we are working with!
A1= 13:30:00 17/12/2008
(in other words 1:30pm on date given) - Need to know proper cell number format!!
B1= 23:00:00
(this represents 23 hours) - format for cell is [h]:mm:ss
C1= Unknown function
(This field is my problem!!)
Answer here SHOULD be "14:30:00 16/12/2008"
I need a function for C1 (using A1 and B1) that will give me the time and date 23 hours earlier or however many hours:mins:secs is specified in B1! Also need to know what number format to use for both A1 and C1
View 4 Replies
View Related
Apr 4, 2006
I have upgraded to Excel 2003 and have lost the File menue option that allows
a file "Save As".
View 9 Replies
View Related
Apr 17, 2007
I have a need to open a file from my companies intranet. My current method was to open said file via the method that the recorder gave me. However, I would like ot be able to open a said file without having to start open another workbook.
This is the path:
[url]
So the command is this:
Workbooks.Open [url]
Links are not actual links
So what I need to know. Is how can I open this file without opening a workbook. I haven't been able to use the VB "Open Statement" to open a file and I don't believe that I've been successfull using the Filesystem object either.
View 9 Replies
View Related
Jan 20, 2007
To have other users open a workbook on the network without having to click button to open it as read only.
I have been trying to get rid of the "File In Use" message for the other users since they only need a read only copy. I am the only one who needs to know if it is in use because I will make changes to the workbook tools and have to save them.
I have set the Save As preferences so that it requires a password for modification and checked the read only checkbox. But that dialog box is popping up for the users. I am trying to eliminate any file in use dialog box for users other than myself.
Here is my workbook open procedure...
Private Sub Workbook_open()
Dim wBook As Workbook
Dim UsrName As String
UsrName = Environ("username")
On Error Resume Next
Set wBook = Workbooks("Excel_Tools.xls")
View 3 Replies
View Related
Sep 24, 2002
How do I disable the "Save" option from File Menu and allow only to "Save as"?
Excel 97/2000
View 9 Replies
View Related
Jul 31, 2014
So I have two dates:
Opening Date: 29/07/2014 13:27
Closing Date: 29/07/2014 14:42
These are formatted in DD/MM/YYYY and HH/MM
I need to subtract the dates and find the time taken from the opening and closing time.
View 3 Replies
View Related
Aug 14, 2003
How can I use VBA to open a .chm file. I tried using many different methods but with no success, i.e. openfilename.
View 6 Replies
View Related
Jun 11, 2007
i wish my vba program to enable the user to select a file to open from the regular 'open file' dialog box.
in addition, I wish to be able to list the filenames in a user form that have already been saved in a specific directory.
View 9 Replies
View Related
Apr 25, 2006
I am trying to view a csv file that has string data, some of them like '395E02'. Excel automatically converts this string into an exponential number. Is there any way to stop Excel from performing the conversion so I can read the number as is?
View 8 Replies
View Related
Mar 22, 2009
I can't seem to find out how to use wildcards like "?" and "*" in the VBA- Replace("string","s*r","k") which should give "king"
View 3 Replies
View Related
May 31, 2013
loop and range function to apply in the below code through which I can avoid writing code for all the rows.
I am trying to open excel files located in single folder from files name (along with the path) in single worksheet (Column B and Row 1 to 500).
I have created follwing code which opens the file and then runs a macro in it.
a Sub Test()
Dim strFName As String
strFName = Sheet1.Range("B2").Value
[Code].....
View 4 Replies
View Related
May 9, 2008
When I open excel windows or Excel adds a "1" to the end of the file name?
and allows me to open another instance of the same file and then adds a "2" etc..
View 9 Replies
View Related
