file

  1. H

    VBA - Open PDF file

    Hello All, How can we open this pdf file with VBA macro. C:\Users\i ' M\Desktop\PDF\test file 123-234.pdf Any help would be appreciated Regards, Humayun
  2. lockarde

    Exporting Userform design and code to import in VB

    Hello all, I've recently created a userform within excel to take care of some quick calculations I regularly have to do. After getting it all set, I thought, why not make it a stand alone app, instead of having to run excel everytime? I tried exporting the userform, and I get two files, one...
  3. A

    Navigate and getting data from website

    Hi All, I am looking for VBA code where following steps areperformed: Open website https://www.abs.gov.au/Price-Indexes-and-Inflation Click on link “Consumer Price Index” on that page. Click on “Download” tab on that page. Open .Xls file from that page (do not save that file). Copy...
  4. B

    importing text file

    how do I keep the text format columns for columns A and X when importing a csv or text file to excel? when I used to use Excel 2010 I could pick the format for each column but I don't see that option when clicking data>from text/csv file and then it creates a query
  5. megera716

    Keep leading zeroes after Text to Columns

    I have a comma-separated .txt file of employee bank account information. When I open in Excel and run Text to Columns, it removes the leading zeroes from bank account numbers that have them. Even in the formula bar if I click on one of the cells that I know was an account number with a leading...
  6. M

    Recover Deleted Tab - I think we are out of luck

    Ok, so one of our executives often works on excel files straight from email - in other words, he opens an excel file straight from an email and DOES NOT save the file before making changes. He will have 20 excel workbooks open all in READ ONLY status. Well, he worked on a READ ONLY file for...
  7. T

    Copy multiple column.

    Hello, In a folder I have 2000+ files. I have to copy from each sheet1, range C5: Cx (each file has a certain number of rows ...), in the "Master" sheet, (starting with A1) from the file where the VBA code is launched. The data to be copied are TEXT. Can anyone help me with a VBA code? Thanks...
  8. N

    How to change dynamically excel external file name change daily as the date

    Hi all, I am a beginner to this technology VBA Excel. I faced a problem in the project Read an external file and look for a Specific String (This external file name will change daily – as the Date – which will be part of the file name – will be dynamic) Return a Value from the 8th Column...
  9. R

    Workbooks.Count problem

    I use Workbooks.Count to enable to Set a name to a new download. When the download is a .csv file there used to be no problem. However, in the last week (I have Excel 365, so it may have changed) a newly downloaded file of the generic ".csv" type does not get included in the Workbooks.Count...
  10. S

    Spaces don't look like spaces?

    Hello, I am putting together a string, and using the print statement to output to a file. I have an equation in the cell that I want to print out. The equation results in a string. That string has general characters, and spaces in it, and looks fine in excel. I use the following to print to...
  11. S

    Excel Operating on a PC

    Where can I go to find out why excel takes so long to save a large file, continually bogs down while performing macros etc. I use several different large spreadsheets with lots of calculations going on, they run and save quite well on my PC but bogs down on my assistants PC. Here is one error...
  12. Belair58

    Graphing from a $ delimited txt file

    Hello, I'm outputting a delimited txt file using $ as my delimiter from SQL server. This file will be output once every 5 minutes. I'm wanting to graph this data on a continuous basis. I'm trying to link it through Data / From Text/CSV, but it doesn't give me the option to choose the delimiter...
  13. D

    VBA Macro link to daily report

    Dear Forum, I need a little wisdom here please. I have managed to create a working Marco that filters, formats, deletes etc. a worksheet report. The Marco name is: Daily_Report_Filter Each day we need to pull a report, the report data and structure is always the same but the file name...
  14. J

    Highlight cell based on values

    Hello, i have multiple tabs in file and have to Highlight column from N to AL if values are matching in row AU to BF below is link i have saved file on google drive. https://drive.google.com/file/d/1FYh4lIrxGrvTeLdB7bP52DI4xinyhZv9/view tnx alot for your precious time and valuable feedback...
  15. S

    unable to open file

    Good Morning I have an end user that can't open a 5 meg file. The pertinents are excel 2013, 32 bit, windows 10 64bit it is a macro enabled sheet came in email the file has references to external data. a very small cluster of users can't open it, but a large majority of user CAN. it's not...
  16. J

    Excel Automatically Changing General to Date

    This doesn't happen for every file but for one in particular...a cell has a general format. I close the file and reopen it. The cell now is changed to date. For example, I have a column that has customer number. The cell has 127487, formatted as general. When I reopen the file (doesn't...
  17. G

    VBScript code to wait for Refresh All before saving excel file

    I have put together a VB script to refresh all excel files in a folder without opening them. The issue I am facing is that the excel files close before allowing the data to be refreshed. Is there any way to force the VB Script to wait till the data is refreshing and then save the file? Also, I...
  18. A

    Open Directory for user to choose a file

    Hello, I hope i can get some help from people whom i regard as super smart. The code below (that i have managed to get from others) finds the username and computer name so that other users would be able to use the same code on their computers. I had hoped that the code would also open the...
  19. C

    Batch Script for New Versions and Shortcuts

    I administer an MS Access DB with approximately 20 end users. Each user has a copy of the FE on their desktop. When I need to make changes, the Form_Load Event of the initial form identifies that a new version is available and runs a batch script to copy down the new version of the front end to...
  20. R

    Save File name to a cell specific location

    Hey all, i've done searches on this forum without finding much luck as to why my macro isn't working. I'm trying to have a macro assigned to an object that once hit will save the pre-filled file name (as shown in the example below). Here is my coding so far: Sub SaveFile () Dim FN As String...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top