File referencing in vba
Hi All. I have a user form in Word that populates a doc, saves as a temp file, emails as attachment and then kills the temp file. I am worried that with momre than one user at any one time one person's code might kill another person's temp file before they have sent it. Any ideas as to how I might...
Hi All. I have a user form in Word that populates a doc, saves as a temp file, emails as attachment and then kills the temp file. I am worried that with momre than one user at any one time one person's code might kill another person's temp file before they have sent it. Any ideas as to how I might...
5 pts.
VBA/VB code to edit hyperlinks in PDF files
Hi, How do we read the content in a pdf file. I have some sample pdf where I have to edit already existing hyperlinks . Thanks in advance.
Hi, How do we read the content in a pdf file. I have some sample pdf where I have to edit already existing hyperlinks . Thanks in advance.
Outlook 2003: trim leading spaces from email subject with VBA macro
Hello, some email clients send emails with an extra leading space added to the subject. As a result message sorting on subject in outlook 2003 does not work correctly: these messages are considered to have a different subject and so the entire conversation is split in two seperate conversations,...
Hello, some email clients send emails with an extra leading space added to the subject. As a result message sorting on subject in outlook 2003 does not work correctly: these messages are considered to have a different subject and so the entire conversation is split in two seperate conversations,...
rolling average VBA code MS Access
Hi All Anyone know how to create a VBA function and or SQL statement which will work in Access to find the rolling average as per example below + see excel file for working example in excel. Should work for a unknown amount of records. Not an easy one I think :-). If it can be done without using...
Hi All Anyone know how to create a VBA function and or SQL statement which will work in Access to find the rolling average as per example below + see excel file for working example in excel. Should work for a unknown amount of records. Not an easy one I think :-). If it can be done without using...
Writing vertical data to a flat (unfortunately!) table
I have an application that I need to update (written by someone else) that requires that I take data from a nice, vertical table and write them into a pre-exisiting flat table. Column 1 of the vertical table is the PK for the flat table, while there are up to 35 entries that must be written into...
I have an application that I need to update (written by someone else) that requires that I take data from a nice, vertical table and write them into a pre-exisiting flat table. Column 1 of the vertical table is the PK for the flat table, while there are up to 35 entries that must be written into...
SpinButton linking to an occupied cell
Can a spin button be linked to the cell that it is located in? I have about 100 spin buttons that I need in this sheet and don't want to individually link each one! Thanks!
Can a spin button be linked to the cell that it is located in? I have about 100 spin buttons that I need in this sheet and don't want to individually link each one! Thanks!
VBA to print to specific printer with print button
In Access 2007 how do I use VBA code in my print button to print to a "specific printer" for my report.
In Access 2007 how do I use VBA code in my print button to print to a "specific printer" for my report.
Microsoft Access 2007: Using an IF statement
I want compare a field in one record to the same field but in the next record. For example I have this IIF statement: IIf(([MAILADDRESS]=[MAILADDRESS]),True,False) This will compare the MAILADDRESS in the same record but I want to compare that same field but in the following record. How do i do...
I want compare a field in one record to the same field but in the next record. For example I have this IIF statement: IIf(([MAILADDRESS]=[MAILADDRESS]),True,False) This will compare the MAILADDRESS in the same record but I want to compare that same field but in the following record. How do i do...
Search Excel Macro Help!
I do not know scripting and i really wish i did, any help would be greatly appreciated!I have an excel document that I need to search through for a list of words, when of the words from my list is found, i need the word it found to be put into a new column.
I do not know scripting and i really wish i did, any help would be greatly appreciated!I have an excel document that I need to search through for a list of words, when of the words from my list is found, i need the word it found to be put into a new column.
VB_Combo_Like_VBA
Hi Experts in VB 6.0 Please Tell me how I code for combo just like Access form eg. In Access Form's Combo -- when we start type any letter then nearest matching data should be selected and auto also showing during typing in the combo box Question : Please give any idea for VB 6.0 Combo --- so...
Hi Experts in VB 6.0 Please Tell me how I code for combo just like Access form eg. In Access Form's Combo -- when we start type any letter then nearest matching data should be selected and auto also showing during typing in the combo box Question : Please give any idea for VB 6.0 Combo --- so...
Perplexing Combo Box
I have a set of combo boxes that I would like to have January through December added to as options. I need all of them to be exactly the same. Any suggestions other than With cmbMonth1 .AddItem "January" .AddItem "February" End With With cmbMonth2 .AddItem "January" .AddItem "February" End...
I have a set of combo boxes that I would like to have January through December added to as options. I need all of them to be exactly the same. Any suggestions other than With cmbMonth1 .AddItem "January" .AddItem "February" End With With cmbMonth2 .AddItem "January" .AddItem "February" End...
How to paste data directly from Excel to PowerPoint graphic as data using Excel VBA
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 existing graph and paste the data in....
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 existing graph and paste the data in....
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...
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...
new to macros - extracting data
Hello, I'm just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box(course...
Hello, I'm just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box(course...
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 ......
