Problem refreshing excel 2003 ms query using excel 2007
I have several ms queries that were created using excel 2003. Now I have excel 2007 and I can't refresh or even edit the queries. I get odbc errors like 'data source name not found and no default driver found. I can create new ms queries in 2007 from the same database with no problem. I just...
I have several ms queries that were created using excel 2003. Now I have excel 2007 and I can't refresh or even edit the queries. I get odbc errors like 'data source name not found and no default driver found. I can create new ms queries in 2007 from the same database with no problem. I just...
5 pts.
Excel 03 won't release cell
We've had a couple of users run into issues with Excel 03 not releasing a cell as if were in EXT mode. Problem is that when we press F8 it won't release it. ESC hasn't helped and it locks up the workbook so the only way to close it is through Task Manager. Running Windows XP Pro SP2 with MS...
We've had a couple of users run into issues with Excel 03 not releasing a cell as if were in EXT mode. Problem is that when we press F8 it won't release it. ESC hasn't helped and it locks up the workbook so the only way to close it is through Task Manager. Running Windows XP Pro SP2 with MS...
Excel 03 opens as Read Only always
We have a user that is only able to open Excel 03 files in Read Only. No other MS Office does this to her. It even happens to Excel files she has created and files that she receives in emails. Any ideas would be helpful since we are at a loss. Windows XP Pro SP2, MS Office w/Outlook 03. Thanks
We have a user that is only able to open Excel 03 files in Read Only. No other MS Office does this to her. It even happens to Excel files she has created and files that she receives in emails. Any ideas would be helpful since we are at a loss. Windows XP Pro SP2, MS Office w/Outlook 03. Thanks
Using Access query data in Excel
I have a need to use some employee data that is contained in an Acess database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any sucess. I can move the entire file, but I really need to move only the data that meets some selection...
I have a need to use some employee data that is contained in an Acess database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any sucess. I can move the entire file, but I really need to move only the data that meets some selection...
How to run a query in PS Query using Microsoft Excel macro
Hi, I am working on a macro in Excel that can automate the running of a query in people soft PS Query application.Result should also be save in Excel format at given path. Here is what i exactly want to do 1. Put all query name under column A.(not entire query only its name) 2. Run macro 3....
Hi, I am working on a macro in Excel that can automate the running of a query in people soft PS Query application.Result should also be save in Excel format at given path. Here is what i exactly want to do 1. Put all query name under column A.(not entire query only its name) 2. Run macro 3....
STRPCCMD with blank in path
I am trying to start an Excel spreadsheet with a blank in the path. ex: STRPCCMD 'START K:\My Documents\GL\Monthend.XLS' I've tried all sorts of QUOTE scenarios but have not hit on the right set. Thank you MIS
I am trying to start an Excel spreadsheet with a blank in the path. ex: STRPCCMD 'START K:\My Documents\GL\Monthend.XLS' I've tried all sorts of QUOTE scenarios but have not hit on the right set. Thank you MIS
Extract text from HTML pages, separate into articles, extracts keywords, tag with keywords, import to wordpress
We run a niche news B2B news service; every day we send out an email with between 10 and 30 stories in it. This email is then turned into an html page including all the stories, and uploaded to our website. This has been going on for around 6 years, so I reckon there are about 1500 individual HTML...
We run a niche news B2B news service; every day we send out an email with between 10 and 30 stories in it. This email is then turned into an html page including all the stories, and uploaded to our website. This has been going on for around 6 years, so I reckon there are about 1500 individual HTML...
Microsoft Excel hyperlinks to Lotus Notes
I created a hyperlink in MS Excel to an E-mail address (I use Lotus Notes). When I follow, the email is created with the correct subjsct line however the text line is blank i.e., simply not there, even though it appears in the "text to appear" diologus box. Does anyone know why this is?
I created a hyperlink in MS Excel to an E-mail address (I use Lotus Notes). When I follow, the email is created with the correct subjsct line however the text line is blank i.e., simply not there, even though it appears in the "text to appear" diologus box. Does anyone know why this is?
Upgrading from excel 2003 to 2007
After upgrading our laptops from Office 2003 to Office 2007 somehow the permissions in the IFS have changed and certain groups can no longer save Excel documents with system i data. They get a "cannot save" message. Any idea where to look? Netserver etc.?
After upgrading our laptops from Office 2003 to Office 2007 somehow the permissions in the IFS have changed and certain groups can no longer save Excel documents with system i data. They get a "cannot save" message. Any idea where to look? Netserver etc.?
Excel to Access conversion
When I import data from MS Excel v2003 into MS ACCESS v97, some of the data converts (numbers) converts to scientific form (4268411 converts to 4.26841e+006) even though I specify that the column format is text. How can I stop this from happening?
When I import data from MS Excel v2003 into MS ACCESS v97, some of the data converts (numbers) converts to scientific form (4268411 converts to 4.26841e+006) even though I specify that the column format is text. How can I stop this from happening?
Office 2007 labels using an Excel worksheet
What to do when I cannot get Excel spreadsheet to link with WORD document to make mailing labels
What to do when I cannot get Excel spreadsheet to link with WORD document to make mailing labels
Unable to run macro in Microsoft Excel 2007
unable to run any macros stored in this workbook. macros stored in the personal file will run,
unable to run any macros stored in this workbook. macros stored in the personal file will run,
ExcelSource file - metadata validation
I need some assistance. I am using an excel file to import data to SQL tables. The problem I am running into is having to replace the metadata of the output columns with the metadata of the external columns. I do not want to do this manually everytime. [The metadata of the following output...
I need some assistance. I am using an excel file to import data to SQL tables. The problem I am running into is having to replace the metadata of the output columns with the metadata of the external columns. I do not want to do this manually everytime. [The metadata of the following output...
Excel 2003 ranking with VLOOKUP
I know there is a way to rank a list without using the "sort" feature in excel but rather formulas. I need to sort the list of 25 items below by the first column with the highest value first. What formulas do I use? Thanks for the help. Weight Management 65% 74% 67% 84% 75% Healthy...
I know there is a way to rank a list without using the "sort" feature in excel but rather formulas. I need to sort the list of 25 items below by the first column with the highest value first. What formulas do I use? Thanks for the help. Weight Management 65% 74% 67% 84% 75% Healthy...
Does Apache POI-XSSF support Excel 2007 runs under Java 1.4?
Hi Guys, Is Apache XSSF POI supports java 1.4 to upload the Excel 2007. Thankx.
Hi Guys, Is Apache XSSF POI supports java 1.4 to upload the Excel 2007. Thankx.
ORACLE REPORTS6i CONVERT DATA IN EXCEL
Dear Sir, I visited your side & i really got some new features,i will be very thankful to you to give me answer of my question How can i convert Oracle Report6i data in Excel as like i print in screen Thanks
Dear Sir, I visited your side & i really got some new features,i will be very thankful to you to give me answer of my question How can i convert Oracle Report6i data in Excel as like i print in screen Thanks
I am getting "compiler error in hidden module" error in Excel 2003 while running Macro
I am getting :"compiler error in hidden module " error in EXCEL 2003 only while running MACRO. Actully this MACRO is running on some PCs & for some PCs it is showing that error. The installation of MS EXCEL 2003 is same on all PCs. Please help me ASAP. Thanks in advance !
I am getting :"compiler error in hidden module " error in EXCEL 2003 only while running MACRO. Actully this MACRO is running on some PCs & for some PCs it is showing that error. The installation of MS EXCEL 2003 is same on all PCs. Please help me ASAP. Thanks in advance !
Complex Database Issue
I'll try to be brief: I have excel files that are downloaded via ftp to a folder where I have my DB. each of the excel files is "roughly" the same headers, I want to import all of these files, filter out all but 3 columns and then filter out certain rows in each table (at minimum, 25 tables) can...
I'll try to be brief: I have excel files that are downloaded via ftp to a folder where I have my DB. each of the excel files is "roughly" the same headers, I want to import all of these files, filter out all but 3 columns and then filter out certain rows in each table (at minimum, 25 tables) can...
