VBA Localization
Is there a way that I can localize VBA macros into a second language without opening the macro in VBAIDE and laboriously going through each line of text and each control on every form. Some of the macros are very large and include a lot of forms and controls. Some of the macros are in VBA for...
Is there a way that I can localize VBA macros into a second language without opening the macro in VBAIDE and laboriously going through each line of text and each control on every form. Some of the macros are very large and include a lot of forms and controls. Some of the macros are in VBA for...
5 pts.
How to paste data directly from Excel to PowerPoint graphic as data
I've been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual graph and paste the data in. Any help...
I've been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual graph and paste the data in. Any help...
Combining data from two Excel sheets into a new sheet
Hi, I Have few leave detail excels wherein the leave details of each resource are present.I need help to create a macro wherein all months leave details will be clubbed together into a new excel for each resource.Kindly help me with the code or give me some ideas to do this since am very new in...
Hi, I Have few leave detail excels wherein the leave details of each resource are present.I need help to create a macro wherein all months leave details will be clubbed together into a new excel for each resource.Kindly help me with the code or give me some ideas to do this since am very new in...
How to paste data directly from Excel to PowerPoint graphic as data
I've been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual graph and paste the data in. Any help...
I've been trying to search for ways to copy data from a spreadsheet onto the datasheet of a graph in an open spreadsheet. I am unfamiliar with VBA code, but got it to copy and paste to the correct slide, but only as text. I have been unable to select the actual graph and paste the data in. Any help...
How can I read a text file for use with Microsoft Word mail merge?
Hi I have a text file that the first row is the filed name that separated with comma and from second row there are data fields that separated by comma too. I want to read this file record by record and make a report by it's data in microsoft word!! I have read just the first row of data by using...
Hi I have a text file that the first row is the filed name that separated with comma and from second row there are data fields that separated by comma too. I want to read this file record by record and make a report by it's data in microsoft word!! I have read just the first row of data by using...
To connect to Excel 2007 using free version API Java
Presently we are using JavaExcel(JXL) API to read/write from the Excel 2003. Now we have to update to Excel 2007. The problem was JXL is not supporting for the Excel 2007. The other API's are in the Beta version. Guys any API's are there to support Excel 2007 ......
Presently we are using JavaExcel(JXL) API to read/write from the Excel 2003. Now we have to update to Excel 2007. The problem was JXL is not supporting for the Excel 2007. The other API's are in the Beta version. Guys any API's are there to support Excel 2007 ......
How to capture the height,width of the latest picture inserted in word using macros,VBA?
Hi, My task involves capturing the height , width of the latest picture inserted in word using macros,VBA.
Hi, My task involves capturing the height , width of the latest picture inserted in word using macros,VBA.
Conditional formatting
How do I get conditional formatting in a form to continue to work as a sub form
How do I get conditional formatting in a form to continue to work as a sub form
Not allowed to edit Microsoft Access forms
A previous employee built a very usable db, and has gone on to greener pastures. It isn't password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use Office Pro 2003. Any help...
A previous employee built a very usable db, and has gone on to greener pastures. It isn't password protected. When we try to edit the db with new fields or change wording in fields, it asks if we want to exit the app. if Yes is clicked, it exits the app and Access. We use Office Pro 2003. Any help...
How to use Access object library in my Windows application
dear friends , how to use docmd.opencurrentdatabse command to open an access application database please advise
dear friends , how to use docmd.opencurrentdatabse command to open an access application database please advise
Switching Excel Custom Views Based on Selection
I have two saved Custom Views for a protected worksheet that I use as an input and summer page for an estimating spreadsheet. I want to include a validated cell on the front page which would select one of these two custom views based on which answer the user selects. Unfortunately I am very...
I have two saved Custom Views for a protected worksheet that I use as an input and summer page for an estimating spreadsheet. I want to include a validated cell on the front page which would select one of these two custom views based on which answer the user selects. Unfortunately I am very...
How to pass value at run time from VB 6 to Access 2000 Query for reporting
I have developed a sall application. Data is in Access 2002, Development is in VB 6. For reporting I have designed Queries, using the queries I have designed the reports. It works fine. While run time I accepts the criteria or value from user, based on that I have to show reports. My question is...
Answer Question
| Oct 6 2008 10:19 AM GMT
Access, Visual Basic for Applications, Visual Basic developers
I have developed a sall application. Data is in Access 2002, Development is in VB 6. For reporting I have designed Queries, using the queries I have designed the reports. It works fine. While run time I accepts the criteria or value from user, based on that I have to show reports. My question is...
Answer Question
| Oct 6 2008 10:19 AM GMTAccess, Visual Basic for Applications, Visual Basic developers
Deleting all formulas in a worksheet when unprotected in VBA code
I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have...
I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have...
How can we insert space between text and a table in MSword using macros
My task is like this. SampleText Table1 with some columns and rows. I need to insert text between "SampleText" and "Table1". When I am inserting text it is inserted into the first cell of "Table1",however I have to insert it in between "SampleText" and "Table1" by inserting line break/space...
My task is like this. SampleText Table1 with some columns and rows. I need to insert text between "SampleText" and "Table1". When I am inserting text it is inserted into the first cell of "Table1",however I have to insert it in between "SampleText" and "Table1" by inserting line break/space...
Excel Form Macro
Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux'ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work...
Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux'ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work...
Excel 2003.novice user wants to set up database for research
Using Excel 2003. I want to set up a database that can be added to by using a form format with drop down boxes, tick boxes and boxes to enter data. Don't know what it's called. can I do something like this to then use it to make queries for certain data?
Using Excel 2003. I want to set up a database that can be added to by using a form format with drop down boxes, tick boxes and boxes to enter data. Don't know what it's called. can I do something like this to then use it to make queries for certain data?
VBA-question
How do I transfer 30 text files at a time into my access DB? I was able to get the files, but it did not transfer into the database. Thanks.
How do I transfer 30 text files at a time into my access DB? I was able to get the files, but it did not transfer into the database. Thanks.
Copy and paste in Excel using Visual Basic scripting?
First of all - Thank you.... I receive info in Excel worksheet "A" with columns of variable length which I want to cut and paste into Excel worksheet "B". Worksheet "A" info starts at B:13 and can range in length from 1 to 200 rows or more. I would like to copy this variable length...
First of all - Thank you.... I receive info in Excel worksheet "A" with columns of variable length which I want to cut and paste into Excel worksheet "B". Worksheet "A" info starts at B:13 and can range in length from 1 to 200 rows or more. I would like to copy this variable length...
Change Font Style of Menu Item Through VB6
My program is in varnacular language, i. e. input and output are in Gujarati (Indian) language, by changing the font to "Gopika.ttf". So, during the execution of my program I want to show menus also in Gujarati. Normally, we change this from desktop --> properties --> appearnce -->...
My program is in varnacular language, i. e. input and output are in Gujarati (Indian) language, by changing the font to "Gopika.ttf". So, during the execution of my program I want to show menus also in Gujarati. Normally, we change this from desktop --> properties --> appearnce -->...
programming
Tag# 301-22-AB02-103, I want this Tag format in this formate XXX-XX-NNXX-XXX, it means in place of Numbers i want 'X' and in Place of alphabet i want 'N', do you know how can you we do that in Excel? i wana to change numeric values in 'X' and alphabet in 'N' form, and my friend did already, through...
Tag# 301-22-AB02-103, I want this Tag format in this formate XXX-XX-NNXX-XXX, it means in place of Numbers i want 'X' and in Place of alphabet i want 'N', do you know how can you we do that in Excel? i wana to change numeric values in 'X' and alphabet in 'N' form, and my friend did already, through...
