Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
Articles & Videos
Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.
I want to copy also the row height, from row 1 to row 6, by these codes
(CODE)If you see the attached Excel file, some rows is having short height. How to ensure the above to achieve what I expect…
First Tab - Master customer data file. Tab Name = "MASTER"
Second Tab - specific data for an individual customer. Tab Name = "13 n clark"
Goal: How do you automatically populate the 2nd tab from …
Don't know very much about forms so sorry if this is a roundabout way of describing my isssue.
I have a table of sales orders that includes a Yes/No field added on called 'SelectedPrint'. I'…
Hello guys i am trying to find out if this is possible, thanks again for your time and help.
On the "J" column have the Letter (Q) display no more than five times with the color of BLUE if on colum…
I had this question after viewing Clubbing C (https://www.experts-excha
Need little change in existing macro or say troubleshoot. in atta…
I have an unbound record-search combo-box on a form that after awhile stops working when I publish the database as an accde but I dont know why. Each time it happens, replace the database with a new a…
Below Code converts Path Entries in Column 'B' to Hyperlinks. The macro works just great.
Could somebody help me to tweak this code in the following way:
The path entries cou…
I want to create a library of VBA code in Word.
Is there a way of pasting the code so that it preserves formatting, tabs etc? (and remove spellcheck!)
Also, I'm open to suggestions on h…
I had this question after viewing Posting C - Partial (https://www.experts-excha
Will anyone help me with club this 3 Macros in to …
New to MS Access so apologies in advance for glaring errors. I'm trying to leverage an Access template to build a database which can create and print invoices (or save as PDF).
Have a form c…
I have a code for wordmerge but, the match case doesnt seem to work .
I have TO: and To: to replace and it is not able to distinguish between the cases and replaces everthing .
on this module i would like to create an additional request that when it finds the word (ZCOMPLETED) have it appear on column "C" (Z)
and (HOLD) Appear (H). thanks for your time and help guys.
I would like to make two function work in conjunction when i click on one button. Thanks again for your time and help.
I would like to have this code from Modules
To work in conjunctio…
Hello and good day to all Experts Exchange users and helpers. I am trying to have this work in this way.
Search for column "G" and find all with number that has 1 on column G.
***If there is a n…
I am trying to copy the data from one sheet to another using vba. But it copying and pasting the data with the header. Is there any way it doesn't copy the header just copy the data with the selection…
I have a multiple workbooks which has columns to Workbook and I have standard a standard excel file. All i have to copy each workbook into standard template and save the template with cell D1 and re56…
I Receive an Input file with thousands of rows and multiple columns
Below are the steps
1: In the Input file I have columns A:R
2: I have file upload template (standard template desighne to up…
Instead of MID which starts at the beginnng of a line of text, the formula or user-defined function that would start at the end of the text and search toward the beginning. I need to select from the …
I have a document where question and answer have different styles assigned to each (for question "*Questions" and for answer "Normal"), answer can have multiple paragraphs or even image, so basically …
I have an Excel table which I need to filter, need to copy resulting set into empty email and send it to appropriate recipient.
I tried to play with VBA in Excel, I can filter table, …
Regardless of if the filename is 10 characters or 100 characters long.
in Powershell preferably.
Thank you very much.
When I send this to Access 2016 via ADO/VBA I get an error 'syntax error in INSERT statement'.
But when I copy/paste the same into the Query window in Access it runs OK. No error!
Am I missing s…
Hello Experts Exchange Community, trying to create a code to do the following.
search for today date.
Then calculate how many days is left for each rows, that has dates on the "B" colum…
The code described here does no longer work. Please see replacement Article: http://www.experts-exchang
This Article is a replacement of http:/A_1788-Getting-your-
Subodh Tiwari (Neeraj)
Kanpur University, Uttar Pradesh, India
16,500 points this week
14,200 points this week
Chesterfield, United Kingdom
6,800 points this week
6,000 points this week
crystal (strive4peace) - Microsoft MVP, Access
4,800 points this week