Search:

Type: Posts; User: dougmarkham; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Looping through worksheets: auto-determine cell range in each ws; create dynamic tables??

    Hi Fluff,

    This worked very efficiently!!
    Thanks for your help. I'm going to try some other commands using this For Each Ws in Worksheets / Next Ws loop.
    Thanks for showing me this :), you're...
  2. Re: Looping through worksheets: auto-determine cell range in each ws; create dynamic tables??

    Hi Fluff,

    Thanks for replying!

    Yes, the data starts in A1.
    Is it possible to use pull through the ws Tab name for the table name (which is also Cell A2 on each ws)?

    Kind regards,

    Doug
  3. Looping through worksheets: auto-determine cell range in each ws; create dynamic tables??

    Hi Folks,

    I have been given a workbook with 200 worksheets: each ws contains some data that wish to manipulate.
    Is it possible with VBA to loop though the worksheets; determine the CurrentRegion;...
  4. Re: VBA AutoFilter: multiple criteria; array; does not contain

    Hi Nikio8 & Fluff,

    I think given the limitations of the program and the length of the dataset, I think I'll program a find & replace macro to change the customer numbers to one value so I can...
  5. Re: VBA AutoFilter: multiple criteria; array; does not contain

    Hi Fluff,

    Thanks for the link, this will be useful for sure going forward!

    Kind regards,

    Doug.
  6. VBA AutoFilter: multiple criteria; array; does not contain

    Hi Folks,

    Firstly: all this is for a dynamic table called StockListTable.

    I have a Column (Header = Owner) containing numbers representing customer numbers (1 to 150 plus 998 and 999).
    I wish...
  7. Re: Workbook SaveAs private function to include date & time stamp - saved file won't open

    Hi Norie,

    Thanks for sharing this: seems really useful for this & similar code!

    Kind regards,

    Doug.
  8. Re: Workbook SaveAs private function to include date & time stamp - saved file won't open

    Hi Norie,

    That has solved the issue!
    Thank you for helping me :)

    I guess the other format---xlWorkbookNormal---can be read without opening?

    Kind regards,

    Doug.
  9. Workbook SaveAs private function to include date & time stamp - saved file won't open

    Hi Folks,

    I discovered some VBA to be able to save a workbook with a custom filename that contains date and time stamp.
    My goal is just to save the file as *.xlsx.

    The code below works in...
  10. Re: VBA to overwrite an existing excel file (SaveAs) when you only know the File Path?

    Hi JLGWhiz,



    This is a reasonable question. In general, I was interested in knowing if the SaveAs Dialog box could be programmed to retrieve the filename from the directory because our...
  11. Re: VBA to overwrite an existing excel file (SaveAs) when you only know the File Path?

    Hi JLGWhiz,

    This afternoon I've managed to find code to mostly achieve what I was looking for by modelling the filename format that exports from our system.

    Public Sub:


    Public Sub...
  12. Re: VBA to overwrite an existing excel file (SaveAs) when you only know the File Path?

    Hi JLGWhiz,

    Thanks for your reply.

    Apologies, I've not explained myself too well---hopefully I am more precise this morning.


    I have compiled modelA.xltx that imports FileA.xlsx from...
  13. VBA to overwrite an existing excel file (SaveAs) when you only know the File Path?

    Hi Folks,

    I have a VBA model (*.xltx in draft stage) in which I import a specific excel file (containing multiple ws) from a specific file path. I am modifying some of the data. Once modified, I...
  14. Re: Run-time error '1004': Method 'Activate' of object '_Workbook' failed only on new PC

    Hi Steve the fish,

    Just got back from my vacation. The IT dept who own the model emailed me to let me know that they do not wish it altered (it's beyond my level, and it's beyond their capacity to...
  15. Re: Run-time error '1004': Method 'Activate' of object '_Workbook' failed only on new PC

    Hi Steve the fish,

    I ran the model again this morning to double check and found that the line was further down the same page of code:
    Here is the culprit macro


    Public Sub...
  16. Run-time error '1004': Method 'Activate' of object '_Workbook' failed only on new PC

    Hi Folks,

    I have an old excel model last modified in 2010 that was written by a pretty decent VBA / SQL programmer who has since deceased.

    All our old machines are running Windows 7...
  17. Re: Curious problem with a find and replace macro?

    Hi Fluff,

    That's really useful information to know (using ~ prior to ' and * in order for excel to interpret them as text characters).

    I changed the Find and replace table formatting to text...
  18. Re: Curious problem with a find and replace macro?

    Hi Fluff,

    Thanks for the reply,

    Your modification seems to work the same way (i.e., replacing the whole cell with the replace element (#) as the original code, albeit more efficient code.
    ...
  19. Curious problem with a find and replace macro?

    Hi Folks,

    I have a column of data (column H) headed [customer reference]. Customer reference data is populated by users when they book a courier online.



    They have to input a client...
  20. Re: Temporarily altering the Options-->Save-->Save files in this format settings via VBA?

    Hi Norie,

    Thanks for your reply, much appreciated!

    So I had to look into what other users are doing as many use similar templates saved to their local network.
    It turns out that users tend to...
  21. Temporarily altering the Options-->Save-->Save files in this format settings via VBA?

    Hi Folks,

    We have an old excel model whose VBA code pw protected. The model only imports *.xls format excel files.

    There is an excel template file which the operative uses to generate the...
  22. VBA to move files from one location to another - Run-time error '13' Type mismatch

    Hi Folks,

    I have developed some VBA code to move files from a source destination to a target destination.

    For example:


    <tbody>
    Item Code (A1)
    File path (B1)
  23. Re: Re-opening a *.xltm file - name sequentially changes by +1 every time it's opened?

    Hi John,

    Thanks for suggesting this. I will read a bit on using Global variables as I'm not too familiar with them.

    Kind regards,

    Doug.
  24. Re: Re-opening a *.xltm file - name sequentially changes by +1 every time it's opened?

    Hi Kamolga,

    This method allows a workaround if there isn't a convenient or known a way of referring to ActiveWorkbook in a particular operation, thanks for suggesting it. I will try and find a...
  25. Re: Re-opening a *.xltm file - name sequentially changes by +1 every time it's opened?

    Hi Norie,

    Thanks for your suggestion. I had a look online afterwards and discovered the following which I have applied to my macro:


    wrk = ActiveWorkbook.Name
    Application.Run ("'" & wrk &...
Results 1 to 25 of 115
Page 1 of 5 1 2 3 4