Hi there,
attached please find the workbook...have two worksheets in it say S1 and S2.
also added the detail in the text boxes in the attached Excel file itself.
need a macro in visual bas...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I'm working in Access and playing with VBA. I want a user to click a button, have the file open dialog open, they select a spreadsheet, and then it imports into a table. The problem is the filena...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Coding-Macros/Q_234...
I am using an Access Project (.adp) 2003 (Access 2000 file format) connected to SQL Server.
I have a code line behind a button on a Form to show a report:
DoCmd.OpenReport "rptReceipt", acViewP...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Reports/Q_23693927....
I am still a beginner with VBA, but can create som pretty goood automation tools. But I just came up against a wall. I have a macr that runs from a VBA application called Reflection for IBM. Thi...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23649375.html
Zones:
Visual BasicDate Answered: 08/18/2008 Grade: B Views: 4
I need help writing a macro that will open a pre-existing word document for me and make that newly opened document, active document. The name of the file to be opened will be based on the name of c...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23728539.html
I need help writing a macro that will open a pre-existing word document for me and make that newly opened document active document. The name of the file to be opened will be based on the first two ...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23728545.html
Zones:
Visual BasicDate Answered: 09/13/2008 Grade: A Views: 0
I need help writing a macro that will copy a file (C:\Test Folder\Medication.doc) from one folder to another folder (G:\Test Folder\Medication.doc) provided the file which is being copied that is (...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23728562.html
Zones:
Visual BasicDate Answered: 09/14/2008 Grade: A Views: 10
I would like to have a macro which will save the contents of the currently active document in a pre-specified folder with a particular name. The name of the newly saved file should be made up of th...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23728738.html
This may be a very difficult thing to do, but I thought I will ask in case there is a solution.
I have two folders (C:\Source and C:\Destination). Both C:\Source and C:\Destination have 5 files ...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_23728971.html
Hey!
I've been spending more time on this problem than I should be. I have a worksheet named "Sheet_A" that has values in column B. I want extract all the distinct values in column B and store e...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
