I'm running Office 2007 and since I upgraded, I can't simply click on a populated Excel file (either in outlook or saved on my hard drive) and have it open appropriately.
If it arrives in Outlook, I have to save the file then open Excel proper, then search for the correct file and open it that way. Even if it's a document that I've previously worked on then saved...I still have to open Excel the find the file through the Open venue.
Anyone have a workaround? My IT team is swamped and doesn't have the time to help.
It's becoming a giant PITA.
Thanks so much in advance.
When I try to open an .xls on my desktop I get an error message that says
"Cannot find the file blah blah blah... ( or one of its components). Make
sure the path and filename are correct and that all req'd libraries are
available. " However, I can open the file by opening Excel first and
then opening the file in Excel. Any ideas ? I have rebooted and re -
installed Excel and this did not help.
Thanks in advance. Smitt
I have a form that opens and hides the application to hide the excel sheets so all the user sees is my form. I need the user to be able to open other spreed sheets while my form is open. I can't get another excel to open like normal but it is hid behind my form.
What do you guys think?
Mark
Hi guys,
I have just created a VBA form and when i keep it open i am unable to open any other excel files.
Can someone suggest as to what is happening here and how can it be dealt with
regards
Rohitash
Can anyone tell me where is the setting so that excel opens for a second time
to create a second taskbar button when I open a 2nd .xls file.
At the moment the programme is opening only once and I need to go to excel
heading Windows=>and choose the workbook I want.
This is time consuming and I find it much better to quickly choose on the
taskbar pane whick file I want to work with.
Hello,
I'm having a problem bringing external data from the web into Excel 2007. For the most part, it works well, but then after 23 tables are opened in Excel, the rest are downloaded by Google Chrome, my default browser. By the way, I didn't have this problem in XP Home, but I've experienced it both in Vista Premium 64-bit and Windows 7 Premium 64-bit.
Perhaps there is a better way to get this data into Excel, but this is the way I have it set up right now.
I'm pulling in historical stock quotes from Yahoo Finance. Here is a sample URL:
http://ichart.finance.yahoo.com/tabl...=d&ignore=.csv
I have a simple macro set up to click a hyperlink (like the one above), which opens a table with the data. I then select all, copy it, paste it to the worksheet, move over 8 cells, and click the next one, and repeat until I run out of hyperlinks.
So, it works fine for 23 tables, but then it gives the error "A document with the name 'table.csv' is already open, and it sends the file to Chrome for opening.
I suppose that might be the problem, that there are too many "table.csv" instances open. But why does it allow 23 occurences to open and stop #24?
I'm not much for writing macros, so I just recorded it. I couldn't figure out how to have the macro close the table.csv file after copying the data I needed. Maybe it would be helpful if I posted the macro here, even though it's embarrassingly crude:
Sub get_h()
'
' get_h Macro
'
' Keyboard Shortcut: Ctrl+h
'
For X = 1 To 100
ActiveCell.Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
ActiveCell.Range("A1:G2317").Select
Selection.Copy
Windows("Financial spreadsheet - quicken replacement.xlsm").Activate
ActiveCell.Offset(1, 0).Range("A1").Select
ActiveSheet.Paste
ActiveCell.Offset(-1, 8).Range("A1").Select
Next X
End Sub
Hi chaps,
Im new to VBA / Macros and I would like to write a macro in Excel that will...
1. Open internet explorer
2. Navigate to the desired intranet web page
3. Open the desired csv file (it currently may be exported by cliking a hyperlink on web page)
Im using Excel 2007, I hope this is enough information.
Thanks in advance, any help appreciated
Laura
I just updated to Excel 2003 and whenever I open Excel, it automatically
loads around 12 workbooks. Why? and How can I stop these from loading?
I tried Googling the answer and could not find what I needed. Searched the forum as well and did not see this issue.
I am using Excel 2007 and the document I am trying to open is Excel 97-2003.
I can open any other Excel document and everyone else around me can open the document that I cannot.
I had two people next to me email me the document and neither one worked.
I have saved the document, opened excel, then opened the document. I have opened from the email and I have tried to open it from my Hard drive.
I am completely lost as to how I can get this to work.
Any help would be greatly appreciated.
Thanks,
can I run an excel macro when open outlook w/o workbook open or just not seeing the workbook be opened?
i already have a macro to send emails from excel based on a result of a single cell; i just don't see a point in also having to open the excel file, view the result in excel, then hit the macro button in excel just to send myself an email to outlook.
possible?
