file creation

  1. M

    Memory resource issue when opening and closing excel files

    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...
  2. J

    Hyperlink export to part specific folders on network.

    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...
  3. P

    Create and Maintain a Filing System Using VBA

    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...
  4. P

    Output text File creation/saving VBA code timing issue

    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...
  5. R

    fixing my macro so it doesnt do it in a new file

    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...
  6. Dave Punky

    Creating an .mdb file via VBA

    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've detected that you are using an adblocker.

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.
Go back
Back
Top