vba to create a folder based on a path in the open workbook cell
I want to use vba to create a folder based on a path saved in the
Open workbook,
…![Excel]()
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user int...
Read more- 144K Content
- 12K Contributors
Expert Spotlight
Finance Analyst
30 years in Financial Services and Management Accounting. CIMA trained but prefer the technical or system aspects of accounting.
Leading Experts In
Troubleshooting Question
Troubleshooting Question
SharePoint Issue with Excel sheet with hyperlinks
Hello,
We have an Excel spreadsheet within a SharePoint folder that for whatever reason the
…
Advice Question
How to format Microsoft Forms Excel responses for time sheets
We want to implement a new time sheet solution for our employees. We are used to them sending us
…
Troubleshooting Question
Moving rows by value
Hello,
I got the following from youtube and added to it to meet my needs (just added a little bit.)
…
Advice Question
Excel Data Model - Equivalent of vlookup in worksheet table to cross-ref Data Model Table
I have a table in the data model (loaded from a query) with only 2 columns: (1) ID, which is a text
…
Troubleshooting Question
Highlight Closest Value based on another cell value.
I have a number in cell M14 and a table with a range of a3-j3 (this includes headers) that can
…
Troubleshooting Question
EXcel first in first out 12 month expiration time
Column a is the month, Column b is the monthly Generation credits and Column c is the month amount
…
Troubleshooting Question
Adding a picture from Excel using HTML
I need to insert an image in HTML code that I already created for Excel to send a message to all
…
Troubleshooting Question
Converting Cells with Excel formula into Power Query
Hello,
I'm new to Power Query. I'm working on a project where I still need to convert formulas I
…
Troubleshooting Question
macros not digitally signed in excel 2003
A customer of mine, running windows 7 with microsoft excel 2003 had me change his hard drive to a
…
Research Question
Looking for afterhour input excel template
Hi experts,
I need help from the IT professionals to check if anyone is using excel file to track
…
Troubleshooting Question
Create Hyperlink to Excel Sheets on Sheet 1
I have created some code with Python that extracts historical stock data. I want the first page to
…
Troubleshooting Question
Excel VBA code to copy data from several spreadsheets to a master spreadsheet based on a criteria
Experts,
I have an Excel VBA question about copying data from 8 spreadsheets into a master
…
Advice Question
Programmatically access Microsoft 365 Copilot from an Office Add-In
As a C# developer with experience using VSTO to create add-ins for Excel and Word, I'm very
…
Troubleshooting Question
Is there a way or workaround to auto refresh the excel file without opening it ?
Hello,
Is there a way or workaround to auto refresh the excel file without opening it ?
Thank you.
Troubleshooting Question
Excel VBA Code - Copying Image To Wrong Sheet
The following Excel VBA code executes when a spreadsheet is opened on a schedule to achieve.an
…
Troubleshooting Question
Convert Excel to XSD Schema
Experts,
I have to load data into a web-based database where I can enter each record manually by
…
Troubleshooting Question
Office 365 lost recent and pinned files list
I have lost my pinned and recent files list in excel and word 365. see screenshots of another
…
Troubleshooting Question
Date Picker (Pop Up Calender)
Please add solution in attached excel. Thanks!
How to:
1. add code so that on
…
Advice Question
Dynamic value list in excel
Is it possible to have a dynamic value list?
If a value is used once in a column, can it be hidden
…Explore solutions and more
![Excel]()
Microsoft ExcelBack to the top
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.