I have a VBA program that loads a pivot table into a VBA array. The program then creates various spreadsheets required. It opens a new excel file, populates the data, then saves the file and closes the file. The program creates circa 270 excel / CSV files. However, just recently we have run...
Hi still more or less a newbie here. I have an excel export of items that have a hyperlink to some online documentation. I haven't figured out how to do the following:
Capture the links along with their associated par name
Put the links in the corresponding folders on the network in...
Hi,
I'm trying to create a command in a file "Directory Creation Test.xlsm" which will, on pressing a button, do the following:
1)Search for a folder, and if it does not find it, create one.
Example: Find the folder "Test" in the directory C:\Filing System, and if it does not exist, create...
Greetings!
I'm working on an portion of code in my workbook to FTP some files. To do that, I'm creating a FTPcmd.txt file via code containing the FTP commands, closing the file and then shelling the FTP command in the CMD window. It looks like the command file is taking too long to complete...
I have created a macro that when you click the button in excel it lists the information in a few certain cells from multiple excel files. It works okay apart from the fact it opens a new excel to do it rather than doing it in the excel with the button in it.
Please can some one look at my code...
Hi all,
This may be something obvious but I simply want to create a new .mdb (Database) file via VBA code.
I would normally enable the Access reference in VBA and just create a new database that way, however the system where I plan on using this doesn't have Access references so I need to...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.