When I export MS Project data to Excel I employ a series of statements that open Excel via either: Set xl = GetObject(,”Excel.application”) or
Set xl = CreateObject(,”Excel.application”)

I would like to answer me about VBA in the Excel . I added Sub () inside the MODULE and I want him to see him more than one form, but just one form sees it I don’t know why,,,

I have the following code:

I am new to vba please help me decode this 400 error and i am trying to apply leave for multiple days after selecting PL and its not going from select cell and it’s showing 400 error
This is the code
Sub CreateLeaveApplication()

In a program I’ve been working on, I had a subroutine that had a string array as a parameter.

I’m trying to take information from one workbook (multiple sheets) and paste them into a new workbook in multiple sheets. Right now, If I run it while I’m in the “RW Crossings” tab, my export for “Master Crossing List” works fine, but no data populate in the “Access Road Crossing List” tab. Vice versa, if I’m in the AR Crossings tab, it populate the Access Road crossing list tab, but not the master crossing list.

Hello Every One VBA Experts!
I have a survey like this. One Company may have 1 to 10 products and this number veries from company to company.
I would Like to transfer each company survey to a Base, when each product will take a row, and the company name will repeat for all products it sells.

I have written a series of macros to extract the sentences and words in a novel. The numbers of each word are counted, and for each word, an example sentence containing that word is provided. Sentence variety is optimized, meaning that whenever a word is found, if the previous sentence associated with that word had a frequency (total within the corpus) of n, the new sentence selected for that word will be selected if its frequency in the corpus is less than n.

I’m learning VBA and would like to see if I could recieve some feedback as to my attempt to take a table range and filter where Generate = “x” and copy range, non-continious column header and down, and paste into a new workbook and save.

I have the following scenario. There is a macro in outlook that i have configured as a button under a certain tab. I want to run that macro at a scheduled timing. Can Have a vbscript to invoke a click action on that button to run the macro? If not, can I run the vbs outside of outlook to invoke the macro execution?