Got a message 'Cannot start the source application for this object' when double clicked on Adobe acrobat object in excel file Descriptions I try to open an embedded adobe pdf file within excel and it isn't opened. Excel 2010: cannot start the source application for this object. Here is what's happening when I insert an Object (PDF) in excel 2010, it works fine for the first.
I'm trying to open a pdf file from within excel vba. I have tried using the followhyperlink method but adobe acrobat opens very briefly then immediately closes Code: Sub OpenPDF 'Dim pdf As String On Error Resume Next 'pdf file to open pdf = 'K: PDF mypdf.pdf' 'open the pdf file ActiveWorkbook.FollowHyperlink pdf End Sub So then I tried to create an instance of acrobat by setting a reference to the acrobat object but I can't get this to work either! The code I'm using is Code: Sub OpenPDF Dim pdf As AcroPDDoc Dim strPDF As String Set pdf = CreateObject('AcroExch.PDDoc') 'pdf file to open strPDF = 'K: PDF mypdf.pdf' 'open the pdf file pdf.Open strPDF End Sub Any ideas what could be wrong with either approach? Using VBA, I am trying to retrieve the contents of the Source of a web page (the same as would appear if you right-clicked on the page and chose 'View Source') into a variable so I can work on it in VBA (using InStr, etc.). The problem is I can use code such as strHTMLText = ie.Document.body.innerText or strHTMLText = ie.Document.body.outerText to retrieve the code, but in either case only part, not all, of the source code is captured. I need ALL the code. Is there some kind of code such as ie.Document.body.allText or similar that would perform this function?
Much obliged! Hello, I have a number of different files that I often need to run a macro on. In order for me to do it on the 75-100 files I have at any given time, I need to open one, run the macro, close and save, then open the next one.
Is it possible to write a macro that will start with the first file in a folder, open it and update links, run a macro, save and close, and open the next file in the folder until it has open all the files in the folder. I have experience with creating macros that reference different workbooks, but not sure how to go about opening files with different filenames (without referencing the exact filename). I'd like to be able to have basic code for opening, saving and closing, opening next file, saving and closing, etc.
And input the macro I'd need to run in each file in the appropriate location. Is this possible? Any help is greatly appreciated!! Thanks, Jason. I have searched and read all the help files. I find the properties of an object, I see how I can 'lock', 'size and move with cells' or 'not move with cells'. No matter what I select, the object moves off the screen, when the user, scrolls to the right of the spreadsheet.
Is there a way to lock the position, let's say, in the upper right corner and have it stay there? This would be quite useful for an EXIT button, that I have created, that will close the program without saving (it's a read-only file.) Thanks to all the wonderful people here that have been so helpful and give us their valuable insight and time.
I have a file that became too big due to phantom bloat, unused range saved by Excel and all that kind of reasons. Thank to previous posts on that board tackling that issue, I was able to find how to proceed to reduce the file back to its normal size. But I did so in a beta file (test file). The real file has become so big (103MB!) that Excel cannot even open it anymore! The file contains archive info that we do not have anywhere else.
Is there anyway then to open the file or to reduce its size without opening it (through magics.)? I just honestly don't know how to retrieve that info before deleting that file. Thank you very much for your help. I'm trying to use VBA to go to a website that requires a User Name, Password, and a Submit Button. So far I can get everything to work besides the Submit part. The code runs without errors, but doesn't actually 'hit' the submit button on the webpage. For posting, I removed my actual user name and password and and used the generic ' User Name ' and ' Password ' highlighted in blue.
I highlighted another section in green that I took from a previous post hoping it would solve my problem. I know this question has been asked a bajillion times, so I apologize for the redundancy. I am working with an Excel spreadsheet and saving it as a.csv file in order to upload to an application that parses out the.csv data as transactions. The system requires.csv files, so this is how I need to save my doc (with this extension). I have been successful at preventing Excel from coverting that long number into scientific format. I have saved as a TXT file, pasted the longer number and it displays correctly.
That is all good. But I have to save as a.csv. So if I do that, close the Excel window, and then open again (as the.csv file), the numbers are back to being displayed in scientific format. I have tried creating an Excel doc from scratch and entering text in Text format, to see if this created a cleaner file.
But again, the second I save as.csv, close the window and then open that file up again, that dang scientific format is back. Does anyone have any idea of how to work around this?
Once I have successfully gotten the numbers to display as the long-chain number, how can I get them to 'stick' so that they don't revert back to scientific format when I reopen the file? Thanks so much for your help! I'm having a problem in a workbook with several ActiveX command buttons. I had been using the form control buttons to run macros, but the boss wanted each button to have it's own, different color. So I removed the form control buttons and created new ActiveX command buttons. I got into the button properties and set the background colors. I added the Click code to run the macros when the user clicked the buttons.
All of the buttons were working fine. Then I saved and closed the workbook and went to lunch. Now when I open the workbook, the buttons don't work!
When I click them nothing happens. They appear frozen. They don't even seem to click. No error message. If I right-click the button in Design Mode and select Properties, I get sheet properties not the button properties. I can't seem to locate the command button properties any longer. I still see the button name 'cmdButtonGetInfo' and '=EMBED('Forms.CommandButton.1',') in the name box and formula bar.
The odd thing is if I create a new button it works fine until I save and close the file. When I reopen the file none of the buttons work. It's like the buttons are being disabled when I close or open the file. Any suggestions? Hi all, The following code is placed in workbook 'A' and is used to open workbook 'B'.
These workbooks will now always be housed in the same directory and i want to change the code to use a relative path reference by determining the path of workbook 'A'. Here's what I had: Sub incomestatement Application.WindowState = xlMaximized Application.Workbooks.Open 'C: Documents and Settings. Workbook B.xls', UpdateLinks:=xlUpdateLinksAlways End Sub could you suggest how to change this to use a relative path reference? I would like to copy a small table from Word into one cell in an Excel worksheet. The first column of the table is a list of numbers. I tried converting the table into text with manual line breaks and tab stops to divide columns and rows, but that didn't solve my problem.
Excel pastes the data into several rows. When I try to merge them, I get a warning that the selection contains multiple data values, and merging into one cell keeps the upper-left most data only. What I tried that didn't work:. Formatting the Excel cells as text before pasting the data.
![Mac Excel Cannot Start The Source Application For This Object Mac Excel Cannot Start The Source Application For This Object](/uploads/1/2/5/5/125563305/697402192.jpg)
The various options for 'Paste Special.' The closest I got was inserting the table as a Document Object, which could be a workaround, I guess.
What I am saving for when all else fails:. The obvious solution of copying row by row into one Excel cell. The data in the table is information about my dad's medications. I would like to have reference charts of how to identify the strength of each tablet by its color and markings. I got the info from the manufacturers' websites and entered it into tables in Word, which I would like to copy into a more comprehensive file I am creating in Excel. The first column of each table is the strength of the tablet, entered as 1 mg., 2 mg., etc.
The subsequent columns describe the shape, color, and markings. There are 3 tables, each with about 4-5 rows.
Is there a way to copy each one - whether as a table or as text - into a single Excel cell without losing data? I need help desparately. Last night I spent several hours working on an Excel 2002 spreadsheet and it has disappeared.
I saved it routinely as I was making many changes updates etc. I opened original file -stuff.xls - made changes and saved it as again as stuff.xls. I have done this several times before.
Today, when I go to open stuff.xls, it is nowhere to be found!!!!! I have done a search, for any file modified since Thurs and nothing has appeared. I have checked the recycle bin, this did not go into auto recover nothing of the like. I am just traumatized, because I have NEVER had anything like this happen before. I even thought perhaps I didn't save it as often as I thought, (I know that I did) but I remembered that I saved it at least once and I can't even find an Excel file that has been modified since Thurs!!! Does anyone have any idea what could have happened to this file??
BTW, I have prayed, rebooted, run spybot, called witch doctor, all with no success. I have never had a file to just disappear with no trace. Any help would be greatly appreciated. Thanks in advance. Hi, I'm trying to get some macros to combine data from two open workbooks, and I can't figure out the commands to switch from the active workbook to the other open workbook and back. I'm new to VBA and just learning the ropes. All I can figure out is how to switch to another workbook with an exact name.
If I record the macro to go to a recent file, for example Window 1 (filename), the code that I get in VBA is Windows('filename').Activate. This doesn't translate to when I have two different workbooks with different filenames open. I'm a bit confused myself. Maybe just a list of basic workbook-switching techniques or commands would be useful.
I have some word documents that are embedded in Excel spreadsheets. When I double click I get this message 'cannot start the source application for this object'.
Hi, According to your description, this issue only occur with Excel 2013 file that embedded Word 2010 file. There Word 2010 file also could open well with Other computer. Thus, we may do more test. Please try to copy the content of Word 2010 file and paste to a new Word 2013 file. Then embed to Excel 2013 to test.
If Excel 2013 could open it, I suppose there are some compatibility issue between Word 2010 and 2013. We'd better use compatibility Check to check the content of these Word 2010 file. If this issue still exist, would you like share us a sample Excel with embedded Word 2010 file through OneDrive if possible. I want to test in my environment. Regards, George Zhao TechNet Community Support It's recommended to download and install, which is developed by Microsoft Support teams.
Once the tool is installed, you can run it at any time to scan for hundreds of known issues in Office programs.