Toolbar When Work Papers Are Opened From Within The Engagement File Room
Mar 23, 2009
I am an IT Consultant and my client is doing a workstation refresh. They are a CPA firm. They use software called ProSystem Fx Engagement as a filing closet sort of thing. This has a toolbar Excel when work papers are opened from within the Engagement file room. In the Engagement toolbar there is an icon which allows the user to check all boxes. I have contacted the vendor and they said they know nothing about this and it is unsupported. I am trying to migrate to the user's new machine (helps save alot of time) but kinda stuck in a rut. I am assuming this maybe is a custom macro? I am not an Excel guy, I do server stuff etc... but trying to please my client, I included a screen shot of the toolbar and highlighted the button he would click to make this function work. This is Excel 2003 w/ SP4, and Windows XP Pro w/ SP3
View 5 Replies
ADVERTISEMENT
Oct 29, 2013
How come in 2013 there does not seem to be an option to "save as" an earlier version of Excel, specifically 2010?
I opened up something from work (2010) at home (2013) and must have refined it (nothing complicated or fancy that 2010 can't do!)
Now it won't open up at work and tells me to reopen and save as the old version.But 2013 won't let me.
View 4 Replies
View Related
Jul 27, 2009
I am attempting without much luck to create a Room Booking system.
I am facing 2 issues:
So far when you enter the guest iformation onthe booking sheet it is copied to a worksheet which stores the booking information.
Then i need it to be copied to a worksheet called Required Gantt - I have attempted conditional formatting and Lookup formulas but i am having difficulty getting the booking displayed on the gantt sheet (blocking out the entire period that the guest will stay)
Also if a guest is leaving on 28/07/2009 and i have another guest arriving on the same date, i can't make a new booking as the old guest is still blocking the room, even though they have left. Is it possible to make it so at 12 noon, checkout time, i can book another person into that room?
View 9 Replies
View Related
Jul 3, 2009
Following on from this thread: Create Room Reservation System
There are 3 problems that i've spent all morning trying to work out but can't:
1: I need to change back the layout of the Gantt chart (as it matches the paper system we have been using here, so it will be easy for the other volunteers to use it) - I did change it back and played with the conditional formatting and macro's but i can't get it too work like the version that AAE changed...
2: If I make a reservation ‘Booking’ is placed on the gantt chart, though only on the first date (I.E 22/09/09 – 25/09/09 – The first date is blocked but i can still double book the room via 23/09/09…) so I need the entire date range blocked out and I’m helpless at writing or even attempting to change VB Code…
3: Booking rooms and checking availability is great for single rooms, but I have realized that for dorms (upto 10 Beds) then once I book one person in, then I won’t be able to book the other 9 beds, which is a pain! Is there a way to have the room list but also a bed list for each room.
So for instance Dorm 1 has 4 beds – I book 1 person in it and it still appears as available until I book another 4 people in it, then it blocks me from booking someone else in the room?
View 4 Replies
View Related
Apr 7, 2009
I am having a bit of a problem creating a formula for this report that I have to update every week. I need to be able to find the room nights and net room revenue values for the specific rate code in the "MATRIX" workbook.
On "CURRENT REPORT," I need D4 to pull up the value on "MATRIX" that equals "Room Nights" in column H and "CONABC" in column J. The same thing needs to happen for F4 but with "Net Room Revenue" in column H. The full report has about 500 of these codes in column J, and I need a formula that I can copy easily and will not be affected if codes are added or removed. This is super last minute - I need to finish this report by tomorrow morning, so take a look at the attachments.
View 2 Replies
View Related
May 14, 2009
I am trying to change the caption of a toolbar item but for some reason it does not work.
Application.CommandBars("Format").Controls("Item...").Caption = "I&tem..."
However,
Application.CommandBars("Format").Controls("Item...").Delete
for example works just fine
View 9 Replies
View Related
Mar 20, 2014
I want to open a specific sheet and refresh only said sheet when i open another sheet for example x.xls
So opening x.xls will automatically open y.xls
I've tried this in the workbook code area but it doesn't do anything.
[Code] .....
View 1 Replies
View Related
Aug 19, 2013
Using Excel 2010, I set up a simple workbook with a spreadsheet on one page and the ranges for data validation on another. I successfully linked the fields in the "Category" and "Tender" columns with the data on the second sheet, making nice drop down menus. Everything works fine on my computer. However, when we open the workbook on a different station, the drop down menus disappear. If you highlight any of the "Category" or "Tender" fields, the little drop down prompt is missing; they behave like regular, un-formatted fields. It appears that the data validation became un-linked.
We tried opening versions with certain fields locked (Mainly the Total, Breakdown, and Summary areas, but the fields with data validation were still editable), and also completely unlocked documents. Every time, the drop down lists were lost when opened on different stations.
I've attached the completely unlocked version : 00_FLEX TRAVEL EXPENSE REPORT_v3.xlsx‎
Forget to check a box or something? This seems way harder for me to figure out that it should be!
View 3 Replies
View Related
Jan 7, 2009
Is there a way to create an outside log of who has opened an excel file and when?
I am looking to add some accountability to a project.
View 3 Replies
View Related
Apr 6, 2008
I am tring to find the xlb file, but it does show in my laptop. I open and close the xl App, but still could not find it
View 3 Replies
View Related
Jan 27, 2014
I am trying to make a find and replace macro for multiple items.
Please see the attached file for further explanation : macro.xls‎
View 3 Replies
View Related
Aug 18, 2014
Is it possible to insert the filename automatically in formula after the input from the user?
I want to ask the user to input a filename and afterwards, call that filename in an Index-Match
I have the below formula with the sample filename:
ActiveCell.FormulaR1C1 = _
"=INDEX('[filename1.xlsx]DATA'!C9,MATCH(RC[1],'[filename1.xlsx]DATA'!C32,0))"
Range("A2").Select
View 1 Replies
View Related
Jan 21, 2009
Opening it manually the dates in column C are all consistently date numbers. i.e. using the =ISNUMBER() function to test them, they all return True
However when I include the VBA instruction:
View 7 Replies
View Related
Jan 6, 2012
I would like to have a message box pop up when a file is opened requiring a user to enter information (Name), that would then put this name into a cell for later use when they are printing.
View 6 Replies
View Related
May 20, 2007
I have excel vba code to open .xls files on my server. Files to open are chosen by the user via a UserForm within my app, it shows them all their files in their directory on my server. How can I open their files (.xls) that they select but DISABLE the VBA from being able to run/execute, if they have any attched to the file?
I now have all code in place to open the file no problem, I just need to know how to disable the VBA part from being "turned on" when the file opens.
View 9 Replies
View Related
Jul 14, 2006
I run a macro which runs saves the active file to a different location to ensure that I retain the original like so -
If ActiveWorkbook. Name = "KEY_DATA_CFT77" + ".xls" Then
ActiveWorkbook.SaveAs Filename:= _
"H:HOME imcEXCELKEY_DATA_2006KEY_DATA_2006_01KEY_DATA_CFT77_01.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
End If .................................
View 9 Replies
View Related
Oct 7, 2008
The file who containd the toolbars informations is C:Documents and Settings<<USER>>Application DataMicrosoftExcelExcel.xlb
I copied this file to another computer and my custom toolbar appeared there.
In a file, I created a custom toolbar with submenus. It is possible to save this toolbar with file, so that I can use the file on other computers without the need to create each time this bar.
View 2 Replies
View Related
Jan 23, 2013
the small code i'm writing just needs to do the following:
1. open an .xslx file selected by the user
2. copy 2 worksheets from that file to the current one
3. close the selected file without saving it.
This is my code:
VB:
Sub GetData()
MsgBox ("Please select a file"), vbOKOnly
Master = Application.GetOpenFilename(FileFilter:="Excel Files (*.xlsx), *.xlsx", Title:="Please select a file")
[Code]....
Opening the file works, but the last 3 lines don't because i don't understand how to declare "Master": however i dim it (workbook, object, variant...) i get an error on the GetOpenFilename line. If i don't declare it, i get an error while trying to copy the worksheets.
View 1 Replies
View Related
Oct 6, 2009
The Macro asks the user to point at the location of a report, it then copies information out of that report and pastes it into a master sheet. The part I am having trouble with is closing the file that data has been copied from.
I have tried different things to close it such as
View 2 Replies
View Related
Jan 23, 2010
can group all opened file in 1 excel tab instead if many tabs?
open thru window the file u want...
http://i12.photobucket.com/albums/a209/tancfc/11444.jpg
http://i12.photobucket.com/albums/a209/tancfc/fhfh.jpg
right click on task bar > properties > under Taskbar Appearance, select Group Similar taskbar buttons > is not my answer
View 4 Replies
View Related
Apr 26, 2012
While opening one Excel file I get an error message saying that a 2nd file could not be opened because it cannot be found. I do not want this 2nd file to open. WHere do I find the "command" that is telling this 2nd file to open.
View 3 Replies
View Related
Dec 15, 2008
I have a Userform in Excel.
My requirement, is whenever I open the Excel file, it should open the userform and should not show the excel file at all. And the form is closed, the excel file should be saved and closed.
Also, I need the minimize button on the form and in the taskbar, it should not display the Excel file, it should display only the Userform.
View 9 Replies
View Related
Apr 18, 2006
I was working on a tax file yesturday, just a long long list of receipts. and the file is password protected. However, I went to open it today, and I get a message that says: "Filename.xls cannot be opened. the file may be read only, or you may be trying to access a read only location. Or, the server the file is located on may not be responding."
It's on my USB Drive. I've tried copying it to my HD so I can play with a copy, but no dice. When I try that, I get another error message, : Cannot copy Filename.xls. The file or directory is corrupted and unreadable. I've tried the various fixed suggested in the excel help files to no avail. I did a search on the forum, but didn't find anything that seemed to apply or help me. The computer I'm trying to open it on has Office 2003, the one I most recently worked on the file on has office XP. Not sure if this was a source of the problem. Doesn't seem like it should be. Hasn't been in the past. I'm not even getting to the dialogue box asking for my password yet.
View 2 Replies
View Related
Oct 20, 2006
how to alert and force second user to quit (i.e. even cannot open the file as "read-only) if the excel file is being opened by other?
View 3 Replies
View Related
Jun 12, 2007
I am using the following code and putting it into a module.
Private Sub Workbook_Open()
MsgBox "Hi, thanks for opening me", vbInformation, "Ozgrid.com"
End Sub
when i open the file and click on allow macros it does not run.
View 2 Replies
View Related
Jul 26, 2007
For a project I need to develop excel spreadsheet that will contain two columns. First column will contain list of sale items. Other column will contain hyperlink to the items image as pdf file stored on hard drive somewhere. My requirement is to highlight row containing sale item, whoes pdf file is modified/updated since the last time user has opened the spreadsheet.
View 8 Replies
View Related
Aug 5, 2008
I am trying to refer to an open file in VBA script.
The script below is asking the user to open a file from which data is copied. I am trying to refer back to this open file but as the file name and path are not mentioned in the script, I am not able to.
myMsg = "Please Select Euromcontact Master DISTOPS File"
Response = MsgBox(myMsg, vbExclamation + vbOKOnly, myTitle)
sFileName = Application. GetOpenFilename
Workbooks.Open Filename:=sFileName
Sheets("CL value").Select
Sheets( Array("CL value", "CL Units", "CLC Value")).Select
Range("N12:N37,S12:Z37").Select
Selection.Copy
Windows("Euromcontact Value File TEMPLATE.xls").Activate
Sheets("CLvalueDIS").Select
Sheets(Array("CLvalueDIS", "CLUnitsDIS", "CLCvalueDIS")).Select
Range("R12").Select
Selection.PasteSpecial Paste:=xlValues
Sheets("CLvalueDIS").Select
Sheets(Array("CLvalueDIS", "CLUnitsDIS", "CLCvalueDIS")).Select
Range("R12:R37").Select
Selection.Copy
Range("N12").Select
Selection.PasteSpecial Paste:=xlValues
Range("R12:R37").Clear
Application.CutCopyMode = False
View 9 Replies
View Related
Apr 17, 2013
I have a master file which users are able to open via read only or go in via password to edit.
I'm not too bothered on the read only users more on person's entering the file via password, making any changes and then saving those changes.
Is there a way to trace what changes they made and would their name be saved as the new "author" of the file?
View 4 Replies
View Related
Aug 5, 2013
I am runnig Excel 2010. I was wondering how I lock an Excel file (make it 'Read Only') if someone already has it open?
View 1 Replies
View Related
Oct 16, 2008
I have a macro which opens two different hyperlinks in excel. Opened workbooks have are named like 1.asp and 2.asp. Both contains only one spreedsheet. I need to copy these spreedsheets to the Workbook, from which they are opened.
View 4 Replies
View Related
